Код товара: 9194-278
Составная приманка, объединяющая в себе черты уокера, поппера и воблера. По своим параметрам Boil Trigger напоминает Tiny Magallon, но отличается практически нулевым заглублением. Лежа на поверхности воды в слегка изогнутом благодаря наличию шарнира положении, он напоминает мертвого или оглушенного хищником малька. Boil Trigger идеален там, где надо провести приманку практически по самой поверхности, раскрыв при этом все возможности игры а ля Tiny Magallon.
Звоните, наши специалисты Вам помогут!
Все товары, представленные в интернет-магазине, можно приобрести в розничном магазине "Rybaki.ru".
Адрес: Москва, ул. 5-я Кабельная, д. 2, стр. 1, уровень 5 в ТРК "СпортЕХ"
График работы: ежедневно с 10:00 до 21:00
Код товара: 5434-155
Игра безлопастного воблера Jackall Baby Giron напоминает движения раненной или больной рыбки, пытающейся из последних сил уйти от зубов хищника. Двухсоставная конструкция приманки не рассчитана на дальние прицельные забросы, поэтому ее применение будет наиболее результативно при точечном поиске притаившейся в камыше щуки.
Код товара: 5449-579
Jackall Tiny Magallon matt tiger – компактная вариация знаменитого среди спиннингистов двухсоставного воблера серии Magallon, названного убийцей щуки, окуня и других хищников. Купить уловистую приманку по доступной цене можно в нашем интернет-магазине.
Код товара: 7783-548
Jackall Rhythm Wave - виброхвосты со стабильной и привлекательной игрой при любой скорости проводки и на течении любой силы.
Код товара: 4239-014
Классический сверх уловистый воблер типа минноу JACKALL модели Squirrel для равномерной и рывковой проводки.
Код товара: 9153-274
Суспендер Соул шад конструкционно рассчитан как на непрерывную проводку, так и твичинговую. В Россиских условиях воблеры больших размеров подходят для ловли щуки и судака, а меньших окуня и головля. Отличительная особенность воблера – уверенная работа на течении. Воблер обладает нейтральной плавучестью, что позволяет облавливать любые доступные ему горизонты проводки, останавливая подмотку и давая приманке зависнуть на некоторое время. Очень часто именно в момент остановки, когда воблер по инерции еще покачивается, и происходят поклевки.
Код товара: 9193-364
Рыболовы, занимающиеся ловлей форели в горных реках, голавля, окуня, щуку и других хищников в водоемах средней полосы в один голос называют глубоководный крэнк Jackall Diving Chubby 38 ayu одной из лучших спиннинговых приманок. Купить воблер по доступной цене можно в нашем интернет-магазине.
Код товара: 8682-008
Воблер Jackall Colt Minnow 65 SP ghost ayu – уловистый суспендер, обладающий завидной «дальнобойностью» и способный вынудить на бросок даже вялого хищника, притаившегося в глубине. Купить приманку по привлекательной цене можно в нашем интернет-магазине.
Код товара: 9485-021
Уловистые раттлины Jackall серии TN SLIM для спиннинговой и отвесной ловли разнообразного хищника в любых условиях. Универсальность этой приманки заключается веё применении. Вы можете оснастить ею спиннинг или ловить зимой в отвес со льда с одинаковым успехом.
Код товара: 4248-021
Движения воблера Jackall Chubby 38 имеют максимальную схожесть с поведением малька, убегающего от хищника или же размеренно плавающего на поверхности. Чрезвычайно уловистую приманку, которую глубоко заглатывает не только щука, но и голавль, по доступной цене можно купить в нашем интернет-магазине.
Код товара: 5256-172
Популярнейшая разработка фирмы Jackall в области объемных приманок. Воблер имеет двухсоставное тело с шарнирным соединением и позволяет применять разнообразную анимацию. Можно вести его равномерно, использовать твитчинговую проводку или же комбинацию равномерной и твитчинговой анимации. Giron имитирует раненую рыбку, и становиться неотразимым лакомством для хищника. За счет отрицательной плавучести можно облавливать любые горизонты водоема.
Код товара: 7780-289
Jackall Scissor Comb - фантазийные приманки для ловли на водоёмах с высоким рыболовным прессингом.
Код товара: 9484-021
Код товара: 4227-021
Jackall Cherry 0 Footer 48 – уловистый поверхностный крэнк, неоднократно выручавший рыболовов при ловле в мутной воде. Купить приманку по привлекательной цене можно в нашем интернет-магазине.
Код товара: 9201-294
Классический мелководный рывковый воблер. Популярная модель для ловли трофейной щуки и судака.
Код товара: 7785-289
Jackall Wobbring - интересные приманки, привлекающие рыбу игрой крупного твистерного хвостика оригинальной формы и колебаниями червеобразного тела.
Согласен на получение рассылок и обработку персональных данных. С условиями использования сайта и положениями Политики конфиденциальности ознакомился.
Отправляя форму, даю согласие на обработку моих персональных данных. С положениями Политики конфиденциальности ознакомился.
{ "__default": { "session": { "counter": 51, "timer": { "start": 1781036594, "last": 1781036687, "now": 1781036688 }, "token": "ZLmmiu9PqDrPMoBmewD3pL4RoHsc1bf5" }, "registry": { "jshoping": { "list": { "front": { "product": { "cat": { "98manufacturers": "", "98categorys": "", "98fprice_from": "", "98fprice_to": "", "98extra_fields": "", "98available_only": "", "98sale": "", "98attrs": "", "355manufacturers": "", "355categorys": "", "355fprice_from": "", "355fprice_to": "", "355extra_fields": "", "355available_only": "", "355sale": "", "355attrs": "", "21manufacturers": "", "21categorys": "", "21fprice_from": "", "21fprice_to": "", "21extra_fields": "", "21available_only": "", "21sale": "", "21attrs": "", "4manufacturers": "", "4categorys": "", "4fprice_from": "", "4fprice_to": "", "4extra_fields": "", "4available_only": "", "4sale": "", "4attrs": "", "102manufacturers": "", "102categorys": "", "102fprice_from": "", "102fprice_to": "", "102extra_fields": "", "102available_only": "", "102sale": "", "102attrs": "", "66manufacturers": "", "66categorys": "", "66fprice_from": "", "66fprice_to": "", "66extra_fields": "", "66available_only": "", "66sale": "", "66attrs": "", "65manufacturers": "", "65categorys": "", "65fprice_from": "", "65fprice_to": "", "65extra_fields": "", "65available_only": "", "65sale": "", "65attrs": "", "241manufacturers": "", "241categorys": "", "241fprice_from": "", "241fprice_to": "", "241extra_fields": "", "241available_only": "", "241sale": "", "241attrs": "" }, "manf": { "380manufacturers": "", "380categorys": "", "380fprice_from": "", "380fprice_to": "", "380extra_fields": "", "380available_only": "", "380sale": "", "380attrs": "", "295manufacturers": "", "295categorys": "", "295fprice_from": "", "295fprice_to": "", "295extra_fields": "", "295available_only": "", "295sale": "", "295attrs": "", "126manufacturers": "", "126categorys": "", "126fprice_from": "", "126fprice_to": "", "126extra_fields": "", "126available_only": "", "126sale": "", "126attrs": "", "202manufacturers": "", "202categorys": "", "202fprice_from": "", "202fprice_to": "", "202extra_fields": "", "202available_only": "", "202sale": "", "202attrs": "", "611manufacturers": "", "611categorys": "", "611fprice_from": "", "611fprice_to": "", "611extra_fields": "", "611available_only": "", "611sale": "", "611attrs": "", "514manufacturers": "", "514categorys": "", "514fprice_from": "", "514fprice_to": "", "514extra_fields": "", "514available_only": "", "514sale": "", "514attrs": "", "595manufacturers": "", "595categorys": "", "595fprice_from": "", "595fprice_to": "", "595extra_fields": "", "595available_only": "", "595sale": "", "595attrs": "", "422manufacturers": "", "422categorys": "", "422fprice_from": "", "422fprice_to": "", "422extra_fields": "", "422available_only": "", "422sale": "", "422attrs": "", "425manufacturers": "", "425categorys": "", "425fprice_from": "", "425fprice_to": "", "425extra_fields": "", "425available_only": "", "425sale": "", "425attrs": "", "605manufacturers": "", "605categorys": "", "605fprice_from": "", "605fprice_to": "", "605extra_fields": "", "605available_only": "", "605sale": "", "605attrs": "", "435manufacturers": "", "435categorys": "", "435fprice_from": "", "435fprice_to": "", "435extra_fields": "", "435available_only": "", "435sale": "", "435attrs": "", "406manufacturers": "", "406categorys": "", "406fprice_from": "", "406fprice_to": "", "406extra_fields": "", "406available_only": "", "406sale": "", "406attrs": "", "494manufacturers": "", "494categorys": "", "494fprice_from": "", "494fprice_to": "", "494extra_fields": "", "494available_only": "", "494sale": "", "494attrs": "", "228manufacturers": "", "228categorys": "", "228fprice_from": "", "228fprice_to": "", "228extra_fields": "", "228available_only": "", "228sale": "", "228attrs": "", "556manufacturers": "", "556categorys": "", "556fprice_from": "", "556fprice_to": "", "556extra_fields": "", "556available_only": "", "556sale": "", "556attrs": "", "695manufacturers": "", "695categorys": "", "695fprice_from": "", "695fprice_to": "", "695extra_fields": "", "695available_only": "", "695sale": "", "695attrs": "", "623manufacturers": "", "623categorys": "", "623fprice_from": "", "623fprice_to": "", "623extra_fields": "", "623available_only": "", "623sale": "", "623attrs": "", "564manufacturers": "", "564categorys": "", "564fprice_from": "", "564fprice_to": "", "564extra_fields": "", "564available_only": "", "564sale": "", "564attrs": "", "309manufacturers": "", "309categorys": "", "309fprice_from": "", "309fprice_to": "", "309extra_fields": "", "309available_only": "", "309sale": "", "309attrs": "", "719manufacturers": "", "719categorys": "", "719fprice_from": "", "719fprice_to": "", "719extra_fields": "", "719available_only": "", "719sale": "", "719attrs": "", "774manufacturers": "", "774categorys": "", "774fprice_from": "", "774fprice_to": "", "774extra_fields": "", "774available_only": "", "774sale": "", "774attrs": "", "728manufacturers": "", "728categorys": "", "728fprice_from": "", "728fprice_to": "", "728extra_fields": "", "728available_only": "", "728sale": "", "728attrs": "", "169manufacturers": "", "169categorys": "", "169fprice_from": "", "169fprice_to": "", "169extra_fields": "", "169available_only": "", "169sale": "", "169attrs": "", "264manufacturers": "", "264categorys": "", "264fprice_from": "", "264fprice_to": "", "264extra_fields": "", "264available_only": "", "264sale": "", "264attrs": "", "593manufacturers": "", "593categorys": "", "593fprice_from": "", "593fprice_to": "", "593extra_fields": "", "593available_only": "", "593sale": "", "593attrs": "", "155manufacturers": "", "155categorys": "", "155fprice_from": "", "155fprice_to": "", "155extra_fields": "", "155available_only": "", "155sale": "", "155attrs": "", "101manufacturers": "", "101categorys": "", "101fprice_from": "", "101fprice_to": "", "101extra_fields": "", "101available_only": "", "101sale": "", "101attrs": "", "261manufacturers": "", "261categorys": "", "261fprice_from": "", "261fprice_to": "", "261extra_fields": "", "261available_only": "", "261sale": "", "261attrs": "", "498manufacturers": "", "498categorys": "", "498fprice_from": "", "498fprice_to": "", "498extra_fields": "", "498available_only": "", "498sale": "", "498attrs": "", "447manufacturers": "", "447categorys": "", "447fprice_from": "", "447fprice_to": "", "447extra_fields": "", "447available_only": "", "447sale": "", "447attrs": "" } }, "productorder": "", "productorderby": "", "productlimit": "" } } } }, "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/jackall", "jshop_end_page_list_product": "/primanki/jackall" } }
SELECT `data` FROM `fish_session` WHERE `session_id` = X'7470707564326574746832387036366e6c31307067726332396c'
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\":\"d80ddf881779c64e117d64d2fb23f57e\"}' WHERE `type` = 'library' AND `element` = 'joomla'
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 manufacturer_id as id, `alias_ru-RU` as alias from fish_jshopping_manufacturers where `alias_ru-RU`!=''
SELECT product_publish, product_id, `name_ru-RU` as name, `alias_ru-RU` as alias, alias_family, family FROM fish_jshopping_products WHERE (alias_family='category' OR `alias_ru-RU`='category') AND product_price>0 ORDER BY product_publish DESC, product_quantity DESC, product_price ASC
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
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.product_manufacturer_id in (142) AND prod.listing_product >0
SELECT p.product_id, x.category_id, p.`name_ru-RU` as name, p.`short_description_ru-RU` as short_description, p.product_ean, p.manufacturer_code, p.image, p.product_price, p.currency_id, p.product_tax_id as tax_id, p.product_old_price, p.product_weight, p.average_rating, p.reviews_count, p.hits, p.weight_volume_units, p.basic_price_unit_id, p.label_id, p.product_manufacturer_id, p.min_price, MAX(p.product_quantity) as product_quantity, p.different_prices, p.`alias_ru-RU` as alias, p.sales, p.alias_family, p.family_seo, p.family, p.product_template FROM (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.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, MAX(prod.product_quantity) as product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, 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.product_manufacturer_id in (142) GROUP BY prod.family ) as x INNER JOIN fish_jshopping_products p ON p.family=x.family AND p.product_quantity=x.product_quantity WHERE p.product_publish=1 GROUP BY p.family ORDER BY MAX(p.product_quantity=0), p.image='', p.hits DESC LIMIT 0, 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 ('15131','15007','20900','5983','17154','17053','19586','15558','17503','15475','15951','6141','69010','15223','16076','7414') ORDER BY product_attr_id
SHOW FULL COLUMNS FROM `fish_jshopping_products`
SELECT * FROM fish_jshopping_products WHERE `product_id` = '15131'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=15131 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '15007'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=15007 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '20900'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=20900 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '5983'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=5983 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '17154'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=17154 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '17053'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=17053 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '19586'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=19586 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '15558'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=15558 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '17503'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=17503 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '15475'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=15475 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '15951'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=15951 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '6141'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=6141 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '69010'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=69010 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '15223'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=15223 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '16076'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=16076 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '7414'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=7414 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` = 'Воблер JACKALL Boil Trigger' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=15131 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 Baby Giron' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=15007 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 Tiny Magallon' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=20900 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 Rhythm Wave' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=5983 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 Squirrel' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=17154 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 Soul Shad SR SP' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=17053 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 Chubby' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=19586 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 Colt Minnow' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=15558 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 Tn Slim' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=17503 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 Chubby 38SR' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=15475 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 Giron' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=15951 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 Scissor Comb' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=6141 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 Re/70' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=69010 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 Cherry 0 Footer' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=15223 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 Jockie' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=16076 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 Wobbring' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=7414 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`
SELECT `name_ru-RU` as name,`description_ru-RU` as descr,manufacturer_logo,`short_description_ru-RU` as short_descr FROM `fish_jshopping_manufacturers` WHERE manufacturer_id=142
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 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-09 20:24:50') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-09 20:24:50') 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 * FROM fish_jshopping_manufacturers WHERE `manufacturer_id` = '142'
SELECT distinct cat.category_id as id, cat.`name_ru-RU` as name FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `fish_jshopping_categories` as cat on cat.category_id=categ.category_id WHERE prod.product_publish=1 AND prod.product_manufacturer_id=142 AND cat.category_publish=1 AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) 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 (752,101,146,188,189,190,336,339,341,342,343,344,345,346,348,351,352,401,402,403,405,407,408,448,426,427,428,429,434,347,349,350,406,412,413,415,416,417,409,449,450,451,414) AND pr.product_manufacturer_id in (142) 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 (2817,2879,2994,2415,2997,2416) 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 (752,101,146,188,189,190,336,339,341,342,343,344,345,346,348,351,352,401,402,403,405,407,408,448,426,427,428,429,434,347,349,350,406,412,413,415,416,417,409,449,450,451,414) AND pr.product_manufacturer_id in (142)
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 (752,101,146,188,189,190,336,339,341,342,343,344,345,346,348,351,352,401,402,403,405,407,408,448,426,427,428,429,434,347,349,350,406,412,413,415,416,417,409,449,450,451,414) AND pr.product_manufacturer_id in (142)
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`.`alias_ru-RU` as alias, prod.sales, 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 desc LIMIT 45, 1
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 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`.`alias_ru-RU` as alias, prod.sales, 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 453, 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`.`alias_ru-RU` as alias, prod.sales, 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 920, 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`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (102,103,104,106,124,136,171,177,105,108,198,269,273,277,125,126,133,135,137,161,180,182,144,307,178,304) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price desc LIMIT 305, 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`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (65,66,67,166,275,305,94,138,139,197,140,141,142,165,174,187,200,172,175,176,206,270,199) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price asc LIMIT 2124, 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`.`alias_ru-RU` as alias, prod.sales, 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='', name asc LIMIT 350, 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`.`alias_ru-RU` as alias, prod.sales, 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 desc LIMIT 2226, 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`.`alias_ru-RU` as alias, prod.sales, 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='', prod.product_price asc LIMIT 120, 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`.`alias_ru-RU` as alias, prod.sales, 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 `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
2 × SELECT id, `name_ru-RU` as name, field_id FROM `fish_jshopping_products_extra_field_values`
1 × SELECT `data` FROM `fish_session`
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 `name_ru-RU` as name,`description_ru-RU` as descr,manufacturer_logo,`short_description_ru-RU` as short_descr FROM `fish_jshopping_manufacturers`
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 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 * FROM fish_jshopping_manufacturers
1 × SELECT distinct cat.category_id as id, cat.`name_ru-RU` as name FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `fish_jshopping_categories` as cat on cat.category_id=categ.category_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`.`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 category_id as id, `alias_ru-RU` as alias from fish_jshopping_categories
1 × SELECT p.product_id, x.category_id, p.`name_ru-RU` as name, p.`short_description_ru-RU` as short_description, p.product_ean, p.manufacturer_code, p.image, p.product_price, p.currency_id, p.product_tax_id as tax_id, p.product_old_price, p.product_weight, p.average_rating, p.reviews_count, p.hits, p.weight_volume_units, p.basic_price_unit_id, p.label_id, p.product_manufacturer_id, p.min_price, MAX(p.product_quantity) as product_quantity, p.different_prices, p.`alias_ru-RU` as alias, p.sales, p.alias_family, p.family_seo, p.family, p.product_template FROM (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.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, MAX(prod.product_quantity) as product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, 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 product_id as id, `alias_ru-RU` as alias from fish_jshopping_products
1 × select manufacturer_id as id, `alias_ru-RU` as alias from fish_jshopping_manufacturers
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 id, image, color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT * FROM fish_jshopping_config
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies`
1 × SELECT product_publish, product_id, `name_ru-RU` as name, `alias_ru-RU` as alias, alias_family, family FROM fish_jshopping_products
1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url from fish_jshopping_manufacturers
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 `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 id, image, `name_ru-RU` as name FROM `fish_jshopping_product_labels`
1 × UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"d80ddf881779c64e117d64d2fb23f57e\"}'
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
1 × SHOW FULL COLUMNS FROM `fish_jshopping_product_labels