TommyJ
(Real Name: Tommy Jackson)
Ethical Superstore staff
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='17806' GROUP BY pr.product_reviews_id Error: Column 'customers_id' in from clause is ambiguous (1052) URL: www.ethicalsuperstore.com/profile/view_questions/17806/) Date: Fri, 10 Feb 2012 12:25:35 +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='17806' GROUP BY pr.product_reviews_id Error: Column 'customers_id' in from clause is ambiguous (1052) URL: www.ethicalsuperstore.com/profile/view_questions/17806/) Date: Fri, 10 Feb 2012 12:25:35 +0000