GET 15% OFF first order with Email Signup | Terms | Returns & Exchange | Shipping | Privacy
Advanced
Search
(818) 484-3275

 
1052 - Column 'products_id' in field list is ambiguous

SELECT DISTINCT products_id,products.products_external_url,products.forawrd_product_attribute_detail, if(products_to_categories.sort_order = 0, 9999999, products_to_categories.sort_order) as product_in_category_sort FROM products, products_to_categories, manufacturers WHERE products_status = 1 AND products_public = 1 AND products.products_id = products_to_categories.products_id AND products_to_categories.categories_id='71' AND manufacturers_id ='12' AND products.manufacturers_id = manufacturers.manufacturers_id AND manufacturers.manufacturers_status = 1 and products_external_url = '' ORDER by product_in_category_sort, products_id

[TEP STOP]