SELECT p.`id`, p.`url`, p.`name` FROM `catalog_products` AS p LEFT JOIN `catalog_filters` AS f ON p.id = f.parent_id WHERE
( (f.name = 'Цвет' AND f.VALUE = '333123123') ) AND ( (f.name = 'test' AND f.VALUE = '333') )