SELECT t2.*, (SELECT COUNT(id) AS opin FROM opinie WHERE ido=t2.id) AS opinie, IF(t3.punkty>0,t2.kwota,0) AS xxx
FROM tablicapp_noclegi AS t2
LEFT JOIN apple_users AS t3 ON t2.wytworzyl=t3.mail
WHERE ((t2.op1=:l_id_grupy OR t2.op2=:l_id_grupy OR find_in_set(:l_id_grupy, t2.op1d)) AND t2.blok!='tak' AND t2.katalog!='')
ORDER BY xxx DESC, t2.id DESC
LIMIT :l_ileteraz, :l_seria_il
Noclegi Łomnica
