function _getCLMKBrett(&$options) { $sid = CLMModelInfo::CLMSid(); $ligen = CLMModelInfo::CLMLigen(); $db = JFactory::getDBO(); $id = @$options['id']; $query = " SELECT brett,COUNT(id) as sum FROM #__clm_rnd_spl " . ' WHERE FIND_IN_SET(lid,"' . $ligen . '") != 0' . " AND sid = {$sid} AND heim = 1" . " AND ergebnis > 2" . " GROUP BY brett " . " ORDER BY brett ASC "; return $query; }
function _getCLMKBrett(&$options) { $sid = CLMModelInfo::CLMSid(); $db = JFactory::getDBO(); $id = @$options['id']; $query = " SELECT brett,COUNT(id) as sum FROM #__clm_rnd_spl " . " WHERE sid = {$sid} AND heim = 1" . " AND ergebnis > 2" . " GROUP BY brett " . " ORDER BY brett ASC "; return $query; }