WordPress database error: [Unknown column 'mls.LM_Char10_13' in 'field list']
SELECT DISTINCT LPAD(mun.PID, 8, '0') as munPID, mls.LM_Int2_20 as LM_Int2_20, mls.LM_Char25_1 as LM_Char25_1, mls.L_ListingDate as L_ListingDate, mls.L_StatusDate as L_StatusDate, mls.L_Type_ as L_Type_, mls.L_StatusCatID as L_StatusCatID, mls.LM_Char10_29 as LM_Char10_29, mls.LM_char30_15 as LM_char30_15, mls.LM_Char10_13 as LM_Char10_13, mls.LR_remarks11 as LR_remarks11, mls.L_AskingPrice as L_AskingPrice, mls.LM_char100_3 as LM_char100_3, mls.L_DisplayId as L_DisplayId , mls.L_SaleRent as L_SaleRent, mls.LO1_OrganizationName as LO1_OrganizationName FROM MLS_MUL_Paragon AS mls INNER JOIN HRM_OpenData_CivicAddresses AS mun ON LEFT(mls.LM_Char25_1, 8) = mun.PID WHERE mun.CITY='DARTMOUTH' AND mls.L_Area='Halifax - Dartmouth' AND (SUBSTRING_INDEX(mls.LM_Char10_2, '-', 1) IN('10','11','12','13','14','15','16','17'))