Код товара: 15251
Звоните, наши специалисты Вам помогут!
Все товары, представленные в интернет-магазине, можно приобрести в розничном магазине "Rybaki.ru".
Адрес: Москва, ул. 5-я Кабельная, д. 2, стр. 1, уровень 5 в ТРК "СпортЕХ"
График работы: ежедневно с 10:00 до 21:00
Код товара: 14901
Код товара: 15014
Код товара: 13420
Код товара: 15243
Код товара: 15217-196
Код товара: 15305
Код товара: 6834
Код товара: 14662-151
Код товара: 15199
Код товара: 14825
Код товара: 15038-310
Код товара: 15361
Для путешествий на природе, походов, рыбалок, привалов на охоте наш магазин представляет широкий выбор туристического снаряжения. Любое обустройство на берегу реки или лесной поляне, чтобы скоротать время или наоборот, разбить лагерь на пару-тройку дней, требует высококачественного туристического снаряжения, которое поможет вам провести время с комфортом.
Туристическая мебель не позволит вам сидеть на каких-нибудь неприспособленных пеньках и бревнах. Вы сможете удобно расположиться в прочных раскладных креслах из легчайших сплавов за таким же удобным и надежным столиком. В случае непогоды вы всегда будете готовы развернуть над собой полог шатра, чтобы защититься от летнего жаркого солнца, или спрятаться от дождя. Переночевать на природе, слушая на закате пение птиц и стрекот сверчков можно в хорошей, непромокающей дышащей палатке, завернувшись в теплый и по домашнему уютный спальный мешок. А пока сон не настиг вас, мощная светодиодная лампа или фонарь позволят еще раз взглянуть на карту и уточнить маршрут перед завтрашним путешествием. Мы предлагаем вам туристическое снаряжение, которое используем сами.
Согласен на получение рассылок и обработку персональных данных. С условиями использования сайта и положениями Политики конфиденциальности ознакомился.
Отправляя форму, даю согласие на обработку моих персональных данных. С положениями Политики конфиденциальности ознакомился.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1781242161, "last": 1781242161, "now": 1781242161 }, "token": "SKYUcylPKxQG4C1ehweZg8duiTQBVJrv" }, "registry": { "jshoping": { "list": { "front": { "product": { "cat": { "30manufacturers": "", "30categorys": "", "30fprice_from": "", "30fprice_to": "", "30extra_fields": "", "30available_only": "", "30sale": "", "30attrs": "" } }, "productorder": "", "productorderby": "", "productlimit": "" } } }, "start": 2416 }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "js_id_currency_orig": "1", "js_id_currency": "1", "js_history_sel_lang": "ru-RU", "js_prev_user_id": 0, "jshop_checked_language": [ "en-GB", "ru-RU" ], "jshop_end_page_buy_product": "/snaryazhenie/turisticheskoe-snaryazhenie?start=2416", "jshop_end_page_list_product": "/snaryazhenie/turisticheskoe-snaryazhenie?start=2416" } }
SELECT `data` FROM `fish_session` WHERE `session_id` = X'7530657366686430326e6d316463747534706335617334643435'
SELECT `session_id` FROM `fish_session` WHERE `session_id` = X'7530657366686430326e6d316463747534706335617334643435' LIMIT 1
INSERT INTO `fish_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7530657366686430326e6d316463747534706335617334643435', 1, 1781242161, 0, '', 0)
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
SELECT id, rules FROM `fish_viewlevels`
SELECT b.id FROM fish_usergroups AS a LEFT JOIN fish_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM fish_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
SELECT `params` FROM `fish_extensions` WHERE `type` = 'component' AND `element` = 'com_jchoptimize'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM fish_menu AS m LEFT JOIN fish_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions` WHERE `type` = 'library' AND `element` = 'joomla'
UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"08ae2078290432e986cd86b573b6648d\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT * FROM fish_languages WHERE published=1 ORDER BY ordering ASC
SELECT id, home, template, s.params FROM fish_template_styles as s LEFT JOIN fish_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SELECT id, image, color FROM `fish_jshopping_products_extra_field_values` WHERE image !='' OR color!=''
SHOW FULL COLUMNS FROM `fish_jshopping_config`
SELECT * FROM fish_jshopping_config WHERE `id` = '1'
SHOW FULL COLUMNS FROM `fish_jshopping_currencies`
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering
select * from fish_jshopping_languages
SHOW FULL COLUMNS FROM `fish_jshopping_categories`
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (30)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967)
SELECT * FROM fish_jshopping_categories WHERE `category_id` = '30'
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 = '30' 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 = 31
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 = 54
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 = 57
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 = 70
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 = 97
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 = 110
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 = 186
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 = 201
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 = 202
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 = 203
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 = 208
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 = 290
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 = 296
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 = 297
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 = 298
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 = 299
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 = 300
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 = 301
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 = 302
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 (30,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967) 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 (30,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967) 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 2416, 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 ('93911','88563','88602','81618','93294','89282','93879','93876','96598','96223','62873','88235','88570','81120','95936','88603') 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 ('93911','88563','88602','81618','93294','89282','93879','93876','96598','96223','62873','88235','88570','81120','95936','88603') ORDER BY av.value_ordering ASC
SHOW FULL COLUMNS FROM `fish_jshopping_products`
SELECT * FROM fish_jshopping_products WHERE `product_id` = '93911'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '88563'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '88602'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '81618'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '93294'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '93879'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '93876'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '96598'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '96223'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '88235'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '88570'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '95936'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '88603'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=93911 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=93911 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=88563 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=88563 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=88602 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=88602 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=81618 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=81618 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=93294 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=93294 ORDER BY V.value_ordering
SELECT * FROM fish_jshopping_products WHERE `product_id` = '89282'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=89282 ORDER BY product_attr_id
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=93879 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=93879 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=93876 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=93876 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=96598 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=96598 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=96223 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=96223 ORDER BY V.value_ordering
SELECT * FROM fish_jshopping_products WHERE `product_id` = '62873'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=62873 ORDER BY product_attr_id
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=88235 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=88235 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=88570 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=88570 ORDER BY V.value_ordering
SELECT * FROM fish_jshopping_products WHERE `product_id` = '81120'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=81120 ORDER BY product_attr_id
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=95936 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=95936 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=88603 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=88603 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` = 'High Polish Chrome 12 ч' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=712 ORDER BY p.product_id=93911 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` = 'Несессер DEUTER 2021 Wash Bag II цвет Black / Titan' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=559 ORDER BY p.product_id=88563 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` = 'Сумка поясная DEUTER 2021 Neo Belt I цвет Black' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=559 ORDER BY p.product_id=88602 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` = 'туристическое Holiday Auto' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=211 ORDER BY p.product_id=81618 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` = 'Сумка SIMMS Flyweight Large Pod 5 цвет Cinder' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=52 ORDER BY p.product_id=93294 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` = 'Набор посуды FIRE-MAPLE Feast 4' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=562 ORDER BY p.product_id=89282 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` = 'Сумка дорожная TATONKA Squeezy Duffle L цвет Titan Grey' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=579 ORDER BY p.product_id=93879 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` = 'Мешок компрессионный TATONKA Compression Sack 18 цвет Blue' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=579 ORDER BY p.product_id=93876 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` = 'Гермосумка поясная MYSTERY RANCH High Water Hip Pack цвет Forest' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=745 ORDER BY p.product_id=96598 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` = 'Micron Lantern Steel Mesh' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=350 ORDER BY p.product_id=96223 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` = 'Швейцарский нож VICTORINOX Classic 58мм 7 функций' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=354 ORDER BY p.product_id=62873 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` = 'Термосумка AQUATIC С-20С с карманами цвет синий' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=454 ORDER BY p.product_id=88235 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` = 'Несессер HUNTINGHORN 334 Кожа цвет оранжевый' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=539 ORDER BY p.product_id=88570 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` = 'Нож OWL KNIFE North Грибок сталь N690 рукоять G10 черно-оливк' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=591 ORDER BY p.product_id=81120 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` = 'Гермосумка WATERSHED Ocoee 15 л цвет Smoke Green' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=316 ORDER BY p.product_id=95936 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` = 'Сумка поясная DEUTER 2021 Neo Belt I цвет Black / Seagreen' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=559 ORDER BY p.product_id=88603 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 (30,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967) AND prod.product_publish=1 AND prod.product_manufacturer_id!=0 AND prod.access IN (1,1,5) order by name
SHOW FULL COLUMNS FROM `fish_jshopping_products_reviews`
SHOW FULL COLUMNS FROM `fish_jshopping_manufacturers`
SELECT manufacturer_id, manufacturer_url, manufacturer_logo, manufacturer_publish, `name_ru-RU` as name, `description_ru-RU` as description, `short_description_ru-RU` as short_description FROM `fish_jshopping_manufacturers` WHERE manufacturer_publish = '1' ORDER BY ordering asc
select manufacturer_id as id, `alias_ru-RU` as alias from fish_jshopping_manufacturers where `alias_ru-RU`!=''
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM fish_modules AS m LEFT JOIN fish_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN fish_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-06-12 05:29:22') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-12 05:29:22') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 296 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=296 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 (30,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967) 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 (30,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967) AND pr.extra_field_45 != 0 AND pr.extra_field_45!=''
SELECT id,`name_ru-RU` as name,image,color FROM `fish_jshopping_products_extra_field_values` WHERE id IN (2909,2911,2377,7063,7014,7400,7066,2790,2376,7185,7503,2645,7157,2445,2854,7155,2380,8118,2899,7109,2891,5152,7162,3267,7247,8127,2650,8126,7493,4388,7434,2799,7152,3059,7408,7171,7175,7151,7156,2255,7223,9318,2890,7202,7161,3041,9205,7167,7237,2898,7210,7160,7172,7179,8215,7206,7176,2501,7251,7211,8225,7184,7225,8120,2852,2660,6446,7168,7212,5719,7200,8621,7232,8647,8669,8676,8675,8677,7245,2640,8707,8972,9316,9317,2896,2807,2341,2672,8121,2724,2651,2339,2337,2294,2642,2249,7024,8062,2718,2719,2822,2956,7250,8091,2794,2797,7397,2802,2848,3097,2318,7473,2796,2798,5129,2800,5132,8117,3107,2803,2805,8567,4728,2902,2900,3242,7105,2903,9685,9603,2913,2914,2552,4789,2847,2843,8013,8849,8847,2575,7394,2859,2816,2860,2858,7396,2831,2846,7517,2291,2818,3263,7506,4695,4696,4757,4913,7521,7522,4918,4953,5106,5113,3240,5636,5638,2549,8028,5900,2908,6003,6051,2389,7370,9595,6740,7364,7020,7036,5105,7033,2657,5155,5107,2676,5145,2648,2767,7960,7963,7821,7957,7967,7866,7921,7916,7864,7925,7953,8083,8084,2463,8102,8116,8113,8115,2855,8114,6135,8407,8433,4253,2553,7904,7214,5927,7903,4954,7421,8678,8679,8680,8024,8759,8704,2704,8766,8629,8791,8792,8787,8790,8797,8836,9015,8018,8841,8843,8794,2682,3050,6079,8947,9002,9019,2391,9255,2985,2433,5956,7402,4956,4955,9426,9487,4994,2346,2503,9671,7720,2686,2687,2688,2732,5637,4606,2441,2733,7922,8376,8059,8058,2741,2725,2726,2723,5708,2731,2734,2735,2736,2737,2738,5735,7959,8057,2844,2845,2849,2850,2808,2669,5700,5702,3109,6475,6476,7908,7940,7938,7933,7936,7907,7942,8060,8095,2673,8093,8110,8100,8094,8104,8336,8788,8881,2499,9234,2513,9285,7372,2695,7385,7497,7495,5642,2278,7498,7409,6776,8040,8041,8042,2824,7699,9693,8326,7700,8324,4982,2335,7069,8065,7702,7701,8063,8432,2292,8056) ORDER BY name
SELECT min(CAST(pr.`product_price` as DECIMAL)) as min,max(CAST(pr.`product_price` as DECIMAL)) as max FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id` WHERE pr.product_publish=1 AND prc.category_id in (30,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,876,968,969,970,971,972,973,974,958,959,960,961,962,963,964,965,966,967)
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (243,246,248,245,249,250,247,252,292) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (243,246,248,245,249,250,247,252,292) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price asc LIMIT 191, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (73,74,76,77,78,79,81,82,83,84) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (73,74,76,77,78,79,81,82,83,84) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name desc LIMIT 507, 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 569, 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 desc LIMIT 1563, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (65,66,67,166,275,305,94,138,139,197,140,141,142,165,174,187,200,172,175,176,206,270,199) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (65,66,67,166,275,305,94,138,139,197,140,141,142,165,174,187,200,172,175,176,206,270,199) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name asc LIMIT 2101, 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 desc LIMIT 334, 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 1403, 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 127, 1
29 × SELECT * FROM fish_jshopping_products
19 × 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
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`
13 × 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
9 × SELECT category_id FROM fish_jshopping_categories
8 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
8 × SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
3 × SELECT * FROM fish_jshopping_categories
2 × SELECT id, `name_ru-RU` as name, field_id FROM `fish_jshopping_products_extra_field_values`
2 × SELECT 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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions`
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 id,`name_ru-RU` as name,image,color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT min(CAST(pr.`product_price` as DECIMAL)) as min,max(CAST(pr.`product_price` as DECIMAL)) as max FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id`
1 × SELECT 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 A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname FROM `fish_jshopping_attr` as A left join `fish_jshopping_attr_groups` as G on A.` group`=G.id
1 × SELECT fa.id,fa.required,fa.`name_ru-RU` AS name,fa.type FROM `fish_jshopping_free_attr` AS fa
1 × select category_id as id, `alias_ru-RU` as alias from fish_jshopping_categories
1 × select product_id as id, `alias_ru-RU` as alias from fish_jshopping_products
1 × SELECT `data` FROM `fish_session`
1 × SELECT id, image, `name_ru-RU` as name FROM `fish_jshopping_product_labels`
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 manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url from fish_jshopping_manufacturers
1 × select * from fish_jshopping_language
1 × SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image, `alias_ru-RU` as alias FROM `fish_jshopping_categories`
1 × select id,link from fish_menu
1 × SELECT id FROM fish_jshopping_vendors
1 × SELECT * FROM fish_jshopping_vendors
1 × SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.` group`, G.`name_ru-RU` as groupname, multilist FROM `fish_jshopping_products_extra_fields` as F left join `fish_jshopping_products_extra_field_groups` as G on G.id=F. group
1 × SELECT tax_id, tax_name, tax_value FROM `fish_jshopping_taxes
1 × SELECT 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 `session_id` FROM `fish_session`
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 × INSERT INTO `fish_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7530657366686430326e6d316463747534706335617334643435', 1, 1781242161, 0, '', 0
1 × UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"08ae2078290432e986cd86b573b6648d\"}'
1 × SHOW FULL COLUMNS FROM `fish_jshopping_config
1 × SHOW FULL COLUMNS FROM `fish_jshopping_currencies
1 × SHOW FULL COLUMNS FROM `fish_jshopping_categories
1 × SHOW FULL COLUMNS FROM `fish_jshopping_vendors
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products_extra_fields
1 × SHOW FULL COLUMNS FROM `fish_jshopping_taxes
1 × SHOW FULL COLUMNS FROM `fish_jshopping_users
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products_extra_field_values
1 × SHOW FULL COLUMNS FROM `fish_jshopping_product_labels
1 × SHOW FULL COLUMNS FROM `fish_jshopping_attr
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products_reviews
1 × SHOW FULL COLUMNS FROM `fish_jshopping_manufacturers
1 × SHOW FULL COLUMNS FROM `fish_jshopping_filters
