New Arrivals
Not unique table/alias: 'products_attributes'QUERY: Select items.* from products_attributes
inner join products_attributes on id_item = product_id
left join items on items.id_item = product_id
left join attributes on attribute_id = id_attribute
where products_attributes.attribute_id = 2 and products_attributes.value = 'yes' and items.valid = 1 and attributes.name like '%Brand%' and products_attributes.value like '%Beach Bunny%' ORDER BY items.id_item DESC 