NUM: 0

SELECT swp.*, IFNULL(swp.price, sp.price) as price, sp.page_title, sp.promo_text, sp.promo_desc FROM (`ra_shop_showcase` as sw) JOIN `ra_shop_showcase_catalog` as swc ON `sw`.`showcase` = `swc`.`showcase_id` JOIN `ra_shop_showcase_products` as swp ON `swp`.`showcase_catalog_id` = `swc`.`showcase_catalog_id` JOIN `ra_shop_product` as sp ON `sp`.`product_id` = `swp`.`product_id` JOIN `ra_shop_categories` as sc ON `sc`.`category_id` = `sp`.`category_id` WHERE `sw`.`active` = 1 AND sw.city_id = 0 AND sc.category_url = "dostavka" AND swp.active = 1

Array
(
)