SELECT DISTINCT `c`.`product_id`
FROM `product_category` AS `c`
JOIN `product_attribute` AS `a1` ON `a1`.`product_id` = `c`.`product_id`
AND `a1`.`attribute_id` = :attribute1 AND `a1`.`text` = :attrValue1
...
WHERE `c`.`category_id` = :categoryIdSELECT `t`.*
FROM (
SELECT `product_id`, DATE(MAX(`created`)) AS `date`
FROM `table`
WHERE `product_id` = :id
) AS `d`
JOIN `table` AS `t` ON `t`.`created` >= `d`.`date`
AND `t`.`product_id` = `d`.`product_id`SELECT `t`.*
FROM (
SELECT DATE(MAX(`created`)) AS `date`
FROM `table`
) AS `d`
JOIN `table` AS `t` ON `t`.`created` >= `d`.`date`
WHERE `t`.`product_id` = :idSELECT `t`.`entity_id`
FROM `entity` AS `t`
JOIN `value` AS `t1` WHERE `t1`.`entity_id` = `t`.`id`
JOIN `value` AS `t2` WHERE `t2`.`entity_id` = `t`.`id`
...
JOIN `value` AS `tN` WHERE `t3`.`entity_id` = `t`.`id`
WHERE `t`.`type` = 'product'
AND `t1`.`attribute_id` = :attribute1 AND `t1`.`value` = :value1
AND `t2`.`attribute_id` = :attribute2 AND `t2`.`value` = :value2
...
AND `tN`.`attribute_id` = :attributeN AND `tN`.`value` = :valueN
</sql>