Marty
Member Snapshot
Location: Gateshead
Member since: 17th June 2008
Ethical Superstore staff
8 e-Views: Helpful (32) Passionate (15) see all »
4 Lists see all »
About: Product Information Assistant @ EthicalSuperstore.com
Drummer, snapper, wordsmith, fooser, tea-drinker, toastie-eater.
read more »
Database Error
SQL: select count(distinct pr.products_id) as total from product_reviews AS pr left join product_questions_helpful AS pqh on pr.product_reviews_id = pqh.product_questions_id LEFT JOIN customers AS c USING (customers_id) WHERE pr.authorised = 1 AND pr.product_reviews_type_id = 3 AND pr.customers_id='55582' GROUP BY pr.product_reviews_id Error: Column 'customers_id' in from clause is ambiguous (1052) URL: www.ethicalsuperstore.com/profile/view_questions/55582/) Date: Fri, 10 Feb 2012 11:54:58 +0000
SQL: select count(distinct pr.products_id) as total from product_reviews AS pr left join product_questions_helpful AS pqh on pr.product_reviews_id = pqh.product_questions_id LEFT JOIN customers AS c USING (customers_id) WHERE pr.authorised = 1 AND pr.product_reviews_type_id = 3 AND pr.customers_id='55582' GROUP BY pr.product_reviews_id Error: Column 'customers_id' in from clause is ambiguous (1052) URL: www.ethicalsuperstore.com/profile/view_questions/55582/) Date: Fri, 10 Feb 2012 11:54:58 +0000