Код товара: 6895-002
Мультитул Juice S2 является одной из самых передовых моделей в линейке Leatherman. Идеальный спутник для однодневных походов, как на природу, так и по магазинам. С теми же габаритами, что и модель C2, но без штопора, S2 зато имеет полноценные ножницы. Данный мультитул идеально подходит для мелкого ремонта, занятий творчеством, регулировки техники. Эта модель из серии Juice сделает Ваши проекты дома или на природе поистине сочными и яркими!
Звоните, наши специалисты Вам помогут!
Все товары, представленные в интернет-магазине, можно приобрести в розничном магазине "Rybaki.ru".
Адрес: Москва, ул. 5-я Кабельная, д. 2, стр. 1, уровень 5 в ТРК "СпортЕХ"
График работы: ежедневно с 10:00 до 21:00
Код товара: 9797-920
Датчик HUMMINBIRD XNT-9-20-T
Код товара: 14168-370
.
Код товара: 14168-372
Код товара: 6992-113
Высококачественное топливо, разработанное компанией MSR, изобутан, повышает эффективность горелок. Топливо имеет отличные рабочие характеристики при низких температурах, горит чище, уменьшается количество копоти.
Код товара: 11744-053
Код товара: 11998-062
Код товара: 7714-010
Очиститель STONFO 616 лески цв. Зеленый
Код товара: 9819-311
Програмное обеспечение HUMMINBIRD Autochart PC Software SD (не подходит для Helix 5,7)
Код товара: 9733-001
Нож VICTORINOX Tinker р. 91 мм, 12 функций, цв. красный, карт. коробка
Код товара: 4680-527
Небольшой и удобный многофункциональный инструмент, объединяющий в себе самые необходимые вещи, которые могут пригодиться в условиях путешествий, рыбалок или охоты. Мощный и надежный корпус и все инструменты этого мультитула произведены из закаленной нержавеющей стали.
Код товара: 14662-007
Код товара: 11936-100
Код товара: 12688-594
Код товара: 7733-186
Захват YAMAKESHI Lip Grip складной для рыбы в чехле 186 мм (285 мм)
Код товара: 11745-001
Походная термокружка STANLEY Mountain Vacuum Trail Mug сохраняет тепло и холод в течение 6 часов, напитки со льдом - 30 часов.
Согласен на получение рассылок и обработку персональных данных. С условиями использования сайта и положениями Политики конфиденциальности ознакомился.
Отправляя форму, даю согласие на обработку моих персональных данных. С положениями Политики конфиденциальности ознакомился.
{ "__default": { "session": { "counter": 2, "timer": { "start": 1781223521, "last": 1781223521, "now": 1781223523 }, "token": "VARhZip9EidBmOnKZpimgt5Re8cW2XRn" }, "registry": { "jshoping": { "list": { "front": { "product": { "cat": { "30manufacturers": "", "30categorys": "", "30fprice_from": "", "30fprice_to": "", "30extra_fields": "", "30available_only": "", "30sale": "", "30attrs": "", "29manufacturers": "", "29categorys": "", "29fprice_from": "", "29fprice_to": "", "29extra_fields": "", "29available_only": "", "29sale": "", "29attrs": "" } }, "productorder": "", "productorderby": "", "productlimit": "" } } }, "start": 1408 }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "js_id_currency_orig": "1", "js_id_currency": "1", "js_history_sel_lang": "ru-RU", "js_prev_user_id": 0, "jshop_checked_language": [ "en-GB", "ru-RU" ], "jshop_end_page_buy_product": "/snaryazhenie?start=1408", "jshop_end_page_list_product": "/snaryazhenie?start=1408" } }
SELECT `data` FROM `fish_session` WHERE `session_id` = X'653631376364356f396c67736c38323773683062756d6d747064'
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
SELECT id, rules FROM `fish_viewlevels`
SELECT b.id FROM fish_usergroups AS a LEFT JOIN fish_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM fish_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
SELECT `params` FROM `fish_extensions` WHERE `type` = 'component' AND `element` = 'com_jchoptimize'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM fish_menu AS m LEFT JOIN fish_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions` WHERE `type` = 'library' AND `element` = 'joomla'
UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"b25d9ea62e7db99f781fa5f34d248112\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT * FROM fish_languages WHERE published=1 ORDER BY ordering ASC
SELECT id, home, template, s.params FROM fish_template_styles as s LEFT JOIN fish_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SELECT id, image, color FROM `fish_jshopping_products_extra_field_values` WHERE image !='' OR color!=''
SHOW FULL COLUMNS FROM `fish_jshopping_config`
SELECT * FROM fish_jshopping_config WHERE `id` = '1'
SHOW FULL COLUMNS FROM `fish_jshopping_currencies`
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering
SHOW FULL COLUMNS FROM `fish_jshopping_categories`
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (29)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (30,32,33,35)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,955,956,957,979,34,109,159,160,179,181,185,515,516,517,543,544,545,546,547,548,549,601,36,48,49,68,71,92,255,295,848)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967,695,696,697,701,702,703,705,724,749,699,700,706,870,679,693,740,741,742,743,744,748,681,682,683,685,687,689,691,692,726,728,731,677,707,708,709,711,712,713,714,716,717,718,719,720,722,775,777,901,903,904,906,849,850,851,852,853,854,855,856,857,858,859,862,863,864,865,866,867,868,869,914,915,916,917,918,919)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (684,686,688,690,909,704,710,715,721,750,751,727,729,730,732,733,736,737,738,739,911,912,745,746,747,913,910,776,778,860,902,905,907)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (734,735,861,908)
SELECT * FROM fish_jshopping_categories WHERE `category_id` = '29'
SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image, `alias_ru-RU` as alias FROM `fish_jshopping_categories` WHERE category_parent_id = '29' AND category_publish = '1' AND access IN (1,1,5) ORDER BY ordering asc
select id,link from fish_menu where `type`='component' and published=1 and link like '%option=com_jshopping%' and client_id=0 and (language='*' or language='ru-RU') and access IN (1,1,5)
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 30
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 32
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 33
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 35
SHOW FULL COLUMNS FROM `fish_jshopping_vendors`
SELECT id FROM fish_jshopping_vendors WHERE `main`=1
SELECT * FROM fish_jshopping_vendors WHERE `id` = '1'
SHOW FULL COLUMNS FROM `fish_jshopping_products_extra_fields`
SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.` group`, G.`name_ru-RU` as groupname, multilist FROM `fish_jshopping_products_extra_fields` as F left join `fish_jshopping_products_extra_field_groups` as G on G.id=F. group order by G.ordering, F.ordering
SHOW FULL COLUMNS FROM `fish_jshopping_taxes`
SELECT tax_id, tax_name, tax_value FROM `fish_jshopping_taxes`
SELECT COUNT(distinct prod.product_id) FROM `fish_jshopping_products_to_categories` AS pr_cat INNER JOIN `fish_jshopping_products` AS prod ON pr_cat.product_id = prod.product_id WHERE pr_cat.category_id IN (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,955,956,957,979,34,109,159,160,179,181,185,515,516,517,543,544,545,546,547,548,549,601,36,48,49,68,71,92,255,295,848,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967,695,696,697,701,702,703,705,724,749,699,700,706,870,679,693,740,741,742,743,744,748,681,682,683,685,687,689,691,692,726,728,731,677,707,708,709,711,712,713,714,716,717,718,719,720,722,775,777,901,903,904,906,849,850,851,852,853,854,855,856,857,858,859,862,863,864,865,866,867,868,869,914,915,916,917,918,919,684,686,688,690,909,704,710,715,721,750,751,727,729,730,732,733,736,737,738,739,911,912,745,746,747,913,910,776,778,860,902,905,907,734,735,861,908) AND prod.product_publish=1 AND prod.listing_product>0 AND prod.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id) WHERE pr_cat.category_id IN (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,955,956,957,979,34,109,159,160,179,181,185,515,516,517,543,544,545,546,547,548,549,601,36,48,49,68,71,92,255,295,848,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967,695,696,697,701,702,703,705,724,749,699,700,706,870,679,693,740,741,742,743,744,748,681,682,683,685,687,689,691,692,726,728,731,677,707,708,709,711,712,713,714,716,717,718,719,720,722,775,777,901,903,904,906,849,850,851,852,853,854,855,856,857,858,859,862,863,864,865,866,867,868,869,914,915,916,917,918,919,684,686,688,690,909,704,710,715,721,750,751,727,729,730,732,733,736,737,738,739,911,912,745,746,747,913,910,776,778,860,902,905,907,734,735,861,908) AND prod.product_publish=1 AND prod.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.hits DESC LIMIT 1408, 16
SHOW FULL COLUMNS FROM `fish_jshopping_users`
select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url from fish_jshopping_manufacturers where manufacturer_publish='1'
SHOW FULL COLUMNS FROM `fish_jshopping_products_extra_field_values`
SELECT id, `name_ru-RU` as name, field_id FROM `fish_jshopping_products_extra_field_values` order by ordering
SHOW FULL COLUMNS FROM `fish_jshopping_product_labels`
SELECT id, image, `name_ru-RU` as name FROM `fish_jshopping_product_labels` ORDER BY name
select product_id as id, `alias_ru-RU` as alias from fish_jshopping_products where `alias_ru-RU`!=''
select category_id as id, `alias_ru-RU` as alias from fish_jshopping_categories where `alias_ru-RU`!=''
SELECT fa.id,fa.required,fa.`name_ru-RU` AS name,fa.type FROM `fish_jshopping_free_attr` AS fa ORDER BY fa.ordering
SHOW FULL COLUMNS FROM `fish_jshopping_attr`
SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname FROM `fish_jshopping_attr` as A left join `fish_jshopping_attr_groups` as G on A.` group`=G.id ORDER BY G.ordering, A.attr_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id IN ('37712','1211','46840','46843','37398','21707','29516','34042','1154','37639','37717','62814','13909','34234','29530','21724') ORDER BY product_attr_id
SHOW FULL COLUMNS FROM `fish_jshopping_products`
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37712'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37712 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '1211'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=1211 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '46840'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=46840 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '46843'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=46843 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37398'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37398 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '21707'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=21707 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '29516'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=29516 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '34042'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=34042 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '1154'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=1154 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37639'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37639 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37717'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37717 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '62814'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=62814 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '13909'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=13909 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '34234'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=34234 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '29530'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=29530 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '21724'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=21724 ORDER BY product_attr_id
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Мультитул LEATHERMAN Juice S2 цв. серый' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=97 ORDER BY p.product_id=37712 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Датчик HUMMINBIRD Xnt-9-20-T' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=34 ORDER BY p.product_id=1211 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Аэрозоль-репеллент GARDEX от комаров' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=358 ORDER BY p.product_id=46840 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Аэрозоль-репеллент GARDEX от мошки и комаров' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=358 ORDER BY p.product_id=46843 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Баллон газовый MSR IsoPro 113' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=90 ORDER BY p.product_id=37398 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family_seo` = 'Master 0,53 л' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=263 ORDER BY p.product_id=21707 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Багор SALMO Ice Gaff 62' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=83 ORDER BY p.product_id=29516 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Очиститель лески STONFO 616 Лески' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=180 ORDER BY p.product_id=34042 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Програмное обеспечение HUMMINBIRD Autochart Pc Software Sd' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=34 ORDER BY p.product_id=1154 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Швейцарский нож VICTORINOX Tinker 91мм 12 функций' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=354 ORDER BY p.product_id=37639 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Мультитул SWISS TECH Micro-Plus Ex 9-In-1' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=84 ORDER BY p.product_id=37717 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Нож MORAKNIV Floating Serrated (плавающий)' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=408 ORDER BY p.product_id=62814 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Ледобур HEINOLA Speedrun Sport' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=212 ORDER BY p.product_id=13909 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Нож сменный MORA ICE 20594 зубчатый для шнека' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=210 ORDER BY p.product_id=34234 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Захват для рыбы YAMAKESHI Lip Grip' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=91 ORDER BY p.product_id=29530 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family_seo` = 'Mountain Vacuum Trail Mug 0,35 л' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=263 ORDER BY p.product_id=21724 DESC, `name_ru-RU` ASC
SELECT distinct man.manufacturer_id as id, man.`name_ru-RU` as name, man.`alias_ru-RU` as alias, manufacturer_logo FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `fish_jshopping_manufacturers` as man on prod.product_manufacturer_id=man.manufacturer_id WHERE categ.category_id IN (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,955,956,957,979,34,109,159,160,179,181,185,515,516,517,543,544,545,546,547,548,549,601,36,48,49,68,71,92,255,295,848,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967,695,696,697,701,702,703,705,724,749,699,700,706,870,679,693,740,741,742,743,744,748,681,682,683,685,687,689,691,692,726,728,731,677,707,708,709,711,712,713,714,716,717,718,719,720,722,775,777,901,903,904,906,849,850,851,852,853,854,855,856,857,858,859,862,863,864,865,866,867,868,869,914,915,916,917,918,919,684,686,688,690,909,704,710,715,721,750,751,727,729,730,732,733,736,737,738,739,911,912,745,746,747,913,910,776,778,860,902,905,907,734,735,861,908) AND prod.product_publish=1 AND prod.product_manufacturer_id!=0 AND prod.access IN (1,1,5) order by name
SHOW FULL COLUMNS FROM `fish_jshopping_products_reviews`
SHOW FULL COLUMNS FROM `fish_jshopping_manufacturers`
SELECT manufacturer_id, manufacturer_url, manufacturer_logo, manufacturer_publish, `name_ru-RU` as name, `description_ru-RU` as description, `short_description_ru-RU` as short_description FROM `fish_jshopping_manufacturers` WHERE manufacturer_publish = '1' ORDER BY ordering asc
select manufacturer_id as id, `alias_ru-RU` as alias from fish_jshopping_manufacturers where `alias_ru-RU`!=''
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM fish_modules AS m LEFT JOIN fish_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN fish_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-06-12 00:18:43') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-12 00:18:43') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 133 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SHOW FULL COLUMNS FROM `fish_jshopping_filters`
SELECT filter.* FROM `fish_jshopping_filters` AS `filter` INNER JOIN `fish_jshopping_filter2menu` AS `fm` ON fm.filter_id=filter.filter_id WHERE filter.filter_publish=1 AND fm.menuitem_id=133 ORDER BY filter.filter_ordering
SELECT distinct man.manufacturer_id as id,`man`.`name_ru-RU` AS `name` FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id` LEFT JOIN `fish_jshopping_manufacturers` AS `man` ON pr.product_manufacturer_id=man.manufacturer_id WHERE pr.product_publish=1 AND prc.category_id in (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,955,956,957,979,34,109,159,160,179,181,185,515,516,517,543,544,545,546,547,548,549,601,36,48,49,68,71,92,255,295,848,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967,695,696,697,701,702,703,705,724,749,699,700,706,870,679,693,740,741,742,743,744,748,681,682,683,685,687,689,691,692,726,728,731,677,707,708,709,711,712,713,714,716,717,718,719,720,722,775,777,901,903,904,906,849,850,851,852,853,854,855,856,857,858,859,862,863,864,865,866,867,868,869,914,915,916,917,918,919,684,686,688,690,909,704,710,715,721,750,751,727,729,730,732,733,736,737,738,739,911,912,745,746,747,913,910,776,778,860,902,905,907,734,735,861,908) AND product_manufacturer_id!=0 AND man.manufacturer_publish=1 ORDER BY name
SELECT extension_id FROM fish_extensions WHERE name = 'jshopping'
SELECT DISTINCT(pr.extra_field_45) as id FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id` WHERE pr.product_publish=1 AND prc.category_id in (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,955,956,957,979,34,109,159,160,179,181,185,515,516,517,543,544,545,546,547,548,549,601,36,48,49,68,71,92,255,295,848,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967,695,696,697,701,702,703,705,724,749,699,700,706,870,679,693,740,741,742,743,744,748,681,682,683,685,687,689,691,692,726,728,731,677,707,708,709,711,712,713,714,716,717,718,719,720,722,775,777,901,903,904,906,849,850,851,852,853,854,855,856,857,858,859,862,863,864,865,866,867,868,869,914,915,916,917,918,919,684,686,688,690,909,704,710,715,721,750,751,727,729,730,732,733,736,737,738,739,911,912,745,746,747,913,910,776,778,860,902,905,907,734,735,861,908) AND pr.extra_field_45 != 0 AND pr.extra_field_45!=''
SELECT id,`name_ru-RU` as name,image,color FROM `fish_jshopping_products_extra_field_values` WHERE id IN (2909,2911,2377,7063,7014,7400,7066,2790,2376,2403,2402,2348,3065,2349,2345,2347,2409,2669,2952,2792,2947,2975,2984,2642,2294,2942,2863,2946,2948,2816,2664,2590,2665,7383,2969,2972,2976,2978,7351,2673,2987,7494,7389,2666,2670,2441,2675,7511,2943,2601,7368,2915,2974,2961,2962,2705,2768,2956,2982,2983,2950,2955,2959,2970,2986,3043,2967,2941,4251,2958,4738,4784,4802,4823,4832,4838,5071,7509,4737,5815,2341,5826,5842,5858,5880,6740,7700,7364,7288,7891,2957,7829,7827,7921,8027,8081,2582,3028,2446,2680,2681,2679,2682,2450,2389,4589,2618,4590,2433,2437,4594,4595,4596,4597,4598,4599,4600,2509,2506,4601,2583,4602,2489,2434,4603,4604,4605,4606,4607,2635,2908,2628,7157,2648,7721,7720,5101,8021,8018,7181,8581,8024,8793,8794,5956,9309,2490,2491,2314,2315,2493,2492,2316,2494,2401,2495,2496,2497,2498,2249,2574,2923,2924,2432,2431,2438,7507,2439,2442,2444,2447,2448,7505,2925,7235,4608,4609,7185,7503,2645,2445,2854,7155,2380,8118,2899,7109,2891,5152,7162,3267,7247,8127,2650,8126,7493,4388,7434,2799,7152,3059,7408,7171,7175,7151,7156,2255,7223,9318,2890,7202,7161,3041,9205,7167,7237,2898,7210,7160,7172,7179,8215,7206,7176,2501,7251,7211,8225,7184,7225,8120,2852,2660,6446,7168,7212,5719,7200,8621,7232,8647,8669,8676,8675,8677,7245,2640,8707,8972,9316,9317,2896,2807,2672,8121,2724,2651,2339,2337,7024,8062,2718,2719,2822,7250,8091,7354,2318,2396,2637,2668,2968,2671,2930,2776,7499,2945,2949,8058,2971,2616,2658,2988,7513,2589,2661,2662,2663,2674,7512,2657,2794,3017,3045,2584,8085,3029,2655,2676,2627,2788,2614,3171,3249,3250,4356,4380,2419,4655,2299,4657,2594,2579,4697,2549,7960,3025,5676,7481,3032,7336,7158,7188,7363,7393,2659,7366,3044,3049,2620,7501,3097,7154,2656,2775,7229,7892,7948,8082,4725,2973,8088,4253,2678,2893,5001,8150,8765,2797,7397,2802,2848,7473,2796,2798,5129,2800,5132,8117,3107,2803,2805,8567,4728,2902,2900,3242,7105,2903,9685,9603,2913,2914,2552,4789,2847,2843,8013,8849,8847,2575,2634,3203,3204,2734,3208,2859,3209,3210,4588,4591,4592,4593,7213,7394,2860,2858,7396,2831,2846,7517,2291,2818,3263,7506,4695,4696,4757,4913,7521,7522,4918,4953,5106,5113,3240,5636,5638,8028,5900,6003,6051,7370,9595,7020,7036,5105,7033,5155,5107,5145,2767,7963,7821,7957,7967,7866,7916,7864,7925,7953,8083,8084,2463,8102,8116,8113,8115,2855,8114,6135,8407,8433,2553,7904,7214,5927,7903,4954,7421,8678,8679,8680,8759,8704,2704,8766,8629,8791,8792,8787,8790,8797,8836,9015,8841,8843,3050,6079,8947,9002,9019,2391,9255,2985,7402,4956,4955,9426,9487,4994,2346,2503,9671,2250,8995,2686,2687,2688,2732,5637,2733,7922,8376,8059,2741,2725,2726,2723,5708,2731,2735,2736,2737,2738,5735,7959,8057,2844,2845,2849,2850,2808,5700,5702,3109,6475,6476,7908,7940,7938,7933,7936,7907,7942,8060,8095,8093,8110,8100,8094,8104,8336,8788,8881,2499,9234,2513,9285,7372,2695,7385,7497,7495,5642,2278,7498,7409,6776,8040,8041,8042,2832,2834,2833,2835,2836,3179,7177,7170,7153,7186,2721,2931,2929,7204,7221,7222,7240,7147,2778,7195,4779,7159,7183,7239,7193,7230,7228,2779,7224,2780,7238,2500,2783,7249,3151,3069,7165,7198,7169,7217,7231,7242,7243,7233,2838,2839,3265,3026,2840,7174,7234,7187,7248,7244,7191,7189,7190,7199,7196,7197,7252,3027,2888,2892,7929,7246,7216,7219,7220,3033,2784,7173,7166,7241,7163,7182,2304,7201,8033,8036,9265,9267,8598,7205,7355,2562,2351,2344,2343,2824,7699,9693,8326,8324,4982,2335,7069,8065,7702,7701,8063,8432,2292,8056) ORDER BY name
SELECT min(CAST(pr.`product_price` as DECIMAL)) as min,max(CAST(pr.`product_price` as DECIMAL)) as max FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id` WHERE pr.product_publish=1 AND prc.category_id in (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,955,956,957,979,34,109,159,160,179,181,185,515,516,517,543,544,545,546,547,548,549,601,36,48,49,68,71,92,255,295,848,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967,695,696,697,701,702,703,705,724,749,699,700,706,870,679,693,740,741,742,743,744,748,681,682,683,685,687,689,691,692,726,728,731,677,707,708,709,711,712,713,714,716,717,718,719,720,722,775,777,901,903,904,906,849,850,851,852,853,854,855,856,857,858,859,862,863,864,865,866,867,868,869,914,915,916,917,918,919,684,686,688,690,909,704,710,715,721,750,751,727,729,730,732,733,736,737,738,739,911,912,745,746,747,913,910,776,778,860,902,905,907,734,735,861,908)
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (243,246,248,245,249,250,247,252,292) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (243,246,248,245,249,250,247,252,292) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name desc LIMIT 141, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (73,74,76,77,78,79,81,82,83,84) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (73,74,76,77,78,79,81,82,83,84) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name desc LIMIT 401, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (101,107,156,183,146,188,189,190,192,168,194,195,196) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (101,107,156,183,146,188,189,190,192,168,194,195,196) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name asc LIMIT 605, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (102,103,104,106,124,136,171,177,105,108,198,269,273,277,125,126,133,135,137,161,180,182,144,307,178,304) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (102,103,104,106,124,136,171,177,105,108,198,269,273,277,125,126,133,135,137,161,180,182,144,307,178,304) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price desc LIMIT 877, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (65,66,67,166,275,305,94,138,139,197,140,141,142,165,174,187,200,172,175,176,206,270,199) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (65,66,67,166,275,305,94,138,139,197,140,141,142,165,174,187,200,172,175,176,206,270,199) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price asc LIMIT 1612, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (21,22,41,42,46,47,63,64,88,89,91,258) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (21,22,41,42,46,47,63,64,88,89,91,258) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price asc LIMIT 467, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,34,109,159,160,179,181,185,36,48,49,68,71,92,255,295) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,34,109,159,160,179,181,185,36,48,49,68,71,92,255,295) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name asc LIMIT 1395, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (58,59,93,184,291,293) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (58,59,93,184,291,293) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name desc LIMIT 44, 1
18 × SELECT category_id FROM fish_jshopping_categories
17 × SELECT * FROM `fish_jshopping_products_attr`
16 × SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p`
16 × SELECT * FROM fish_jshopping_products
8 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
8 × SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
4 × SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id
3 × SELECT * FROM fish_jshopping_categories
2 × SELECT distinct man.manufacturer_id as id, man.`name_ru-RU` as name, man.`alias_ru-RU` as alias, manufacturer_logo FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `fish_jshopping_manufacturers` as man on prod.product_manufacturer_id=man.manufacturer_id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions`
2 × SELECT id, `name_ru-RU` as name, field_id FROM `fish_jshopping_products_extra_field_values`
1 × select category_id as id, `alias_ru-RU` as alias from fish_jshopping_categories
1 × SELECT fa.id,fa.required,fa.`name_ru-RU` AS name,fa.type FROM `fish_jshopping_free_attr` AS fa
1 × SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname FROM `fish_jshopping_attr` as A left join `fish_jshopping_attr_groups` as G on A.` group`=G.id
1 × SELECT min(CAST(pr.`product_price` as DECIMAL)) as min,max(CAST(pr.`product_price` as DECIMAL)) as max FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id`
1 × SELECT DISTINCT(pr.extra_field_45) as id FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id`
1 × SELECT id,`name_ru-RU` as name,image,color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT extension_id FROM fish_extensions
1 × SELECT manufacturer_id, manufacturer_url, manufacturer_logo, manufacturer_publish, `name_ru-RU` as name, `description_ru-RU` as description, `short_description_ru-RU` as short_description FROM `fish_jshopping_manufacturers`
1 × select manufacturer_id as id, `alias_ru-RU` as alias from fish_jshopping_manufacturers
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM fish_modules AS m LEFT JOIN fish_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN fish_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT filter.* FROM `fish_jshopping_filters` AS `filter` INNER JOIN `fish_jshopping_filter2menu` AS `fm` ON fm.filter_id=filter.filter_id
1 × SELECT distinct man.manufacturer_id as id,`man`.`name_ru-RU` AS `name` FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id` LEFT JOIN `fish_jshopping_manufacturers` AS `man` ON pr.product_manufacturer_id=man.manufacturer_id
1 × select product_id as id, `alias_ru-RU` as alias from fish_jshopping_products
1 × SELECT `data` FROM `fish_session`
1 × SELECT id, image, `name_ru-RU` as name FROM `fish_jshopping_product_labels`
1 × SELECT id, image, color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT id, rules FROM `fish_viewlevels
1 × SELECT b.id FROM fish_usergroups AS a LEFT JOIN fish_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM fish_extensions
1 × SELECT `params` FROM `fish_extensions`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM fish_menu AS m LEFT JOIN fish_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM fish_languages
1 × SELECT id, home, template, s.params FROM fish_template_styles as s LEFT JOIN fish_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT * FROM fish_jshopping_config
1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url from fish_jshopping_manufacturers
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies`
1 × SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image, `alias_ru-RU` as alias FROM `fish_jshopping_categories`
1 × select id,link from fish_menu
1 × SELECT id FROM fish_jshopping_vendors
1 × SELECT * FROM fish_jshopping_vendors
1 × SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.` group`, G.`name_ru-RU` as groupname, multilist FROM `fish_jshopping_products_extra_fields` as F left join `fish_jshopping_products_extra_field_groups` as G on G.id=F. group
1 × SELECT tax_id, tax_name, tax_value FROM `fish_jshopping_taxes
1 × SELECT COUNT(distinct prod.product_id) FROM `fish_jshopping_products_to_categories` AS pr_cat INNER JOIN `fish_jshopping_products` AS prod ON pr_cat.product_id = prod.product_id
1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id)
1 × UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"b25d9ea62e7db99f781fa5f34d248112\"}'
1 × SHOW FULL COLUMNS FROM `fish_jshopping_config
1 × SHOW FULL COLUMNS FROM `fish_jshopping_currencies
1 × SHOW FULL COLUMNS FROM `fish_jshopping_categories
1 × SHOW FULL COLUMNS FROM `fish_jshopping_vendors
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products_extra_fields
1 × SHOW FULL COLUMNS FROM `fish_jshopping_taxes
1 × SHOW FULL COLUMNS FROM `fish_jshopping_users
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products_extra_field_values
1 × SHOW FULL COLUMNS FROM `fish_jshopping_product_labels
1 × SHOW FULL COLUMNS FROM `fish_jshopping_attr
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products_reviews
1 × SHOW FULL COLUMNS FROM `fish_jshopping_manufacturers
1 × SHOW FULL COLUMNS FROM `fish_jshopping_filters
