SELECT tbIgre.*,
days_to_go AS leftTime,
DATE_FORMAT(datum_vnosa,'%e.%c.%y') as vnos,
COUNT(tbKomentarji.id) AS komentarjev
FROM nageigre__igre AS tbIgre
LEFT JOIN nageigre__komentarji AS tbKomentarji ON tbIgre.id=tbKomentarji.igraID
WHERE tip LIKE '%Ibiza za 2 osebi%' OR tip LIKE '%Odigrajte spletno igrico Sava Extreme%' OR tip LIKE '%mobiteli%' OR tip LIKE '%20 000 evrov%' OR tip LIKE '%dirkanje%' OR tip LIKE '%ekološki bombaž%' OR tip LIKE '%apple%' OR tip LIKE '%moški%' OR tip LIKE '%Agniyoga%' OR tip LIKE '%pijaèa%' OR tip LIKE '%papaya%' OR tip LIKE '%nagradno vprašanje%' OR tip LIKE '%luksuzen hotel%' OR tip LIKE '%nagradni nateèaj%' OR tip LIKE '%Zeleni zabojèek%' OR tip LIKE '%avtorska fotografija%'
GROUP BY tbIgre.id
HAVING leftTime <= 1002
ORDER BY datum_vnosa DESC
--- Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation 'like'
ZADE.TK - vse nagradne igre - 81 nagradnih iger | Barcelona All Inclusive
