Notice: Undefined variable: geoData in /home/b/bsemen/ on line 780 Notice: Trying to get property of non-object in /home/b/bsemen/ on line 780
SELECT `d`.*, "doctor" AS `type`, (SELECT COUNT(*) FROM `db_review` WHERE `idDoctor` = `d`.`id` AND `published` = 1) AS `opinionCount` FROM `db_doctor` AS `d` LEFT JOIN `db_doctor_speciality` AS `ds` ON `ds`.`d_id` = `d`.`id` WHERE `ds`.`s_id` = 94 AND `d`.`idCity` = AND `d`.`published` = 1 ORDER BY `d`.`internalRating` DESC LIMIT 10
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 `d`.`published` = 1 ORDER BY `d`.`internalRating` DESC LIMIT 10' at line 1