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 '%knjiga%' OR tip LIKE '%nagradni natečaj%' OR tip LIKE '%kozmetika%' OR tip LIKE '%igra%' OR tip LIKE '%revija%' OR tip LIKE '%hujšanje%' OR tip LIKE '%film%' OR tip LIKE '%kviz%' OR tip LIKE '%pralne plenice%' OR tip LIKE '%kino šiška%' OR tip LIKE '%chris rea%' OR tip LIKE '%email%' OR tip LIKE '%inbox%' OR tip LIKE '%Ab tronic%' OR tip LIKE '%potovanje%' OR tip LIKE '%križanke%' OR tip LIKE '%novice%' OR tip LIKE '%bon%' OR tip LIKE '%prijava%' OR tip LIKE '%glasba cd album%' OR tip LIKE '%dom%' OR tip LIKE '%podatki%' OR tip LIKE '%šport%' OR tip LIKE '%majice%' OR tip LIKE '%otroci%' OR tip LIKE '%infoscena%' OR tip LIKE '%glasba%' OR tip LIKE '%olimpija%' OR tip LIKE '%balkanbeats%' OR tip LIKE '%seka%' OR tip LIKE '%guns%' OR tip LIKE '%gavioli%' OR tip LIKE '%roses%' OR tip LIKE '%London%' OR tip LIKE '%letalske karte%' OR tip LIKE '%roger%' OR tip LIKE '%NJAMI%' OR tip LIKE '%dance%' OR tip LIKE '%valjak%' OR periodika LIKE 'mesecna' OR periodika LIKE 'tedenska' OR periodika LIKE 'enkratna'
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
