You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND l.id=
AND (h.tarih BETWEEN s.bas_tarih AND s' at line 12
SELECT SQL_CALC_FOUND_ROWS fg.id,fgr.aciklama,CONCAT(fg.klasor_ad,'/',min(fgr.resim)) AS resim,
fg.galeri_ad
FROM (foto_galeri fg,foto_galeri_resimler fgr,foto_galeri_iller fgi)
LEFT JOIN haberler h ON(h.galeri_id=fg.id AND h.durum=1)
LEFT JOIN haber_iller hi ON(hi.haber_id=h.id)
LEFT JOIN ligler l ON(l.id=hi.lig_id)
LEFT JOIN sezon s ON(s.lig_id=l.id)
WHERE fgr.galeri_id=fg.id and (fgi.il_id=0 or 0=0 or fgi.il_id=0)
and fg.uygulama_id=4
AND (h.tip_id=4 OR 4=0) AND fg.id=fgi.foto_galeri_id
AND s.sene=
AND l.id=
AND (h.tarih BETWEEN s.bas_tarih AND s.bit_tarih)
group by fg.id
order by fg.id desc ,fgr.id
limit 0,15