1066 - Not unique table/alias: 'pa_meret'
select count(*) as total
from products_attributes pa left join products_attributes pa_meret using(products_id) left join products_attributes pa_meret using(products_id) left join products_attributes pa_szinek using(products_id)
left join products_to_categories ptc on pa.products_id = ptc.products_id
left join products p ON pa.products_id = p.products_id
where pa_meret.options_id = '6' and pa_meret.options_values_id = '59' and pa_meret.options_id = '6' and pa_meret.options_values_id = '289' and pa_szinek.options_id = '3' and pa_szinek.options_values_id = '152' and pa.options_id = '12' and pa.options_values_id = '257' and
ptc.categories_id = '77' AND p.products_status = 1
[TEP STOP]
|
