Код товара: 7437-007
Тяжелая компактная колебалка RB PREMIUM для ловли щуки.
Звоните, наши специалисты Вам помогут!
Все товары, представленные в интернет-магазине, можно приобрести в розничном магазине "Rybaki.ru".
Адрес: Москва, ул. 5-я Кабельная, д. 2, стр. 1, уровень 5 в ТРК "СпортЕХ"
График работы: ежедневно с 10:00 до 21:00
Код товара: 9415-336
Серия воблеров-минноу для ловли лососевых в быстрых реках, стабильно работающих на течении любой силы. Впрочем, и в спокойной воде работа приманки не менее привлекательна для рыбы. Воблеры серии Tricoroll легко узнать по вытянутому телу с горбинкой, сильно сжатому с боков. Плоское тело стабилизирует приманку на струе, а также создаёт дополнительные блики, привлекающие рыбу. Воблеры выпускаются в четырёх размерах и четырёх вариантах плавучести - плавающие, суспендеры, тонущие и быстро тонущие. Тонущие модели очень привлекательно дрожат и покачивают боками на паузе, благодаря чему отлично подходят для ловли пассивной рыбы методом stop&go. Но лучше всего они раскрывают свои качества при твитчинге. Некрупные модели (47 и 55 мм) будут хорошим выбором для ловли форели, окуня и «белых» хищников, приманки покрупнее (67 и 83 мм) можно использовать и для щуки, судака или жереха.
Код товара: 6267-014
Виброхвост MADNESS Bakuree Tail
Код товара: 9430-379
Приманки обладают классическими для воблеров-минноу пропорциями, но при этом весьма округлым телом, что придает ему особую переваливающуюся игру. Одинаково успешно их можно использовать и на течении, и в стоячей воде. Воблеры привлекательно работают как на равномерной, так и на рывковой проводкой, однако твичинг стоит признать основным методом анимации. На паузе воблер начинает медленно всплывать, и именно это зачастую служит сигналом для атаки. 53-миллиметровая модель отлично подойдёт для ловли окуня, форели, голавля и других некрупных хищников, 88-миллиметровый воблер можно применять для целенаправленной охоты за судаком или щукой на средних глубинах, поскольку этот типоразмер выпускается в тонущем исполнении.
Код товара: 6274-230
Код товара: 9195-065
Благодаря продуманной конструкции тела и фиксированному балансировочному грузу приманка имеет хорошие характеристики заброса и поразительную устойчивость во время проводки. Оптимально подходит как для равномерной подмотки, так и твичинга.
Код товара: 7894-037
Червь LUCKY JOHN Wacky Worm 9,9 см код цв. S21 (10 шт.)
Код товара: 4241-014
Несмотря на небольшие размеры воблер Jackall DD Squirrel 67 ayu класса минноу отличается поразительной уловистостью, благодаря активной естественной игре и способности моментально нырнуть на нужную глубину. В нашем интернет-магазине можно купить эту приманку, способную взбудоражить любого хищника, по привлекательной цене.
Код товара: 11994-018
.
Код товара: 14663-693
Код товара: 14322-667
Код товара: 14320-887
Код товара: 4739-233
Код товара: 5761-060
Класическая вертушка BLUE FOX с колокольчиком.
Код товара: 10094-056
Сверх популярный и уловистый универсальный воблер YO-ZURI L-Minnow .
Код товара: 9408-344
Согласен на получение рассылок и обработку персональных данных. С условиями использования сайта и положениями Политики конфиденциальности ознакомился.
Отправляя форму, даю согласие на обработку моих персональных данных. С положениями Политики конфиденциальности ознакомился.
{ "__default": { "session": { "counter": 22, "timer": { "start": 1781116420, "last": 1781116468, "now": 1781116471 }, "token": "qJc0cjKijj4TMgrrRHsOSyxHebxkLthy" }, "registry": { "jshoping": { "list": { "front": { "product": { "cat": { "102manufacturers": "", "102categorys": "", "102fprice_from": "", "102fprice_to": "", "102extra_fields": "", "102available_only": "", "102sale": "", "102attrs": "", "58manufacturers": "", "58categorys": "", "58fprice_from": "", "58fprice_to": "", "58extra_fields": "", "58available_only": "", "58sale": "", "58attrs": "", "4manufacturers": "", "4categorys": "", "4fprice_from": "", "4fprice_to": "", "4extra_fields": "", "4available_only": "", "4sale": "", "4attrs": "", "98manufacturers": "", "98categorys": "", "98fprice_from": "", "98fprice_to": "", "98extra_fields": "", "98available_only": "", "98sale": "", "98attrs": "", "140manufacturers": "", "140categorys": "", "140fprice_from": "", "140fprice_to": "", "140extra_fields": "", "140available_only": "", "140sale": "", "140attrs": "", "29manufacturers": "", "29categorys": "", "29fprice_from": "", "29fprice_to": "", "29extra_fields": "", "29available_only": "", "29sale": "", "29attrs": "", "175manufacturers": "", "175categorys": "", "175fprice_from": "", "175fprice_to": "", "175extra_fields": "", "175available_only": "", "175sale": "", "175attrs": "", "382manufacturers": "", "382categorys": "", "382fprice_from": "", "382fprice_to": "", "382extra_fields": "", "382available_only": "", "382sale": "", "382attrs": "", "167manufacturers": "", "167categorys": "", "167fprice_from": "", "167fprice_to": "", "167extra_fields": "", "167available_only": "", "167sale": "", "167attrs": "", "172manufacturers": "", "172categorys": "", "172fprice_from": "", "172fprice_to": "", "172extra_fields": "", "172available_only": "", "172sale": "", "172attrs": "" }, "manf": { "761manufacturers": "", "761categorys": "", "761fprice_from": "", "761fprice_to": "", "761extra_fields": "", "761available_only": "", "761sale": "", "761attrs": "", "85manufacturers": "", "85categorys": "", "85fprice_from": "", "85fprice_to": "", "85extra_fields": "", "85available_only": "", "85sale": "", "85attrs": "", "175manufacturers": "", "175categorys": "", "175fprice_from": "", "175fprice_to": "", "175extra_fields": "", "175available_only": "", "175sale": "", "175attrs": "", "571manufacturers": "", "571categorys": "", "571fprice_from": "", "571fprice_to": "", "571extra_fields": "", "571available_only": "", "571sale": "", "571attrs": "" } }, "productorder": "", "productorderby": "", "productlimit": "" } } }, "start": 128 }, "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": "/primanki?start=128", "jshop_end_page_list_product": "/primanki?start=128" } }
SELECT `data` FROM `fish_session` WHERE `session_id` = X'71723764626d35766132706d326d6d6576376474303169347369'
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\":\"e8145405a2b787eca3954420c4b8c80d\"}' 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 (98)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (99,100,145,147,167,191,193,278,287,752,981)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (406,412,413,415,416,417,900,409,410,438,439,440,449,450,451)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (414)
SELECT * FROM fish_jshopping_categories WHERE `category_id` = '98'
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 = '98' 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 = 99
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 = 100
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 = 145
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 = 147
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 = 167
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 = 191
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 = 193
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 = 278
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 = 287
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 = 752
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 = 981
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 (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414) 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 (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414) 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 128, 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 ('22748','17677','4362','16345','35378','14956','7376','15728','18601','63588','57072','56338','15017','11211','19642','17627') ORDER BY product_attr_id
SHOW FULL COLUMNS FROM `fish_jshopping_products`
SELECT * FROM fish_jshopping_products WHERE `product_id` = '22748'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=22748 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '17677'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=17677 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '4362'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=4362 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '16345'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=16345 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '35378'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=35378 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '14956'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=14956 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '7376'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=7376 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '15728'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=15728 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '18601'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=18601 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '63588'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=63588 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '57072'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=57072 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '56338'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=56338 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '15017'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=15017 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '11211'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=11211 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '19642'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=19642 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '17627'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=17627 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` = 'Блесна колеблющаяся РУССКАЯ БЛЕСНА Premium' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=178 ORDER BY p.product_id=22748 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` = 'Воблер JACKALL TIMON Tricoroll HW' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=233 ORDER BY p.product_id=17677 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` = 'Виброхвост MADNESS Bakuree Tail' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=131 ORDER BY p.product_id=4362 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` = 'Воблер JACKALL TIMON Midia S' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=233 ORDER BY p.product_id=16345 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` = 'Виброхвост LUNKER CITY Shaker' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=149 ORDER BY p.product_id=35378 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` = 'Воблер JACKALL Aska SR' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=14956 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` = 'Червь LUCKY JOHN Wacky Worm' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=125 ORDER BY p.product_id=7376 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` = 'Воблер JACKALL DD Squirrel' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=15728 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` = 'Мормышка вольфрамовая LUCKY JOHN Банан с петелькой' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=125 ORDER BY p.product_id=18601 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` = 'Твистер KEITECH Mad Wag Mini' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=138 ORDER BY p.product_id=63588 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` = 'Рак BAIT BREATH Virtual Craw' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=132 ORDER BY p.product_id=57072 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` = 'Червь CRAZY FISH Cruel Leech кальмар' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=439 ORDER BY p.product_id=56338 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` = 'Воблер MEGABASS Baby Pop-X F' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=228 ORDER BY p.product_id=15017 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` = 'Блесна вращающаяся BLUE FOX Vibrax Uv' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=172 ORDER BY p.product_id=11211 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` = 'Воблер YO-ZURI L-Minnow F1 S' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=249 ORDER BY p.product_id=19642 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` = 'Воблер JACKALL TIMON Tricoroll F' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=233 ORDER BY p.product_id=17627 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 (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414) 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-10 18:34:32') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-10 18:34:32') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 128 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=128 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 (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414) 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 (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414) 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 (2996,2326,2325,2817,2999,2994,2881,3289,2877,2879,2742,3002,3290,2880,2882,2884,3001,2997,2689,3013,3014,2885,3020,2237,3021,2709,2415,2475,2711,2416,2707,2714,3036,2361,3037,2708,2851,2285,2267,2287,2362,2270,2276,2829,2830,2271,2371,2372,2277,2269,2472,2710,4755,2327,2278,2283,2284,2286,2364,2365,2366,2367,2368,2369,2370,2373,3038,2827,2756,2722,3285,2587,2862,3007,2828,3006,3237,3238,2607,4270,2765,3010,7367,4707,2294,4747,2321,4951,4965,3027,6032,7008,3059,7837,7861,8005,3015,8148,8161,8785,9515) ORDER BY name
SELECT min(CAST(`pr`.`extra_field_25` as DECIMAL(10,1))) as min,max(CAST(`pr`.`extra_field_25` as DECIMAL(10,1))) 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 (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414)
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 (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414)
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 231, 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='', prod.product_price asc LIMIT 230, 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 asc LIMIT 603, 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 1237, 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='', name asc LIMIT 407, 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 desc LIMIT 380, 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 2195, 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 asc LIMIT 124, 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`
11 × 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
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
3 × SELECT * FROM fish_jshopping_categories
2 × SELECT id, `name_ru-RU` as name, field_id FROM `fish_jshopping_products_extra_field_values`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions`
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 manufacturer_id as id, `alias_ru-RU` as alias from fish_jshopping_manufacturers
1 × select product_id as id, `alias_ru-RU` as alias from fish_jshopping_products
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 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 extension_id FROM fish_extensions
1 × SELECT id,`name_ru-RU` as name,image,color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT min(CAST(`pr`.`extra_field_25` as DECIMAL(10,1))) as min,max(CAST(`pr`.`extra_field_25` as DECIMAL(10,1))) 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 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 filter.* FROM `fish_jshopping_filters` AS `filter` INNER JOIN `fish_jshopping_filter2menu` AS `fm` ON fm.filter_id=filter.filter_id
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 fa.id,fa.required,fa.`name_ru-RU` AS name,fa.type FROM `fish_jshopping_free_attr` AS fa
1 × select category_id as id, `alias_ru-RU` as alias from fish_jshopping_categories
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 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 `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 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 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 manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url from fish_jshopping_manufacturers
1 × UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"e8145405a2b787eca3954420c4b8c80d\"}'
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
