Запрос №1
CODE (text):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT count(DISTINCT product.id)
- FROM `product`
- JOIN `city` ON city.id=product.city_id
- JOIN `company` ON company.id=product.company_id
- WHERE ((((`product`.`id` in (
- select product_id from product_to_city
- join city on (city.id = product_to_city.city_id)
- where city.id = 104 or city.parent_id = 104
- )))) AND (`product`.`publish` = 1 AND `product`.`archive` != 1 AND `product`.`delete` != 1));