Код товара: 15194
Звоните, наши специалисты Вам помогут!
Все товары, представленные в интернет-магазине, можно приобрести в розничном магазине "Rybaki.ru".
Адрес: Москва, ул. 5-я Кабельная, д. 2, стр. 1, уровень 5 в ТРК "СпортЕХ"
График работы: ежедневно с 10:00 до 21:00
Код товара: 15306
Код товара: 15251
Код товара: 15567
Код товара: 15268
Код товара: 15327
Код товара: 15305
Код товара: 15610
Код товара: 15600
Код товара: 15243
Согласен на получение рассылок и обработку персональных данных. С условиями использования сайта и положениями Политики конфиденциальности ознакомился.
Отправляя форму, даю согласие на обработку моих персональных данных. С положениями Политики конфиденциальности ознакомился.
{ "__default": { "session": { "counter": 23, "timer": { "start": 1781020002, "last": 1781020049, "now": 1781020051 }, "token": "fyqHxFSiIPQhgWfAMThyxLAFVyCZKGLT" }, "registry": { "jshoping": { "list": { "front": { "product": { "cat": { "98manufacturers": "", "98categorys": "", "98fprice_from": "", "98fprice_to": "", "98extra_fields": "", "98available_only": "", "98sale": "", "98attrs": "", "99manufacturers": "", "99categorys": "", "99fprice_from": "", "99fprice_to": "", "99extra_fields": "", "99available_only": "", "99sale": "", "99attrs": "", "145manufacturers": "", "145categorys": "", "145fprice_from": "", "145fprice_to": "", "145extra_fields": "", "145available_only": "", "145sale": "", "145attrs": "", "29manufacturers": "", "29categorys": "", "29fprice_from": "", "29fprice_to": "", "29extra_fields": "", "29available_only": "", "29sale": "", "29attrs": "", "843manufacturers": "", "843categorys": "", "843fprice_from": "", "843fprice_to": "", "843extra_fields": "", "843available_only": "", "843sale": "", "843attrs": "", "66manufacturers": "", "66categorys": "", "66fprice_from": "", "66fprice_to": "", "66extra_fields": "", "66available_only": "", "66sale": "", "66attrs": "", "460manufacturers": "", "460categorys": "", "460fprice_from": "", "460fprice_to": "", "460extra_fields": "", "460available_only": "", "460sale": "", "460attrs": "", "172manufacturers": "", "172categorys": "", "172fprice_from": "", "172fprice_to": "", "172extra_fields": "", "172available_only": "", "172sale": "", "172attrs": "", "63manufacturers": "", "63categorys": "", "63fprice_from": "", "63fprice_to": "", "63extra_fields": "", "63available_only": "", "63sale": "", "63attrs": "", "167manufacturers": "", "167categorys": "", "167fprice_from": "", "167fprice_to": "", "167extra_fields": "", "167available_only": "", "167sale": "", "167attrs": "", "754manufacturers": "", "754categorys": "", "754fprice_from": "", "754fprice_to": "", "754extra_fields": "", "754available_only": "", "754sale": "", "754attrs": "", "380manufacturers": "", "380categorys": "", "380fprice_from": "", "380fprice_to": "", "380extra_fields": "", "380available_only": "", "380sale": "", "380attrs": "", "388manufacturers": "", "388categorys": "", "388fprice_from": "", "388fprice_to": "", "388extra_fields": "", "388available_only": "", "388sale": "", "388attrs": "", "140manufacturers": "", "140categorys": "", "140fprice_from": "", "140fprice_to": "", "140extra_fields": "", "140available_only": "", "140sale": "", "140attrs": "" } }, "productorder": "", "productorderby": "", "productlimit": "" } } }, "manufacturers": "", "categorys": "", "fprice_from": "", "fprice_to": "", "extra_fields": "", "available_only": "", "sale": "", "attrs": "", "start": 112 }, "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": "/odezhda/verkh?start=112", "jshop_end_page_list_product": "/odezhda/verkh?start=112", "product_back_value": [] } }
SELECT `data` FROM `fish_session` WHERE `session_id` = X'6d727375696361646c6f307139627673346b6a6f736168726239'
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\":\"4dda95abca619d3aef0a3fe9df8d3bf2\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT * FROM fish_languages WHERE published=1 ORDER BY ordering ASC
SELECT id, home, template, s.params FROM fish_template_styles as s LEFT JOIN fish_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SELECT id, image, color FROM `fish_jshopping_products_extra_field_values` WHERE image !='' OR color!=''
SHOW FULL COLUMNS FROM `fish_jshopping_config`
SELECT * FROM fish_jshopping_config WHERE `id` = '1'
SHOW FULL COLUMNS FROM `fish_jshopping_currencies`
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering
SHOW FULL COLUMNS FROM `fish_jshopping_categories`
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (140)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (141,142,165,174,187,200)
SELECT * FROM fish_jshopping_categories WHERE `category_id` = '140'
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 = '140' 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 = 141
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 = 142
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 = 165
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 = 174
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 = 187
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 = 200
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 (140,141,142,165,174,187,200) AND prod.product_publish=1 AND prod.listing_product>0 AND prod.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id) WHERE pr_cat.category_id IN (140,141,142,165,174,187,200) AND prod.product_publish=1 AND prod.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.hits DESC LIMIT 112, 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 ('87662','87654','95363','94070','89354','94510','95217','93890','94751','95215','95218','98377','93305','94071','94157','93320') 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 ('87662','87654','95363','94070','89354','94510','95217','93890','94751','95215','95218','98377','93305','94071','94157','93320') ORDER BY av.value_ordering ASC
SHOW FULL COLUMNS FROM `fish_jshopping_products`
SELECT * FROM fish_jshopping_products WHERE `product_id` = '87662'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '87654'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '95363'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '94070'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '89354'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '94510'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '95217'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '93890'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '94751'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '95215'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '95218'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '98377'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '93305'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '94071'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '94157'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '93320'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=87662 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=87662 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=87654 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=87654 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=95363 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=95363 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=94070 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=94070 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=89354 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=89354 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=94510 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=94510 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=95217 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=95217 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=93890 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=93890 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=94751 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=94751 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=95215 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=95215 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=95218 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=95218 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=98377 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=98377 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=93305 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=93305 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=94071 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=94071 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=94157 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=94157 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=93320 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=93320 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_seo` = 'Striper Bay Fill T-Shirt' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=87662 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` = 'Fish It Well Badge T-Shirt' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=87654 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` = 'Джерси 2023' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=121 ORDER BY p.product_id=95363 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` = 'Trout Outline T-Shirt' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=94070 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` = 'Fall Run Collared Jacket \'21' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=89354 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` = 'Buoy X Gore-tex Jacket' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=707 ORDER BY p.product_id=94510 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` = 'Challenger Fishing Jacket' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=95217 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` = 'Sten Fleece' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=543 ORDER BY p.product_id=93890 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family_seo` = 'Master 1503' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=429 ORDER BY p.product_id=94751 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` = 'Waypoints Rain Jacket' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=95215 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` = 'Women\'s Challenger Fishing Jacket' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=95218 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` = 'Challenger Fishing Hoody' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=98377 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` = 'Logo Frame T-Shirt' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=93305 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` = 'Two Tone Pocket Tee' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=94071 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` = 'Mermaid SS T-Shirt' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=707 ORDER BY p.product_id=94157 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` = 'Challenger Jacket \'20' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=93320 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 (140,141,142,165,174,187,200) AND prod.product_publish=1 AND prod.product_manufacturer_id!=0 AND prod.access IN (1,1,5) order by name
SHOW FULL COLUMNS FROM `fish_jshopping_products_reviews`
SHOW FULL COLUMNS FROM `fish_jshopping_manufacturers`
SELECT manufacturer_id, manufacturer_url, manufacturer_logo, manufacturer_publish, `name_ru-RU` as name, `description_ru-RU` as description, `short_description_ru-RU` as short_description FROM `fish_jshopping_manufacturers` WHERE manufacturer_publish = '1' ORDER BY ordering asc
select manufacturer_id as id, `alias_ru-RU` as alias from fish_jshopping_manufacturers where `alias_ru-RU`!=''
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM fish_modules AS m LEFT JOIN fish_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN fish_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-06-09 15:47:32') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-09 15:47:32') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 275 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=275 ORDER BY filter.filter_ordering
SELECT distinct man.manufacturer_id as id,`man`.`name_ru-RU` AS `name` FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id` LEFT JOIN `fish_jshopping_manufacturers` AS `man` ON pr.product_manufacturer_id=man.manufacturer_id WHERE pr.product_publish=1 AND prc.category_id in (140,141,142,165,174,187,200) AND product_manufacturer_id!=0 AND man.manufacturer_publish=1 ORDER BY name
SELECT extension_id FROM fish_extensions WHERE name = 'jshopping'
SELECT DISTINCT(pr.extra_field_45) as id FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id` WHERE pr.product_publish=1 AND prc.category_id in (140,141,142,165,174,187,200) 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 (2260,2256,2262,2904,4433,3194,8629,9664,2786,6040,2991,5892,2478,5783,7323,3034,2763,2633,3046,8026,7353,8382,8682,9624,6460,2939,2257,2480,3048,3193,2481) ORDER BY name
SELECT min(CAST(pr.`product_price` as DECIMAL)) as min,max(CAST(pr.`product_price` as DECIMAL)) as max FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id` WHERE pr.product_publish=1 AND prc.category_id in (140,141,142,165,174,187,200)
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (243,246,248,245,249,250,247,252,292) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (243,246,248,245,249,250,247,252,292) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price desc LIMIT 206, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (73,74,76,77,78,79,81,82,83,84) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (73,74,76,77,78,79,81,82,83,84) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name asc LIMIT 496, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (101,107,156,183,146,188,189,190,192,168,194,195,196) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (101,107,156,183,146,188,189,190,192,168,194,195,196) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price asc LIMIT 793, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (102,103,104,106,124,136,171,177,105,108,198,269,273,277,125,126,133,135,137,161,180,182,144,307,178,304) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (102,103,104,106,124,136,171,177,105,108,198,269,273,277,125,126,133,135,137,161,180,182,144,307,178,304) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price asc LIMIT 193, 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 (65,66,67,166,275,305,94,138,139,197,140,141,142,165,174,187,200,172,175,176,206,270,199) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (65,66,67,166,275,305,94,138,139,197,140,141,142,165,174,187,200,172,175,176,206,270,199) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price asc LIMIT 2232, 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 367, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,34,109,159,160,179,181,185,36,48,49,68,71,92,255,295) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,34,109,159,160,179,181,185,36,48,49,68,71,92,255,295) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name desc LIMIT 3694, 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 desc LIMIT 133, 1
32 × SELECT * FROM fish_jshopping_products
17 × SELECT * FROM `fish_jshopping_products_attr`
16 × 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
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
6 × SELECT category_id FROM fish_jshopping_categories
6 × SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id
3 × SELECT * FROM fish_jshopping_categories
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions`
2 × SELECT 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 fa.id,fa.required,fa.`name_ru-RU` AS name,fa.type FROM `fish_jshopping_free_attr` AS fa
1 × select manufacturer_id as id, `alias_ru-RU` as alias 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 distinct man.manufacturer_id as id,`man`.`name_ru-RU` AS `name` FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id` LEFT JOIN `fish_jshopping_manufacturers` AS `man` ON pr.product_manufacturer_id=man.manufacturer_id
1 × SELECT extension_id FROM fish_extensions
1 × SELECT DISTINCT(pr.extra_field_45) as id FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id`
1 × SELECT 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 id,`name_ru-RU` as name,image,color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname FROM `fish_jshopping_attr` as A left join `fish_jshopping_attr_groups` as G on A.` group`=G.id
1 × SELECT min(CAST(pr.`product_price` as DECIMAL)) as min,max(CAST(pr.`product_price` as DECIMAL)) as max FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id`
1 × SELECT `data` FROM `fish_session`
1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url from fish_jshopping_manufacturers
1 × select category_id as id, `alias_ru-RU` as alias from fish_jshopping_categories
1 × SELECT * FROM fish_jshopping_config
1 × SELECT id, rules FROM `fish_viewlevels
1 × SELECT b.id FROM fish_usergroups AS a LEFT JOIN fish_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM fish_extensions
1 × SELECT `params` FROM `fish_extensions`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM fish_menu AS m LEFT JOIN fish_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM fish_languages
1 × SELECT id, home, template, s.params FROM fish_template_styles as s LEFT JOIN fish_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT id, image, color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies`
1 × select product_id as id, `alias_ru-RU` as alias from fish_jshopping_products
1 × SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image, `alias_ru-RU` as alias FROM `fish_jshopping_categories`
1 × select id,link from fish_menu
1 × SELECT id FROM fish_jshopping_vendors
1 × SELECT * FROM fish_jshopping_vendors
1 × SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.` group`, G.`name_ru-RU` as groupname, multilist FROM `fish_jshopping_products_extra_fields` as F left join `fish_jshopping_products_extra_field_groups` as G on G.id=F. group
1 × SELECT tax_id, tax_name, tax_value FROM `fish_jshopping_taxes
1 × SELECT COUNT(distinct prod.product_id) FROM `fish_jshopping_products_to_categories` AS pr_cat INNER JOIN `fish_jshopping_products` AS prod ON pr_cat.product_id = prod.product_id
1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id)
1 × SELECT id, image, `name_ru-RU` as name FROM `fish_jshopping_product_labels`
1 × UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"4dda95abca619d3aef0a3fe9df8d3bf2\"}'
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
