SQL Statement Debugger

Record::get_records_for_sql()

SELECT
  (SELECT COALESCE(GROUP_CONCAT(`ID`)) FROM `postings` `po` where `po`.`personID` = `p`.`ID` AND (`po`.`date`='0000-00-00' OR `po`.`date`<= NOW()) AND (`po`.`date_end`='0000-00-00' OR `po`.`date_end`>= NOW()) AND `po`.`type`='custom coupon') `coupons`,
  (SELECT COALESCE(GROUP_CONCAT(`ID`)) FROM `postings` `po` where `po`.`personID` = `p`.`ID` AND (`po`.`date`='0000-00-00' OR `po`.`date`<= NOW()) AND (`po`.`date_end`='0000-00-00' OR `po`.`date_end`>= NOW()) AND `po`.`type`='survey') `draws`,
  (SELECT COALESCE(GROUP_CONCAT(`ID`)) FROM `postings` `po` where `po`.`personID` = `p`.`ID` AND (`po`.`date`='0000-00-00' OR `po`.`date`<= NOW()) AND (`po`.`date_end`='0000-00-00' OR `po`.`date_end`>= NOW()) AND `po`.`type`='custom-video') `videos`,
  (SELECT COALESCE(GROUP_CONCAT(`ID`)) FROM `postings` `po` where `po`.`personID` = `p`.`ID` AND (`po`.`date`='0000-00-00' OR `po`.`date`<= NOW()) AND (`po`.`date_end`='0000-00-00' OR `po`.`date_end`>= NOW()) AND `po`.`type`='a') `articles`,
  (SELECT COALESCE(GROUP_CONCAT(`ID`)) FROM `postings` `po` where `po`.`personID` = `p`.`ID` AND (`po`.`date`> NOW()) AND `po`.`type`='e') `events`,
  `p`.*
FROM
  `person` `p`
WHERE
  `p`.`ID`=

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 11

Call stack trace:
[10] Record::get_record_for_sql() via /var/www/clients/client5/web90/web/custom.php line 2502
[09] Custom_Marketplace::_get_member_profile() via /var/www/clients/client5/web90/web/custom.php line 1684
[08] Custom_Marketplace::draw_profile() via /var/www/2380/codebase.php(982) : eval()'d code line 3
[07] eval() via /var/www/2380/codebase.php line 982
[06] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[05] convert_safe_to_php() via /var/www/2380/codebase.php line 982
[04] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[03] convert_safe_to_php() via /var/www/2380/classes/class.layout.php line 133
[02] Layout::prepare() via /var/www/2380/system.php line 189
[01] main() via /var/www/2380/functions.php line 151
[00] include() via /var/www/clients/client5/web90/web/index.php line 5
Profile
Skip to Content