CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT count(*)
- FROM `product`
- WHERE ((((`product`.`id` IN (
- SELECT product_id FROM product_to_city
- JOIN city ON (city.id = product_to_city.city_id)
- WHERE city.id = 1 OR city.parent_id = 1
- )))) AND (`product`.`publish` = 1 AND (`product`.`delete` = 0 OR `product`.`delete`
- IS NULL))) AND (product.id IN (SELECT product_id FROM product_to_category
- WHERE category_id IN (SELECT id FROM category WHERE parent_id IN
- (11))))