SELECT pd77.crkp_id, pd77.projectname AS name, pd77.logo, pd77.account, pd77.projectgroup, account.name AS accountname, spec_project.name AS projectname, spec_project.name_url AS projectname_url FROM pd77 LEFT JOIN account ON account.acc_id = pd77.account LEFT JOIN account_info ON account.acc_id = account_info.acc_id LEFT JOIN spec_project ON spec_project.id = pd77.projectgroup WHERE (pd77.account = '1003841') AND (pd77.published = '1' AND pd77.approved = '1') ORDER BY pd77.crkp_id DESC, price_min ASC, price ASC LIMIT 3
Unknown column 'pd77.projectname' in 'field list'
Problems with your sql statement.
SELECT pd77.crkp_id, pd77.projectname AS name, pd77.logo, pd77.account, pd77.projectgroup, account.name AS accountname, account.nameth AS accountnameth, spec_project.name AS projectname, spec_project.name_url AS projectname_url, account.nameth AS accountname, account_info.name_url FROM pd77 LEFT JOIN account ON account.acc_id = pd77.account LEFT JOIN account_info ON account.acc_id = account_info.acc_id LEFT JOIN spec_project ON spec_project.id = pd77.projectgroup WHERE (pd77.account IN (1003841)) AND (pd77.published = '1' AND pd77.approved = '1') ORDER BY pinned DESC, projectname DESC, price_min ASC, price ASC
Unknown column 'pd77.projectname' in 'field list'
บัตรเครดิต/บัตรเดบิต แบงค์ออฟไชน่า แบงค์ออฟไชน่า (Bank of China) ราคา-สเปค-โปรโมชั่นล่าสุด | เช็คราคา.คอม