SELECT SQL_CALC_FOUND_ROWS `item`.*, `rel`.`category`, MAX(`var`.price) as `query_price_max`, MIN(`var`.price) as `query_price_min`, COUNT(`category`.id) as `cats_count`, SUM(`category`.enabled) as `cats_enabled`, COUNT(DISTINCT `var`.id) as `vars_filtered` FROM `pm_module_catalog_items` as `item` LEFT JOIN `pm_module_catalog_variants_relations` as `rel` ON `rel`.item = `item`.id LEFT JOIN `pm_module_catalog_variants` as `var` ON `rel`.variant = `var`.id LEFT JOIN `pm_module_catalog_variants_relations` as `rel2` ON `var`.id = `rel2`.variant LEFT JOIN `pm_module_catalog_categories` as `category` ON `rel2`.category = `category`.`id` WHERE `rel`.category = 63 AND `item`.`enabled`=1 AND `var`.`enabled`=1 AND (`var`.`price`>=400 AND `var`.`price`<=500) GROUP BY `item`.id HAVING `cats_count` = `cats_enabled` ORDER BY `category`.`position`, `category`.`id`, `item`.`position`, `item`.`id` LIMIT 0, 48
интернет-магазин вещей по аниме, фильмам, сериалам и играм
