示例#1
0
 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;
 }
示例#2
0
 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;
 }