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 periodika LIKE 'mesecna'
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
