Код товара: 1000-497
Шикарный сувенир охотничьей направленности, произведенный известной английской фирмой ТВМ, для всех любителей оружия и всего, связанного с любимым увлечением.
Звоните, наши специалисты Вам помогут!
Все товары, представленные в интернет-магазине, можно приобрести в розничном магазине "Rybaki.ru".
Адрес: Москва, ул. 5-я Кабельная, д. 2, стр. 1, уровень 5 в ТРК "СпортЕХ"
График работы: ежедневно с 10:00 до 21:00
Код товара: 6173-020
Крючок оффсетный VMC 7316 LD (5 шт.) № 2/0
Код товара: 8207-017
Монофильная леска LINE SYSTEM Iso Wax с нейтральной плавучестью для ловли в стиле Roch Fishing.
Код товара: 9223
Превосходные стельки для использования в холодную погоду и особенно зимний период. Точно рассчитанная ортопедическая форма изделя держит стопуноги в правильном положении в обуви, не давая её свободно смещаться. Отличный влаго и теплообмен всегда сохранит ваши ноги в тепле.
Код товара: 4641-762
Удилище спиннинговое NORSTREAM Dynamic III 762ML тест 4 - 15 гр
Код товара: 1000-493
Код товара: 12124
Охотничьи сапоги высшего класса Lacrosse Alphaburly Pro, в которых воплотились замечательные традиции и новейшие технологии, предлагаются в камуфляже GORE™ OPTIFADE™ и дополняют систему одежды Sitka® Gear. В этих сапогах, изготовленных из высококачественной, не имеющей запаха резины и неопренового утеплителя, вам не страшны ни холода, ни пересеченная местность, ни всевозможные охотничьи тяготы. Толстая амортизирующая подложка из ЭВА обеспечивает комфорт ступне, рельефная подкладка улучшает циркуляцию воздуха, а регулируемый манжет идеально фиксирует ногу.
Код товара: 11937-135
Код товара: 2402-006
Качественный рыболовный аксесуар.
Код товара: 9873-001
Салфетка MAKO Sunglass Clens Cleaning Cloth для протирания очков
Код товара: 14253-878
Код товара: 9651-002
Оснастка DEEP RIVER донная Ахтуба Профи (волос, клипса 150 гр, кр. № 2)
Код товара: 6959
Комплект термобелья MONTERO Primaloft Hybrid 220 детский цв. черный р. 164-170
Код товара: 6358-012
Монолеска VARIVAS серии Super Trout Advance Nylon из нейлона для ловли форели.
Код товара: 8196-035
Высококачественная японская монолеска INE SYSTEM The Black с низкой растяжимостью и высочайшей прочностью.
Код товара: 6477
А этой модели предусмотрена возможность преобразования в штаны. Нижняя часть выполнена из ткани повышенной прочности.
Согласен на получение рассылок и обработку персональных данных. С условиями использования сайта и положениями Политики конфиденциальности ознакомился.
Отправляя форму, даю согласие на обработку моих персональных данных. С положениями Политики конфиденциальности ознакомился.
{ "__default": { "session": { "counter": 83, "timer": { "start": 1781037552, "last": 1781037711, "now": 1781037713 }, "token": "d5UshYveQTF85hOCjk4qX3M4NJY9zE2o" }, "registry": { "jshoping": { "list": { "front": { "product": { "manf": { "454manufacturers": "", "454categorys": "", "454fprice_from": "", "454fprice_to": "", "454extra_fields": "", "454available_only": "", "454sale": "", "454attrs": "", "331manufacturers": "", "331categorys": "", "331fprice_from": "", "331fprice_to": "", "331extra_fields": "", "331available_only": "", "331sale": "", "331attrs": "", "239manufacturers": "", "239categorys": "", "239fprice_from": "", "239fprice_to": "", "239extra_fields": "", "239available_only": "", "239sale": "", "239attrs": "" }, "cat": { "172manufacturers": "", "172categorys": "", "172fprice_from": "", "172fprice_to": "", "172extra_fields": "", "172available_only": "", "172sale": "", "172attrs": "", "251manufacturers": "", "251categorys": "", "251fprice_from": "", "251fprice_to": "", "251extra_fields": "", "251available_only": "", "251sale": "", "251attrs": "", "124manufacturers": "", "124categorys": "", "124fprice_from": "", "124fprice_to": "", "124extra_fields": "", "124available_only": "", "124sale": "", "124attrs": "", "145manufacturers": "", "145categorys": "", "145fprice_from": "", "145fprice_to": "", "145extra_fields": "", "145available_only": "", "145sale": "", "145attrs": "", "381manufacturers": "", "381categorys": "", "381fprice_from": "", "381fprice_to": "", "381extra_fields": "", "381available_only": "", "381sale": "", "381attrs": "", "522manufacturers": "", "522categorys": "", "522fprice_from": "", "522fprice_to": "", "522extra_fields": "", "522available_only": "", "522sale": "", "522attrs": "", "100manufacturers": "", "100categorys": "", "100fprice_from": "", "100fprice_to": "", "100extra_fields": "", "100available_only": "", "100sale": "", "100attrs": "", "311manufacturers": "", "311categorys": "", "311fprice_from": "", "311fprice_to": "", "311extra_fields": "", "311available_only": "", "311sale": "", "311attrs": "", "102manufacturers": "", "102categorys": "", "102fprice_from": "", "102fprice_to": "", "102extra_fields": "", "102available_only": "", "102sale": "", "102attrs": "", "29manufacturers": "", "29categorys": "", "29fprice_from": "", "29fprice_to": "", "29extra_fields": "", "29available_only": "", "29sale": "", "29attrs": "", "66manufacturers": "", "66categorys": "", "66fprice_from": "", "66fprice_to": "", "66extra_fields": "", "66available_only": "", "66sale": "", "66attrs": "", "169manufacturers": "", "169categorys": "", "169fprice_from": "", "169fprice_to": "", "169extra_fields": "", "169available_only": "", "169sale": "", "169attrs": "", "140manufacturers": "", "140categorys": "", "140fprice_from": "", "140fprice_to": "", "140extra_fields": "", "140available_only": "", "140sale": "", "140attrs": "", "385manufacturers": "", "385categorys": "", "385fprice_from": "", "385fprice_to": "", "385extra_fields": "", "385available_only": "", "385sale": "", "385attrs": "", "386manufacturers": "", "386categorys": "", "386fprice_from": "", "386fprice_to": "", "386extra_fields": "", "386available_only": "", "386sale": "", "386attrs": "", "167manufacturers": "", "167categorys": "", "167fprice_from": "", "167fprice_to": "", "167extra_fields": "", "167available_only": "", "167sale": "", "167attrs": "", "844manufacturers": "", "844categorys": "", "844fprice_from": "", "844fprice_to": "", "844extra_fields": "", "844available_only": "", "844sale": "", "844attrs": "", "103manufacturers": "", "103categorys": "", "103fprice_from": "", "103fprice_to": "", "103extra_fields": "", "103available_only": "", "103sale": "", "103attrs": "", "158manufacturers": "", "158categorys": "", "158fprice_from": "", "158fprice_to": "", "158extra_fields": "", "158available_only": "", "158sale": "", "158attrs": "", "393manufacturers": "", "393categorys": "", "393fprice_from": "", "393fprice_to": "", "393extra_fields": "", "393available_only": "", "393sale": "", "393attrs": "", "58manufacturers": "", "58categorys": "", "58fprice_from": "", "58fprice_to": "", "58extra_fields": "", "58available_only": "", "58sale": "", "58attrs": "", "147manufacturers": "", "147categorys": "", "147fprice_from": "", "147fprice_to": "", "147extra_fields": "", "147available_only": "", "147sale": "", "147attrs": "", "98manufacturers": "", "98categorys": "", "98fprice_from": "", "98fprice_to": "", "98extra_fields": "", "98available_only": "", "98sale": "", "98attrs": "", "41manufacturers": "", "41categorys": "", "41fprice_from": "", "41fprice_to": "", "41extra_fields": "", "41available_only": "", "41sale": "", "41attrs": "", "4manufacturers": "", "4categorys": "", "4fprice_from": "", "4fprice_to": "", "4extra_fields": "", "4available_only": "", "4sale": "", "4attrs": "", "395manufacturers": "", "395categorys": "", "395fprice_from": "", "395fprice_to": "", "395extra_fields": "", "395available_only": "", "395sale": "", "395attrs": "", "842manufacturers": "", "842categorys": "", "842fprice_from": "", "842fprice_to": "", "842extra_fields": "", "842available_only": "", "842sale": "", "842attrs": "", "74manufacturers": "", "74categorys": "", "74fprice_from": "", "74fprice_to": "", "74extra_fields": "", "74available_only": "", "74sale": "", "74attrs": "", "366manufacturers": "", "366categorys": "", "366fprice_from": "", "366fprice_to": "", "366extra_fields": "", "366available_only": "", "366sale": "", "366attrs": "" }, "fulllist": { "2manufacturers": "", "2categorys": "", "2fprice_from": "", "2fprice_to": "", "2extra_fields": "", "2available_only": "", "2sale": "", "2attrs": "" } }, "productorder": "", "productorderby": "", "productlimit": "" } } }, "start": 64, "manufacturers": "", "categorys": "", "fprice_from": "", "fprice_to": "", "extra_fields": "", "available_only": "", "sale": "", "attrs": "" }, "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": "/rasprodazha?start=64", "jshop_end_page_list_product": "/rasprodazha?start=64", "product_back_value": [] } }
SELECT `data` FROM `fish_session` WHERE `session_id` = X'75637235676f636a69306431353133676c326735647432377063'
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\":\"6c08ebcaaedf9e83f550a71d73a14ff0\"}' 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_products`
SHOW FULL COLUMNS FROM `fish_jshopping_config_seo`
SELECT id, alias, `title_ru-RU` as title, `keyword_ru-RU` as keyword, `description_ru-RU` as description FROM `fish_jshopping_config_seo` where alias='all-products'
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` as prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (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 prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.label_id in (2) AND prod.listing_product >0
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 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.sales, p.`alias_ru-RU` as alias, 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.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) 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.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.label_id in (2) 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 64, 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 ('33943','12527','12913','26997','21259','33938','26918','13904','29646','12032','49784','37378','27404','32758','13078','27215') ORDER BY product_attr_id
SELECT pa.product_id,pa.count,av.attr_id, pa.attr_1 ,av.`name_ru-RU` as value_name,av.image FROM fish_jshopping_products_attr AS pa LEFT JOIN fish_jshopping_attr_values AS av ON pa.attr_1=av.value_id WHERE pa.product_id IN ('33943','12527','12913','26997','21259','33938','26918','13904','29646','12032','49784','37378','27404','32758','13078','27215') ORDER BY av.value_ordering ASC
SELECT * FROM fish_jshopping_products WHERE `product_id` = '26997'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '26918'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '27404'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '27215'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '33943'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=33943 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '12527'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=12527 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '12913'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=12913 ORDER BY product_attr_id
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=26997 ORDER BY product_attr_id
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price FROM `fish_jshopping_products_attr` as PA INNER JOIN fish_jshopping_attr_values as V ON PA.attr_1=V.value_id WHERE PA.product_id=26997 ORDER BY V.value_ordering
SELECT * FROM fish_jshopping_products WHERE `product_id` = '21259'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=21259 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '33938'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=33938 ORDER BY product_attr_id
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=26918 ORDER BY product_attr_id
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price FROM `fish_jshopping_products_attr` as PA INNER JOIN fish_jshopping_attr_values as V ON PA.attr_1=V.value_id WHERE PA.product_id=26918 ORDER BY V.value_ordering
SELECT * FROM fish_jshopping_products WHERE `product_id` = '13904'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=13904 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '29646'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=29646 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '12032'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=12032 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '49784'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=49784 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '37378'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=37378 ORDER BY product_attr_id
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=27404 ORDER BY product_attr_id
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price FROM `fish_jshopping_products_attr` as PA INNER JOIN fish_jshopping_attr_values as V ON PA.attr_1=V.value_id WHERE PA.product_id=27404 ORDER BY V.value_ordering
SELECT * FROM fish_jshopping_products WHERE `product_id` = '32758'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=32758 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '13078'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=13078 ORDER BY product_attr_id
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=27215 ORDER BY product_attr_id
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price FROM `fish_jshopping_products_attr` as PA INNER JOIN fish_jshopping_attr_values as V ON PA.attr_1=V.value_id WHERE PA.product_id=27215 ORDER BY V.value_ordering
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` = 'Дисплей TMB Mp38' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=62 ORDER BY p.product_id=33943 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` = 'Крючок офсетный VMC 7316 Ld' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=104 ORDER BY p.product_id=12527 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` = 'Леска LINE SYSTEM Iso Wax' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=158 ORDER BY p.product_id=12913 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family_seo` = 'Thermoform' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=26997 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` = 'Спиннинг NORSTREAM Dynamic III' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=121 ORDER BY p.product_id=21259 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` = 'Дисплей TMB G36' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=62 ORDER BY p.product_id=33938 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family_seo` = 'Alphaburly Pro 18\" 1600G' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=54 ORDER BY p.product_id=26918 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Ледобур HEINOLA Speedrun Comfort' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=212 ORDER BY p.product_id=13904 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` = 'Аксессуары карповые MIDDY Резка Для Донной Приманки' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=72 ORDER BY p.product_id=29646 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` = 'Салфетка для очков MAKO Sunglass Clens Cleaning Cloth' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=185 ORDER BY p.product_id=12032 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 Big Rui' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=132 ORDER BY p.product_id=49784 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` = 'Оснастка DEEP RIVER Донная Ахтуба Профи' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=311 ORDER BY p.product_id=37378 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family_seo` = 'Primaloft Hybrid 220 Детский' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=262 ORDER BY p.product_id=27404 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` = 'Леска VARIVAS Super Trout Advance' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=156 ORDER BY p.product_id=32758 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` = 'Леска LINE SYSTEM The Black' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=158 ORDER BY p.product_id=13078 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family_seo` = 'Headwaters Convertible' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=27215 DESC, `name_ru-RU` ASC
SHOW FULL COLUMNS FROM `fish_jshopping_manufacturers`
SELECT `alias_ru-RU` as alias, 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 name asc
SHOW FULL COLUMNS FROM `fish_jshopping_categories`
SELECT `name_ru-RU` as name, category_id, category_parent_id, category_publish FROM `fish_jshopping_categories` where category_publish = '1' and access IN (1,1,5) ORDER BY category_parent_id, ordering
SHOW FULL COLUMNS FROM `fish_jshopping_products_reviews`
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:41:54') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-09 20:41:54') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 327 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=327 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_manufacturers` AS `man` ON pr.product_manufacturer_id=man.manufacturer_id WHERE pr.product_publish=1 AND pr.label_id=2 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` WHERE pr.product_publish=1 AND pr.label_id=2 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 (2313,2247,2251,7355,2423,2310,2356,2390,2571,2354,2817,2325,2326,2881,2994,3290,2879,2880,2877,2999,2622,3014,2352,2995,2613,3286,2383,2318,2813,2814,2323,2359,7008,2689,2761,2749,2746,7347,7346,2302,2402,3065,2838,2583,2588,2637,7350,2358,2742,2754,2751,2417,2579,2424,2792,2471,2332,2280,2304,2415,2237,2707,3036,2902,2832,2705,7365,3172,7362,7177,7185,2911,2382,2453,2632,2763,3018,2483,2478,2825,2249,2327,2330,2859,2816,2664,2582,2658,2665,2291,2349,2289,2419,2454,2469,2470,2572,7476,2506,2517,2518,2567,2629,7368,2441,3025,8121,2642,2695,2704,2301,2753,3038,2250,2425,2260,2384,2587,8085,2730,2829,2385,2389,2303,2392,7348,2388,2487,3006,2687,2525,3087,3193,2387,2434,2299,2718,3294,2339,4250,2946,2863,4270,6108,4307,4306,2400,2786,4747,3289,4757,2738,2726,2725,2942,2969,4855,2395,7398,2337,7517,7522,4893,4972,4976,2492,2481,2239,2258,2345,2259,2673,3240,4707,2708,2765,2669,7372,7498,5676,5700,2845,4789,5708,2633,5735,2736,2771,2591,2416,2256,2341,2987,2321,2578,2808,8026,3242,3020,7323,2908,6397,4415,9595,3109,2847,6476,2733,9635,2398,5893,7409,6776,2635,2769,2920,3248,7353,2939,2445,7157,5152,7162,3267,2854,7247,7109,2899,5107,7171,9318,7172,7167,7179,3069,7158,2778,2784,7153,7147,7166,2931,7240,4779,7174,2780,7719,7963,2719,2803,7940,2552,7933,7907,2723,7942,7948,7837,2862,2884,4880,7154,7929,7922,2731,7959,8040,8041,8042,8060,8127,8084,2463,8102,8115,2855,8095,8093,8110,3263,8104,2376,7699,5145,2414,8376,8341,2706,2252,6032,7160,8120,7251,9205,6446,7408,7152,2840,7252,5719,7169,2409,8225,2255,3059,2900,2734,8681,8678,8679,8680,8669,8676,2501,8682,2503,8683,7020,2767,2802,7033,8793,8794,8028,2676,8788,8647,7175,2682,8881,5105,9234,2513,2437,7063,7014,7066,2648,2790,7434,8126,5155,2562,9693,6740) ORDER BY name
SELECT min(CAST(pr.`product_price` as DECIMAL)) as min,max(CAST(pr.`product_price` as DECIMAL)) as max FROM `fish_jshopping_products` AS `pr` WHERE pr.product_publish=1 AND pr.label_id=2
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 asc LIMIT 60, 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 desc LIMIT 147, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (101,107,156,183,146,188,189,190,192,168,194,195,196) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (101,107,156,183,146,188,189,190,192,168,194,195,196) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price desc LIMIT 874, 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='', name asc LIMIT 409, 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 desc LIMIT 35, 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='', name asc LIMIT 272, 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='', prod.product_price asc LIMIT 1523, 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='', prod.product_price asc LIMIT 113, 1
20 × SELECT * FROM fish_jshopping_products
17 × SELECT * FROM `fish_jshopping_products_attr`
16 × SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p`
8 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
8 × SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
4 × SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price FROM `fish_jshopping_products_attr` as PA INNER JOIN fish_jshopping_attr_values as V ON PA.attr_1=V.value_id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions`
2 × SELECT id, `name_ru-RU` as name, field_id FROM `fish_jshopping_products_extra_field_values`
1 × SELECT 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 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 pa.product_id,pa.count,av.attr_id, pa.attr_1 ,av.`name_ru-RU` as value_name,av.image FROM fish_jshopping_products_attr AS pa LEFT JOIN fish_jshopping_attr_values AS av ON pa.attr_1=av.value_id
1 × SELECT `params` FROM `fish_extensions`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM fish_extensions
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 `alias_ru-RU` as alias, 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 `name_ru-RU` as name, category_id, category_parent_id, category_publish FROM `fish_jshopping_categories`
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 distinct man.manufacturer_id as id,`man`.`name_ru-RU` AS `name` FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_manufacturers` AS `man` ON pr.product_manufacturer_id=man.manufacturer_id
1 × SELECT extension_id FROM fish_extensions
1 × SELECT DISTINCT(pr.extra_field_45) as id FROM `fish_jshopping_products` AS `pr`
1 × SELECT id,`name_ru-RU` as name,image,color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT min(CAST(pr.`product_price` as DECIMAL)) as min,max(CAST(pr.`product_price` as DECIMAL)) as max FROM `fish_jshopping_products` AS `pr`
1 × SELECT id, rules FROM `fish_viewlevels
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 fa.id,fa.required,fa.`name_ru-RU` AS name,fa.type FROM `fish_jshopping_free_attr` AS fa
1 × SELECT id, image, color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT tax_id, tax_name, tax_value FROM `fish_jshopping_taxes
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 id, alias, `title_ru-RU` as title, `keyword_ru-RU` as keyword, `description_ru-RU` as description FROM `fish_jshopping_config_seo`
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 COUNT(distinct prod.product_id) FROM `fish_jshopping_products` as prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
1 × select category_id as id, `alias_ru-RU` as alias from fish_jshopping_categories
1 × select id,link from fish_menu
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.sales, p.`alias_ru-RU` as alias, 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.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) LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
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, image, `name_ru-RU` as name FROM `fish_jshopping_product_labels`
1 × select product_id as id, `alias_ru-RU` as alias from fish_jshopping_products
1 × SELECT `data` FROM `fish_session`
1 × UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"6c08ebcaaedf9e83f550a71d73a14ff0\"}'
1 × SHOW FULL COLUMNS FROM `fish_jshopping_config
1 × SHOW FULL COLUMNS FROM `fish_jshopping_currencies
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products
1 × SHOW FULL COLUMNS FROM `fish_jshopping_config_seo
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_manufacturers
1 × SHOW FULL COLUMNS FROM `fish_jshopping_categories
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products_reviews
1 × SHOW FULL COLUMNS FROM `fish_jshopping_filters
