QUERY: select count(*) as count FROM products p JOIN ( SELECT products_id FROM products_to_categories WHERE categories_id in (64) GROUP BY products_id ) AS p2c ON(p.products_id = p2c.products_id) left join products_attributes pa ON pa.products_id = p.products_id left join products_options_values pov ON pov.products_options_values_id = pa.options_values_id INNER JOIN products_specifications ps6 ON p.products_id = ps6.products_id left join products_attributes pa ON pa.products_id = p.products_id left join products_options_values pov ON pov.products_options_values_id = pa.options_values_id WHERE p.products_status = 1 AND p.products_quantity > 0 and pa.attributes_stock > 0 and pov.products_options_values_name in ('L') AND ps6.language_id = 1 AND ps6.specifications_id = 6 AND ps6.specification in ('Бежевый') and pa.attributes_stock > 0 and pov.products_options_values_name in ('XL')
ERROR: Not unique table/alias: 'pa'