sql dogru ama ezsql hata veriyor

$lisanssızcevir="case when tbl.tahsilat IS lisanssız then 0 else tbl.tahsilat end";

$sorgu="SELECT tbl.cid, tbl.ad, tbl.tutar, tbl.tahsilat, (tbl.tutar- ($lisanssızcevir)) as bakiye FROM (SELECT tbl_cari.id AS cid, SUM(tbl_sozlesme.sozlesmetutari) AS tutar, SUM(tbl_tahsilat.tutar) AS tahsilat, tbl_sozlesme.pazarlamaciid AS pid, tbl_cari.ad AS ad, tbl_cari.ajansid as aidfdd FROM tbl_sozlesme RIGHT OUTER JOIN tbl_cari ON tbl_sozlesme.cariid = tbl_cari.id LEFT OUTER JOIN tbl_tahsilat ON tbl_cari.id = tbl_tahsilat.cariid  where  tbl_cari.ajansid = $ajansid GROUP BY tbl_cari.id, tbl_sozlesme.pazarlamaciid, tbl_cari.ad) tbl   $kriter $kritersiralama $artanazalan"; 



$ezr->query_mysql($sorgu);
$ezr->display();

Warning: Unknown column 'tbl.ad' in 'order clause' in /home/ereklam/public_html/siteadi/ezsql/mysql/ez_sql_mysql.php on line 204
0 Kayıt Bulundu