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%' OR tip LIKE '%karting%' OR tip LIKE '%raèunalnik%' OR tip LIKE '%pohištvo%' OR tip LIKE '%eko otroška oprema%' OR tip LIKE '%Sreèelov%' OR tip LIKE '%kozmetika Melvita%' OR tip LIKE '%avtomobili%' OR tip LIKE '%orto trip%' OR tip LIKE '%oblaèila%' OR tip LIKE '%Nissan%' OR tip LIKE '%potovanja%' OR tip LIKE '%2 vstopnici za diskoteko Pacha%' OR tip LIKE '%gokard%' OR tip LIKE '%kupnina nazaj ali vrednostni bon%' OR tip LIKE '%novalja%' OR tip LIKE '%priplavajte si privlaène tedenske nagrade%' OR tip LIKE '%hujšanje%' OR tip LIKE '%10-dnevno kriĹľarjenje po Karibih%' OR tip LIKE '%LCD TV potovanje mobitel avto%' OR tip LIKE '%orto%' OR tip LIKE '%otroški bodiji%' OR tip LIKE '%formula 1%' OR tip LIKE '%adidas%' OR tip LIKE '%kriĹľanke%' OR tip LIKE '%izlet%' OR tip LIKE '%nagradn igra%' OR tip LIKE '%DRES%' OR tip LIKE '%obleka%'
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
