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 '%fitnes%' OR tip LIKE '%Ĺľenske%' OR tip LIKE '%nagradne igre%' OR tip LIKE '%vstopnice%' OR tip LIKE '%glasovanje%'
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
