dbTable.Select: Could not query table SQL:select P.*, T.*, PO.po_extraCharge, (case when pt_canHavePrice = 1 and ifnull(po_extraCharge, 0) = 0 then 0 else pk_price end) calc_price from (select pk_id, pk_packageType, pk_schedule, '' pk_designer, pk_planID, pk_name, pk_price from Packages where ifnull(pk_designer, '') = '') P join (select * from plans where id = ) PL on PL.designer = P.pk_designer join PackageTypes T on P.pk_packageType = T.pt_id left join DesignerPackageTypes DPT on DPT.dp_packageTypeID = T.pt_id and DPT.dp_designer = PL.designer left join (select * from PlanOptions where po_planId = ) PO on P.pk_packageType = PO.po_packageType where (T.pt_category <> 'plans' OR (T.pt_category = 'plans' and DPT.dp_packageTypeID > 0) ) AND ( ( PL.priceSchedule = P.pk_schedule or ( ( P.pk_schedule = '' and pk_planID < 0 ) or ( P.pk_schedule = '' and pk_planID = PL.id ) ) ) and ( T.pt_isConditional = 0 or P.pk_packageType = ifnull(PO.po_packageType,-1) ) ) and (PL.isHousePlan = 1 or T.pt_isOnlyForHomes = 0) order by T.pt_sortOrder MySql Error: 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 ') PL on PL.designer = P.pk_designer join PackageTypes T on P.pk_packageTyp' at line 7