Καλοδήμος Δημήτρης http://sep4u.gr SELECT sxoles_info_18.kod, sxoles_info_18.titlos, basgelh.basi as basgelh, basgele.basi as basgele, basepalh.basi as basepalh , basepale.basi as basepale , aeitei.bath FROM sxoles_info_18 LEFT JOIN ( SELECT baseis.kod, baseis.basi, baseis.etos, baseis.sch, baseis.pkat, baseis.ekat FROM baseis WHERE ( ((baseis.etos)=2018) AND ((baseis.sch)=1) AND ((baseis.pkat)=90) AND ((baseis.ekat)=1) ) ) as basgelh ON sxoles_info_18.kod = basgelh.kod LEFT JOIN ( SELECT baseis.kod, baseis.basi, baseis.etos, baseis.sch, baseis.pkat, baseis.ekat FROM baseis WHERE ( ((baseis.etos)=2018) AND ((baseis.sch)=2) AND ((baseis.pkat)=90) AND ((baseis.ekat)=1) ) ) as basgele ON sxoles_info_18.kod = basgele.kod LEFT JOIN ( SELECT baseis.kod, baseis.basi, baseis.etos, baseis.sch, baseis.pkat, baseis.ekat FROM baseis WHERE ( ((baseis.etos)=2018) AND ((baseis.sch)=3) AND ((baseis.pkat)=90) AND ((baseis.ekat)=1) ) ) as basepalh ON sxoles_info_18.kod = basepalh.kod LEFT JOIN ( SELECT baseis.kod, baseis.basi, baseis.etos, baseis.sch, baseis.pkat, baseis.ekat FROM baseis WHERE ( ((baseis.etos)=2018) AND ((baseis.sch)=4) AND ((baseis.pkat)=90) AND ((baseis.ekat)=1) ) ) as basepale ON sxoles_info_18.kod = basepale.kod INNER JOIN aeitei ON aeitei.idi= sxoles_info_18.idi where active='1' order by titlos
Fatal error: Uncaught Error: Undefined constant "kod" in /usr/www/users/ixorip/sep4u.gr/sos/baseis-all.php:143 Stack trace: #0 {main} thrown in /usr/www/users/ixorip/sep4u.gr/sos/baseis-all.php on line 143