SELECT * FROM os38h_category c LEFT JOIN os38h_category_description cd ON (c.category_id = cd.category_id) WHERE cd.language_id = 1 AND c.status = 1 ORDER BY c.parent_id, c.sort_order, cd.name Array
(
[category_id] => 181
[category_type] => 0
[category_nom] =>
[category_nom_original] =>
[image] =>
[parent_id] => 0
[top] => 0
[no_featured] => 0
[column] => 1
[sort_order] => 0
[sort_order_nom] => 0
[status] => 1
[date_added] => 2018-07-25 08:56:49
[date_modified] => 2020-03-12 16:45:18
[category_alias] =>
[language_id] => 1
[name] => Скидки
[name2] => Акция
[description] =>
[meta_description] =>
[meta_keyword] =>
[seo_title] =>
[seo_h1] =>
[city_title] => Доставка еды со скидкой в #CITYS#. Еда по акции с доставкой | just-eat.by
[city_h1] => Заказать еду с доставкой на дом по акции #CITYS#
[city_meta_description] => Заказать еду со скидкой на дом в Just-eat – хорошие цены, широкий выбор, заказ еды онлайн, скидки.
[city_meta_keyword] => доставка, акция, еда, скидка
[shop_title] => Доставка еды со скидкой из #SHOP#.
[shop_h1] => Скидки от #SHOP#
[shop_meta_description] => Быстрый и удобный выбор еды со скидкой и доставкой на дом из #SHOP# на Just-eat.by. Акции, бонусы, скидки все это вы найдете на нашем сайте.
[shop_meta_keyword] => еда, акция, скидки, #SHOP#, меню, бесплатная доставка
)
SELECT COUNT(DISTINCT p.shop_id) AS total FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = 1 AND p2c.category_id IN (128, 173, 175, 174) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 1
)
SELECT p.shop_id,p.product_id
FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id)
LEFT JOIN os38h_product_to_category ptc ON (p.product_id = ptc.product_id)
LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p2c.category_id IN (128, 173, 175, 174) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) GROUP BY p.shop_id ORDER BY sh.shop_openbase DESC, sh.shop_order ASC, LCASE(sh.shop_name) ASC LIMIT 0,12 Array
(
[shop_id] => 161969
[product_id] => 204257
)
SELECT shop_id, payment_code FROM os38h_shop_payment WHERE shop_id IN (161969) Array
(
[shop_id] => 161969
[payment_code] => cod
)
SELECT shop_id, map_id FROM os38h_shop_map WHERE shop_id IN (161969) Array
(
)
SELECT p.product_id FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = 1 AND p.status = 1 AND p2c.category_id IN (128, 173, 175, 174) AND p.shop_id = 161969 AND p.active = 1 GROUP BY p.product_id ORDER BY p.sort_order_list DESC, RAND() ASC, LCASE(pd.name) LIMIT 0,5 Array
(
[product_id] => 204257
)
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
(SELECT lcd.unit FROM os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 204257 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '204257' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1' Array
(
[product_id] => 204257
[shop_id] => 161969
[alias] => https://just-eat.by/cafe-lunch-smorgon/holodnye-zakuski/204257-syrnoe-plato.html
[alias_upd] => 0
[active] => 1
[model] => model-Сырное плато
[exist_options] => 0
[ch_konstrukt] => 0
[sku] =>
[category_nom_original] =>
[new] => 0
[from_rest] => 0
[act] => 0
[sale] => 0
[upc] =>
[ean] =>
[jan] =>
[isbn] =>
[mpn] =>
[location] =>
[quantity] => 9999999
[stock_status_id] => 7
[image] => data/shops/161969/204257.jpg
[manufacturer_id] => 0
[shipping] => 1
[price] => 23.00
[percent_pickup] => 0.00
[price_pickup] => 0.00
[price_to] => 0.00
[price_spec] => 0
[points] => 0
[tax_class_id] => 0
[date_available] => 2023-06-28
[weight] => 200/30
[weight_to] =>
[pcs] =>
[liter] =>
[weight_class_id] => 1
[length] => 1.00000000
[width] => 1.00000000
[height] => 1.00000000
[length_class_id] => 1
[subtract] => 0
[minimum] => 1
[sort_order] => 80
[sort_order_nom] => 0
[sort_order_list] => 0
[sort_available] => 0
[status] => 1
[moderation] => 0
[date_added] => 2023-06-28 18:28:14
[date_modified] => 0000-00-00 00:00:00
[viewed] => 0
[time_start] => 00:00:00
[time_end] => 00:00:00
[affiliate_commission] => 0.00
[total_order] => 0
[kdj] => 0
[eck] => 922
[belki] => 35.4
[zhiri] => 29.4
[ugl] => 34.8
[srok_hraneniya] => 4.5 часа
[usl_hraneniya] => от +2 до +6 °С
[translate] =>
[super_product] => 0
[commision_percent] => 0.00
[undelivery_zones] =>
[it_freebie] => 0
[language_id] => 1
[name] => Сырное плато
[description] => Хрустящие сырные шарики, сыр Фетта в кунжутной панировке, сыр Филадельфия с хрустящим лавашом и тянущийся сыр Сулугуни в беконе. Подаётся с луковым мармеладом.
[predzakaz_text] =>
[video_description] =>
[short_description] =>
[meta_description] =>
[meta_keyword] =>
[seo_title] =>
[seo_h1] =>
[tag] =>
[discount] =>
[special] =>
[reward] =>
[stock_status] => В наличии
[weight_class] => кг
[length_class] => см
[main_category] => 128
)
SELECT * FROM os38h_product_prices WHERE product_id = '204257' AND `active` = 1 Array
(
)
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
(SELECT lcd.unit FROM os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 204264 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '204264' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1' Array
(
[product_id] => 204264
[shop_id] => 161969
[alias] => https://just-eat.by/cafe-lunch-smorgon/holodnye-zakuski/204264-sel-d-nezhnaya-s-kartofelem.html
[alias_upd] => 0
[active] => 1
[model] => model-Сельдь нежная с картофелем
[exist_options] => 0
[ch_konstrukt] => 0
[sku] =>
[category_nom_original] =>
[new] => 0
[from_rest] => 0
[act] => 0
[sale] => 0
[upc] =>
[ean] =>
[jan] =>
[isbn] =>
[mpn] =>
[location] =>
[quantity] => 9999999
[stock_status_id] => 7
[image] => data/shops/161969/204264.jpg
[manufacturer_id] => 0
[shipping] => 1
[price] => 12.00
[percent_pickup] => 0.00
[price_pickup] => 0.00
[price_to] => 0.00
[price_spec] => 0
[points] => 0
[tax_class_id] => 0
[date_available] => 2023-06-28
[weight] => 300
[weight_to] =>
[pcs] =>
[liter] =>
[weight_class_id] => 1
[length] => 1.00000000
[width] => 1.00000000
[height] => 1.00000000
[length_class_id] => 1
[subtract] => 0
[minimum] => 1
[sort_order] => 80
[sort_order_nom] => 0
[sort_order_list] => 0
[sort_available] => 0
[status] => 1
[moderation] => 0
[date_added] => 2023-06-28 18:32:07
[date_modified] => 0000-00-00 00:00:00
[viewed] => 0
[time_start] => 00:00:00
[time_end] => 00:00:00
[affiliate_commission] => 0.00
[total_order] => 0
[kdj] => 0
[eck] => 779
[belki] => 43.2
[zhiri] => 34.4
[ugl] => 44.4
[srok_hraneniya] => 24 часа
[usl_hraneniya] => от +2 до +6 °С
[translate] => null
[super_product] => 0
[commision_percent] => 0.00
[undelivery_zones] =>
[it_freebie] => 0
[language_id] => 1
[name] => Сельдь нежная с картофелем
[description] => Обжаренный до хрустящей корочки картофель с нежной сельдью и маринованным луком.
[predzakaz_text] =>
[video_description] =>
[short_description] =>
[meta_description] =>
[meta_keyword] =>
[seo_title] =>
[seo_h1] =>
[tag] =>
[discount] =>
[special] =>
[reward] =>
[stock_status] => В наличии
[weight_class] => кг
[length_class] => см
[main_category] => 128
)
SELECT * FROM os38h_product_prices WHERE product_id = '204264' AND `active` = 1 Array
(
)
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
(SELECT lcd.unit FROM os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 233046 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '233046' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1' Array
(
[product_id] => 233046
[shop_id] => 161969
[alias] => https://just-eat.by/cafe-lunch-smorgon/holodnye-zakuski/233046-ovoschnaya-doska.html
[alias_upd] => 0
[active] => 1
[model] => model-Овощная доска
[exist_options] => 0
[ch_konstrukt] => 0
[sku] =>
[category_nom_original] =>
[new] => 0
[from_rest] => 0
[act] => 0
[sale] => 0
[upc] =>
[ean] =>
[jan] =>
[isbn] =>
[mpn] =>
[location] =>
[quantity] => 9999999
[stock_status_id] => 7
[image] => data/shops/161994/233024.jpg
[manufacturer_id] => 0
[shipping] => 1
[price] => 14.00
[percent_pickup] => 0.00
[price_pickup] => 0.00
[price_to] => 0.00
[price_spec] => 0
[points] => 0
[tax_class_id] => 0
[date_available] => 2024-07-05
[weight] => 280
[weight_to] =>
[pcs] => 0
[liter] => 0
[weight_class_id] => 1
[length] => 1.00000000
[width] => 1.00000000
[height] => 1.00000000
[length_class_id] => 1
[subtract] => 0
[minimum] => 1
[sort_order] => 80
[sort_order_nom] => 0
[sort_order_list] => 0
[sort_available] => 0
[status] => 1
[moderation] => 0
[date_added] => 2024-07-05 10:59:18
[date_modified] => 2024-07-05 11:01:43
[viewed] => 0
[time_start] => 00:00:00
[time_end] => 00:00:00
[affiliate_commission] => 0.00
[total_order] => 0
[kdj] => 0
[eck] => 0
[belki] => 0
[zhiri] => 0
[ugl] => 0
[srok_hraneniya] => 24 часа
[usl_hraneniya] => от +2 до +6 °С
[translate] =>
[super_product] => 0
[commision_percent] => 0.00
[undelivery_zones] =>
[it_freebie] => 0
[language_id] => 1
[name] => Овощная доска
[description] => Свежие томаты, огурцы и перец, лук красный маринованный. Подаётся с соусом Ранч.
[predzakaz_text] =>
[video_description] =>
[short_description] =>
[meta_description] =>
[meta_keyword] =>
[seo_title] =>
[seo_h1] =>
[tag] =>
[discount] =>
[special] =>
[reward] => 0
[stock_status] => В наличии
[weight_class] => кг
[length_class] => см
[main_category] => 128
)
SELECT * FROM os38h_product_prices WHERE product_id = '233046' AND `active` = 1 Array
(
)
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
(SELECT lcd.unit FROM os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 204262 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '204262' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1' Array
(
[product_id] => 204262
[shop_id] => 161969
[alias] => https://just-eat.by/cafe-lunch-smorgon/holodnye-zakuski/204262-salo-po-domashnemu-s-polendvicey.html
[alias_upd] => 0
[active] => 1
[model] => model-Сало по-домашнему с полендвицей
[exist_options] => 0
[ch_konstrukt] => 0
[sku] =>
[category_nom_original] =>
[new] => 0
[from_rest] => 0
[act] => 0
[sale] => 0
[upc] =>
[ean] =>
[jan] =>
[isbn] =>
[mpn] =>
[location] =>
[quantity] => 9999999
[stock_status_id] => 7
[image] => data/shops/161969/204262.jpg
[manufacturer_id] => 0
[shipping] => 1
[price] => 21.00
[percent_pickup] => 0.00
[price_pickup] => 0.00
[price_to] => 0.00
[price_spec] => 0
[points] => 0
[tax_class_id] => 0
[date_available] => 2023-06-28
[weight] => 100/100/10/10
[weight_to] =>
[pcs] =>
[liter] =>
[weight_class_id] => 1
[length] => 1.00000000
[width] => 1.00000000
[height] => 1.00000000
[length_class_id] => 1
[subtract] => 0
[minimum] => 1
[sort_order] => 80
[sort_order_nom] => 0
[sort_order_list] => 0
[sort_available] => 0
[status] => 1
[moderation] => 0
[date_added] => 2023-06-28 18:31:02
[date_modified] => 0000-00-00 00:00:00
[viewed] => 0
[time_start] => 00:00:00
[time_end] => 00:00:00
[affiliate_commission] => 0.00
[total_order] => 0
[kdj] => 0
[eck] => 674
[belki] => 27.4
[zhiri] => 60
[ugl] => 21.3
[srok_hraneniya] => 24 часа
[usl_hraneniya] => от +2 до +6 °С
[translate] => null
[super_product] => 0
[commision_percent] => 0.00
[undelivery_zones] =>
[it_freebie] => 0
[language_id] => 1
[name] => Сало по-домашнему с полендвицей
[description] => Сало и полендвица, засоленные по фирменному рецепту. Подаются с хреном и свежим огурчиком.
[predzakaz_text] =>
[video_description] =>
[short_description] =>
[meta_description] =>
[meta_keyword] =>
[seo_title] =>
[seo_h1] =>
[tag] =>
[discount] =>
[special] =>
[reward] =>
[stock_status] => В наличии
[weight_class] => кг
[length_class] => см
[main_category] => 128
)
SELECT * FROM os38h_product_prices WHERE product_id = '204262' AND `active` = 1 Array
(
)
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class,
(SELECT lcd.unit FROM os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 204260 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '204260' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1' Array
(
[product_id] => 204260
[shop_id] => 161969
[alias] => https://just-eat.by/cafe-lunch-smorgon/holodnye-zakuski/204260-ushki-svinye.html
[alias_upd] => 0
[active] => 1
[model] => model-Ушки свиные
[exist_options] => 0
[ch_konstrukt] => 0
[sku] =>
[category_nom_original] =>
[new] => 0
[from_rest] => 0
[act] => 0
[sale] => 0
[upc] =>
[ean] =>
[jan] =>
[isbn] =>
[mpn] =>
[location] =>
[quantity] => 9999999
[stock_status_id] => 7
[image] => data/shops/161969/204260.jpg
[manufacturer_id] => 0
[shipping] => 1
[price] => 17.00
[percent_pickup] => 0.00
[price_pickup] => 0.00
[price_to] => 0.00
[price_spec] => 0
[points] => 0
[tax_class_id] => 0
[date_available] => 2025-08-31
[weight] => 190/80
[weight_to] =>
[pcs] =>
[liter] =>
[weight_class_id] => 1
[length] => 1.00000000
[width] => 1.00000000
[height] => 1.00000000
[length_class_id] => 1
[subtract] => 0
[minimum] => 1
[sort_order] => 80
[sort_order_nom] => 0
[sort_order_list] => 0
[sort_available] => 0
[status] => 1
[moderation] => 0
[date_added] => 2023-06-28 18:29:57
[date_modified] => 2025-08-31 16:04:49
[viewed] => 0
[time_start] => 00:00:00
[time_end] => 00:00:00
[affiliate_commission] => 0.00
[total_order] => 0
[kdj] => 0
[eck] => 914
[belki] => 25.7
[zhiri] => 28.6
[ugl] => 40
[srok_hraneniya] => 24 часа
[usl_hraneniya] => от +2 до +6 °С
[translate] => null
[super_product] => 0
[commision_percent] => 0.00
[undelivery_zones] =>
[it_freebie] => 0
[language_id] => 1
[name] => Ушки свиные
[description] => Хрустящие копчёные ушки в пикантных специях. Подаются с фирменным сырным соусом.
[predzakaz_text] =>
[video_description] =>
[short_description] =>
[meta_description] =>
[meta_keyword] =>
[seo_title] =>
[seo_h1] =>
[tag] =>
[discount] =>
[special] =>
[reward] =>
[stock_status] => В наличии
[weight_class] => кг
[length_class] => см
[main_category] => 128
)
SELECT * FROM os38h_product_prices WHERE product_id = '204260' AND `active` = 1 Array
(
)
SELECT category_id FROM os38h_product_to_category WHERE product_id = '204257' ORDER BY main_category DESC LIMIT 1 Array
(
[category_id] => 128
)
SELECT category_id FROM os38h_product_to_category WHERE product_id = '204264' ORDER BY main_category DESC LIMIT 1 Array
(
[category_id] => 128
)
SELECT category_id FROM os38h_product_to_category WHERE product_id = '233046' ORDER BY main_category DESC LIMIT 1 Array
(
[category_id] => 128
)
SELECT category_id FROM os38h_product_to_category WHERE product_id = '204262' ORDER BY main_category DESC LIMIT 1 Array
(
[category_id] => 128
)
SELECT category_id FROM os38h_product_to_category WHERE product_id = '204260' ORDER BY main_category DESC LIMIT 1 Array
(
[category_id] => 128
)
SELECT shop_min_price FROM os38h_shops WHERE shop_active = 1 AND shop_id IN (0,161969,182757) ORDER BY shop_min_price Array
(
[shop_min_price] => 20.00
)
SELECT COUNT(*) FROM os38h_shops WHERE shop_pickup = 1 AND shop_active = 1 AND shop_id IN (0,161969,182757) Array
(
[COUNT(*)] => 0
)
SELECT * FROM os38h_city_raion WHERE city_id =37 ORDER BY name Array
(
[raion_id] => 464
[city_id] => 37
[name] => Белковщина
[status] => 1
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (181) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (20, 176, 72, 142, 73, 170, 179, 177, 147, 197, 150, 198, 140, 143, 134, 237, 151, 74, 100, 98, 132, 152, 75, 157, 226, 201, 303, 76, 101, 156, 99, 182, 119, 178, 235, 154, 262, 195, 159, 148, 323, 180, 135, 289, 298, 153, 144, 299, 300, 302, 306, 121, 83) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 71
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (18, 326, 70, 286, 238, 66, 95, 89, 287, 133, 77, 239, 94, 169, 145, 290, 68, 97, 264, 96, 288, 149, 90, 110, 199, 93, 136, 78, 122, 79, 80, 69, 204, 84, 172, 87, 71) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 214
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (24) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 3
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (81) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 3
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (34) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (112) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 6
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (33, 158) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (67, 113, 116, 115, 117, 114) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 20
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (57, 167, 107, 108, 168, 109, 161, 162, 163, 164, 165) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (85) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 8
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (292) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (130) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 4
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (17) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 14
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (139) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 7
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (103) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (231) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (230) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (137) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (104) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (141) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (233) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (228) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (301) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (327) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (200) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (91) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (310) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (92) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (146) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (220) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 4
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (320) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (155) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (309) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (317) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (102) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 2
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (314) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (207) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (252) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (316) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (315) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (88) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (128, 173, 175, 174) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 7
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (127) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (321) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (324) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (63) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 22
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (86, 294, 295) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 3
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (124) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (203) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (227) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (166, 248, 249) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (120) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (131) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (118) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (25) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 11
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (160, 274, 275, 276, 277) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (280, 281, 282, 283, 284, 293) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (325) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (64) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 7
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (273) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (330) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (272) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (196) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (311) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (138) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (240, 241, 242, 243, 244, 245, 246, 247, 250) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (211) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (123, 205, 189, 192, 185, 194, 193, 186, 206, 188, 191, 187, 190) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (184) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (209) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (296) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (208) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (171) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (202) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (307) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (234) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (297) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (210) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (183) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (251, 257, 255, 256, 258, 217, 221, 222, 223, 218, 213, 214, 219, 224, 225, 253, 215, 212, 216, 254) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (259) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (260) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (261) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (263) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (278) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (265) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (267) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (268) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (266) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (269) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (291) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (319) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (236) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 10
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (59) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 1
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (285) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (105) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 7
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (125) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (271) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (329) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (308) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (312) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (82) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (129) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (61) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 71
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (106) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 3
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (60) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (313) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (328) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (111) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (322) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (232) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (270) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (318) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (62) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 224
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (279) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (305) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (304) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (126) AND p.active = 1 AND sh.shop_id IN (0,161969,182757) Array
(
[total] => 0
)
SELECT is_yandex_delivery, shop_venezia_id, is_for_tempo, is_for_dominos, is_for_scope, frontpad_token, iiko_enable FROM os38h_shops WHERE shop_id = 0 Array
(
)
SELECT keyword FROM os38h_url_alias WHERE query = 'cityid=37' Array
(
[keyword] => smorgon
)
Ты тоже можешь поделиться промокодом с друзьями и подарить им бонус 3 руб. для заказа в нашем приложении! И как только они сделают свой первый заказ, мы начислим дополнительный бонус 3 руб. и тебе!
Ты тоже можешь поделиться промокодом с друзьями и подарить им бонус 3 руб. для заказа в нашем приложении! И как только они сделают свой первый заказ, мы начислим дополнительный бонус 3 руб. и тебе!
Номер телефона уже подтвержден. Хотите изменить номер?