Veritabanında bir hata oluştu.
Error Number: 1054
Unknown column 'js' in 'where clause'
SELECT `a`.*, `b`.`title` cityName, `c`.`title` townName, `d`.`title` districtName FROM (`bayiservis` a) LEFT JOIN `city` b ON `a`.`cityId` = `b`.`cityId` LEFT JOIN `town` c ON `a`.`cityId` = `c`.`cityId` and a.townId = c.townId LEFT JOIN `district` d ON `a`.`cityId` = `d`.`cityId` and a.townId = d.townId and a.districtId = d.districtId WHERE substr(a.companies, 9,1) = 1 AND `a`.`sirkettipi` = 'tr' AND substr(a.servistipi, js,1) = 1 AND `a`.`appActiveStatus` = 'nothing' AND `a`.`appLastStatus` = 'approved' ORDER BY `cityName` asc, `townName` asc, `sirket` asc
Filename: /home/ema78om/public_html/models/bayi_model.php
Line Number: 52