AndyR
(Real Name: Andy Redfern)
Member Snapshot
Name: Andy Redfern
Location: Gateshead, UK
Member since: 16th November 2005
Ethical Superstore staff
7 e-Views: Helpful (12) Passionate (9) see all »
5 Lists see all »
About: Co-founder of Ethical Superstore. 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='402' GROUP BY pr.product_reviews_id Error: Column 'customers_id' in from clause is ambiguous (1052) URL: www.ethicalsuperstore.com/profile/view_questions/402/) Date: Fri, 10 Feb 2012 13:35:55 +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='402' GROUP BY pr.product_reviews_id Error: Column 'customers_id' in from clause is ambiguous (1052) URL: www.ethicalsuperstore.com/profile/view_questions/402/) Date: Fri, 10 Feb 2012 13:35:55 +0000