Featured Ads Section
42S22 - Unknown column 'u.suburb' in 'field list'.
SELECT u.*, u.points_init - u.points_used as points_available, IF(u.registry_type, "Individual", "Company") as registry_type_name, cc.name as country_name, IF(ssp.suburb!="", ssp.suburb, u.suburb) as suburb, IF(ssp.state!="",ssp.state,u.state) as state, IF(ssp.postcode!="",ssp.postcode,u.postcode) as postcode, concat(u.name," ",u.last_name) as contact_name, "" as payment_dues, "" as credit_limit, "" as credit_available, "" as credit_pastdue, "" as credit_onhold, bcc.name as b_country_name, IF(bssp.suburb!="", bssp.suburb, u.billing_suburb) as b_suburb, IF(bssp.state!="",bssp.state,u.billing_state) as b_state, IF(bssp.postcode!="",bssp.postcode,u.billing_postcode) as b_postcode, concat(u.name," ",u.last_name) as b_contact_name from user u LEFT JOIN configuration_country cc ON u.country_id=cc.id LEFT JOIN configuration_country bcc ON u.billing_country_id=bcc.id LEFT JOIN suburb_state_postcode ssp ON u.suburb_id=ssp.id LEFT JOIN suburb_state_postcode bssp ON u.billing_suburb_id=bssp.id WHERE `u`.`id` = ? LIMIT 1