Код товара: 11862-320
.
Звоните, наши специалисты Вам помогут!
Все товары, представленные в интернет-магазине, можно приобрести в розничном магазине "Rybaki.ru".
Адрес: Москва, ул. 5-я Кабельная, д. 2, стр. 1, уровень 5 в ТРК "СпортЕХ"
График работы: ежедневно с 10:00 до 21:00
Код товара: 6895-001
Мультитул Juice S2 является одной из самых передовых моделей в линейке Leatherman. Идеальный спутник для однодневных походов, как на природу, так и по магазинам. С теми же габаритами, что и модель C2, но без штопора, S2 зато имеет полноценные ножницы. Данный мультитул идеально подходит для мелкого ремонта, занятий творчеством, регулировки техники. Эта модель из серии Juice сделает Ваши проекты дома или на природе поистине сочными и яркими!
Код товара: 7736-153
Держак TAKA Q-Taro Rod Stand T-153 для двух удилищ на ящик на присоске
Код товара: 12299-700
Код товара: 12842-110
Код товара: 6893-001
Настоящий Лезерман, С2 — это пассатижи, кусачки, четыре отвертки, кроме того, штопор, открывалки. Это самая тонкая модель построенная на „шасси“ Juice. Страховочное кольцо позволяет закрепить его на молнии рюкзака или использовать как брелок. Сделан в США и обеспечивается 25-летней гарантией Лезерман.
Код товара: 6865-001
Игла TICT для продевания лески в кольца.
Код товара: 4681-001
Очень компактный и надежный мультитул для проведения вспомогательный и мелких ремонтных работ в полевых условиях. Изготовлен из нержавеющей стали. Может крепиться на брелок с ключами. В комплекте наиболее необходимые инструменты.
Код товара: 1000-809
DEAD LINE - защитные очки с дужками из светлого ПВХ и синими резиновыми вставками. Линзы из прозрачного поликарбоната.
Код товара: 11735-001
Подарочный набор ADVENTURE, который оценит каждый мужчина. В комплекте 4 стопки из нержавеющей стали и фляга.
Код товара: 1000-160
Очки открытые PELTOR SOLUS с голубыми зеркальными линзами.
Код товара: 6829-100
С выпуском зимнего газа Примус, вы можете использовать его до -22° C. Это стало возможным благодаря гениальной технологии Vapour Mesh.
Код товара: 12843-150
Код товара: 7735-001
Держак TAKA Rod Stand T-96 Single для одного удилища на ящик цв. Черный
Код товара: 11746-001
Термокружка STANLEY Mountain Vacuum Switchback Mug с карабином. Легко открыть, пить, закрыть нажатием на кнопку одной рукой. Карабин для захвата одним пальцем.
Код товара: 6892-002
Лидер по популярности среди мультитулов, который знаменит благодаря лезвиям с наружным открыванием, которые можно открыть одной рукой. После доработки в 2004 году модель мультитула Wave получила более крупные лезвия, мощные плоскогубцы, удлиненные кусачки и ножи с фиксацией и защитой от случайного закрывания. Инструмент идеально подходит для любой работы, активного отдыха, решения бытовых задач, таким образом, Wave - это международный бестселлер.
Согласен на получение рассылок и обработку персональных данных. С условиями использования сайта и положениями Политики конфиденциальности ознакомился.
Отправляя форму, даю согласие на обработку моих персональных данных. С положениями Политики конфиденциальности ознакомился.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1781227172, "last": 1781227172, "now": 1781227172 }, "token": "cNPkIKIVuwbqnupHIqofNfTFdjCXr2XR" }, "registry": { "jshoping": { "list": { "front": { "product": { "cat": { "29manufacturers": "", "29categorys": "", "29fprice_from": "", "29fprice_to": "", "29extra_fields": "", "29available_only": "", "29sale": "", "29attrs": "" } }, "productorder": "", "productorderby": "", "productlimit": "" } } }, "start": 1456 }, "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=1456", "jshop_end_page_list_product": "/snaryazhenie?start=1456" } }
SELECT `data` FROM `fish_session` WHERE `session_id` = X'6439313274316b34636537346831716d636434386a3065627275'
SELECT `session_id` FROM `fish_session` WHERE `session_id` = X'6439313274316b34636537346831716d636434386a3065627275' LIMIT 1
INSERT INTO `fish_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6439313274316b34636537346831716d636434386a3065627275', 1, 1781227172, 0, '', 0)
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\":\"5ff4a64a9c3168de01df1d8bebd9eb5b\"}' 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
select * from fish_jshopping_languages
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 1456, 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
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 ('24906','37711','29558','51979','37298','37708','8456','37720','33097','36475','33124','37406','37301','29572','21723','37727') ORDER BY product_attr_id
SHOW FULL COLUMNS FROM `fish_jshopping_products`
SELECT * FROM fish_jshopping_products WHERE `product_id` = '24906'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=24906 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37711'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37711 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '29558'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=29558 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '51979'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=51979 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37298'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37298 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37708'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37708 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '8456'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=8456 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37720'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37720 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '33097'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=33097 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '36475'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=36475 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '33124'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=33124 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37406'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37406 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37301'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37301 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '29572'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=29572 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '21723'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=21723 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37727'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37727 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` = 'Рукоять для подсачека SALMO Salmo' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=83 ORDER BY p.product_id=24906 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` = 'Мультитул LEATHERMAN Juice S2 цв. Оранжевый, подарочная упако' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=97 ORDER BY p.product_id=37711 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` = 'Стойка для удилищ TAKA Q-Taro Rod Stand T-153' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=94 ORDER BY p.product_id=29558 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` = 'Аккумулятор FENIX ARB-L16-700' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=27 ORDER BY p.product_id=51979 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 Chrome' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=210 ORDER BY p.product_id=37298 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` = 'Мультитул LEATHERMAN Juice C2 цв. желтый' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=97 ORDER BY p.product_id=37708 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` = 'Игла TICT Guide Through' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=135 ORDER BY p.product_id=8456 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-Tech 6-In-1' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=84 ORDER BY p.product_id=37720 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` = 'Очки защитные COMBATSHOP Dead Line с желтой линзой' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=41 ORDER BY p.product_id=33097 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` = 'Набор STANLEY стопки Adventure' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=263 ORDER BY p.product_id=36475 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` = 'Очки баллистические 3M PELTOR Solus' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=571 ORDER BY p.product_id=33124 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` = 'Баллон газовый PRIMUS Power Gas 100' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=350 ORDER BY p.product_id=37406 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 Easy' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=210 ORDER BY p.product_id=37301 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` = 'Стойка для удилищ TAKA Rod Stand T-96 Single' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=94 ORDER BY p.product_id=29572 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 Switchback Mug 0,35 л' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=263 ORDER BY p.product_id=21723 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` = 'Мультитул LEATHERMAN Wave цв. Металлик, чехол кожа, подарочна' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=97 ORDER BY p.product_id=37727 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 01:19:33') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-12 01:19:33') 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='', prod.product_price asc LIMIT 139, 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 590, 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='', prod.product_price desc LIMIT 532, 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 asc LIMIT 698, 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 desc LIMIT 387, 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 532, 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 3768, 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 57, 1
18 × SELECT category_id FROM fish_jshopping_categories
17 × SELECT * FROM `fish_jshopping_products_attr`
16 × SELECT * FROM fish_jshopping_products
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`
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 `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`
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
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 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 extension_id FROM fish_extensions
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 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 product_id as id, `alias_ru-RU` as alias from fish_jshopping_products
1 × SELECT `data` FROM `fish_session`
1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url from fish_jshopping_manufacturers
1 × SELECT * FROM fish_jshopping_config
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 id, image, color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies`
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 × select * from fish_jshopping_language
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 `session_id` FROM `fish_session`
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 × INSERT INTO `fish_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6439313274316b34636537346831716d636434386a3065627275', 1, 1781227172, 0, '', 0
1 × UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"5ff4a64a9c3168de01df1d8bebd9eb5b\"}'
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_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
