Код товара: 10734
Ботинки Горные AKU Conero GTX NBK. Превосходные кожаные ботинки для любителей треккинга изготовлены из отборного нубука, оснащены мембраной Gore-Tex, которая прекрасно дышит, совершенно не промокает и отводит испарения от ноги. В местах наибольших изгибов и напряжений ботинки усилены специальными гибкими вставками. Особый рисунок протектора не даст ноге соскользнуть даже с мокрых камней.
Звоните, наши специалисты Вам помогут!
Все товары, представленные в интернет-магазине, можно приобрести в розничном магазине "Rybaki.ru".
Адрес: Москва, ул. 5-я Кабельная, д. 2, стр. 1, уровень 5 в ТРК "СпортЕХ"
График работы: ежедневно с 10:00 до 21:00
Код товара: 2775
Укороченная версия обновленных ботинок Jager. Подходят для активного использования во влажных и холодных условиях. Предназначены для охоты засчет использования водонепроницаемой и дышащей мембраны Gore-Tex.
Код товара: 9449
Эксклюзивная модель, предназначенная для сухого и жаркого климата, обеспечивает высокую воздухопроницаемость и быстрое высыхание. Материал Air 8000 в 11 раз лучше дышит, чем традиционные синтетические материалы.
Код товара: 2774
Высокие ботинки из зернистой натуральной кожи высочайшего качества для применения во влажных и холодных условиях.
Код товара: 4635
Зимняя версия исторический ботинок AKU для продолжительных пеших прогулок. Обеспечат чрезвычайный уровень удобства посадки, легкость и воздухопроницаемость. Идеально подходит для однодневных походов зимой, на рельефе средней сложности, а также для каждодневной носки.
Код товара: 9223
Превосходные стельки для использования в холодную погоду и особенно зимний период. Точно рассчитанная ортопедическая форма изделя держит стопуноги в правильном положении в обуви, не давая её свободно смещаться. Отличный влаго и теплообмен всегда сохранит ваши ноги в тепле.
Код товара: 2759
Грамотно подобранное сочетание натуральных и синтетических материалов, которые применяются в этой модели, предоставляют вам непревзойденный комфорт в любых условиях, особенно в зимнюю пору. Отличный выбор для охотников и рыболов, туристов и всех тех, кто ценит тепло и комфорт.
Код товара: 9224
Код товара: 15199
Код товара: 2760
Код товара: 15268
Стельки AKU Custom Fit IMS специально разработаны с учетом ортопедических особенностей строения ступни.
Код товара: 1594
Прочные и многофункциональные ботинки для несложных туристических маршрутов по холмам и невысоким горам. Верх из отборной кожи, которая дополнительно пропитана водоотталкивающим составом.
Код товара: 9225
Высокие теплые носки, которые удобно поддевать под сапоги или высокие ботинки. По большей части изготовленные из чистой шерсти, имеют добавки лайкры и полиамида. Эти материалы придают носкам эластичность, прочность, плотное облегание ноги. Внутренняя поверхность имеет ворсистую структуру для увеличения теплосбережения и комфорта. Используя их ваши ноги всегда останутся в тепле и сухости, и даже многокилометровые походы покажутся в них обычной городской прогулкой.
Код товара: 2762
Носки средней длины AKU Backpacking Low отличаются высокой прочностью материалов и удобством ношения при длительных походах и восхождениях в горы. Подойдут как туристам, там и охотниками и рыболовам, которые много передвигаются.
Код товара: 9220
Запасные стельки AKU Custom Fit Pro являются высокотехнологичной трёхслойной системой комфорта для вашей стопы. Центральная жесткая часть стельки выполняет функцию супинатора. Изготовленная из материала EVA, она четко сохраняет форму стопы даже при постоянной носке в течение многих лет, не давая ногам уставать.
Код товара: 2761
Согласен на получение рассылок и обработку персональных данных. С условиями использования сайта и положениями Политики конфиденциальности ознакомился.
Отправляя форму, даю согласие на обработку моих персональных данных. С положениями Политики конфиденциальности ознакомился.
{ "__default": { "session": { "counter": 19, "timer": { "start": 1781029079, "last": 1781029117, "now": 1781029118 }, "token": "Mz2sNOyD7RGGdp2OnxAdbcnRmFNsMxOW" }, "registry": { "jshoping": { "list": { "front": { "product": { "manf": { "469manufacturers": "", "469categorys": "", "469fprice_from": "", "469fprice_to": "", "469extra_fields": "", "469available_only": "", "469sale": "", "469attrs": "", "259manufacturers": "", "259categorys": "", "259fprice_from": "", "259fprice_to": "", "259extra_fields": "", "259available_only": "", "259sale": "", "259attrs": "", "642manufacturers": "", "642categorys": "", "642fprice_from": "", "642fprice_to": "", "642extra_fields": "", "642available_only": "", "642sale": "", "642attrs": "", "759manufacturers": "", "759categorys": "", "759fprice_from": "", "759fprice_to": "", "759extra_fields": "", "759available_only": "", "759sale": "", "759attrs": "", "86manufacturers": "", "86categorys": "", "86fprice_from": "", "86fprice_to": "", "86extra_fields": "", "86available_only": "", "86sale": "", "86attrs": "", "544manufacturers": "", "544categorys": "", "544fprice_from": "", "544fprice_to": "", "544extra_fields": "", "544available_only": "", "544sale": "", "544attrs": "", "73manufacturers": "", "73categorys": "", "73fprice_from": "", "73fprice_to": "", "73extra_fields": "", "73available_only": "", "73sale": "", "73attrs": "", "770manufacturers": "", "770categorys": "", "770fprice_from": "", "770fprice_to": "", "770extra_fields": "", "770available_only": "", "770sale": "", "770attrs": "", "244manufacturers": "", "244categorys": "", "244fprice_from": "", "244fprice_to": "", "244extra_fields": "", "244available_only": "", "244sale": "", "244attrs": "", "255manufacturers": "", "255categorys": "", "255fprice_from": "", "255fprice_to": "", "255extra_fields": "", "255available_only": "", "255sale": "", "255attrs": "", "82manufacturers": "", "82categorys": "", "82fprice_from": "", "82fprice_to": "", "82extra_fields": "", "82available_only": "", "82sale": "", "82attrs": "", "271manufacturers": "", "271categorys": "", "271fprice_from": "", "271fprice_to": "", "271extra_fields": "", "271available_only": "", "271sale": "", "271attrs": "", "185manufacturers": "", "185categorys": "", "185fprice_from": "", "185fprice_to": "", "185extra_fields": "", "185available_only": "", "185sale": "", "185attrs": "", "12manufacturers": "", "12categorys": "", "12fprice_from": "", "12fprice_to": "", "12extra_fields": "", "12available_only": "", "12sale": "", "12attrs": "" }, "cat": { "4manufacturers": "", "4categorys": "", "4fprice_from": "", "4fprice_to": "", "4extra_fields": "", "4available_only": "", "4sale": "", "4attrs": "", "65manufacturers": "", "65categorys": "", "65fprice_from": "", "65fprice_to": "", "65extra_fields": "", "65available_only": "", "65sale": "", "65attrs": "", "21manufacturers": "", "21categorys": "", "21fprice_from": "", "21fprice_to": "", "21extra_fields": "", "21available_only": "", "21sale": "", "21attrs": "" } }, "productorder": "", "productorderby": "", "productlimit": "" } } } }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "js_id_currency_orig": "1", "js_id_currency": "1", "js_history_sel_lang": "ru-RU", "js_prev_user_id": 0, "jshop_checked_language": [ "en-GB", "ru-RU" ], "jshop_end_page_buy_product": "/brands/aku", "jshop_end_page_list_product": "/brands/aku" } }
SELECT `data` FROM `fish_session` WHERE `session_id` = X'393562703733756432376e6a726739726e6e6d713967326f3961'
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\":\"b3c8fa1b842ea1cab79a3b3b98e8fbd6\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT id, image, color FROM `fish_jshopping_products_extra_field_values` WHERE image !='' OR color!=''
SHOW FULL COLUMNS FROM `fish_jshopping_config`
SELECT * FROM fish_jshopping_config WHERE `id` = '1'
SHOW FULL COLUMNS FROM `fish_jshopping_currencies`
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering
SELECT product_publish, product_id, `name_ru-RU` as name, `alias_ru-RU` as alias, alias_family, family FROM fish_jshopping_products WHERE (alias_family='aku' OR `alias_ru-RU`='aku') AND product_price>0 ORDER BY product_publish DESC, product_quantity DESC, product_price ASC
select category_id as id, `alias_ru-RU` as alias from fish_jshopping_categories where `alias_ru-RU`!=''
select manufacturer_id as id, `alias_ru-RU` as alias from fish_jshopping_manufacturers where `alias_ru-RU`!=''
SELECT * FROM fish_languages WHERE published=1 ORDER BY ordering ASC
SELECT id, home, template, s.params FROM fish_template_styles as s LEFT JOIN fish_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SHOW FULL COLUMNS FROM `fish_jshopping_manufacturers`
SELECT * FROM fish_jshopping_manufacturers WHERE `manufacturer_id` = '12'
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)
SHOW FULL COLUMNS FROM `fish_jshopping_vendors`
SELECT id FROM fish_jshopping_vendors WHERE `main`=1
SELECT * FROM fish_jshopping_vendors WHERE `id` = '1'
SHOW FULL COLUMNS FROM `fish_jshopping_products_extra_fields`
SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.` group`, G.`name_ru-RU` as groupname, multilist FROM `fish_jshopping_products_extra_fields` as F left join `fish_jshopping_products_extra_field_groups` as G on G.id=F. group order by G.ordering, F.ordering
SHOW FULL COLUMNS FROM `fish_jshopping_taxes`
SELECT tax_id, tax_name, tax_value FROM `fish_jshopping_taxes`
SELECT COUNT(distinct prod.product_id) FROM `fish_jshopping_products` as prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_manufacturer_id=12 AND prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT p.product_id, x.category_id, p.`name_ru-RU` as name, p.`short_description_ru-RU` as short_description, p.product_ean, p.manufacturer_code, p.image, p.product_price, p.currency_id, p.product_tax_id as tax_id, p.product_old_price, p.product_weight, p.average_rating, p.reviews_count, p.hits, p.weight_volume_units, p.basic_price_unit_id, p.label_id, p.product_manufacturer_id, p.min_price, MAX(p.product_quantity) as product_quantity, p.different_prices, p.`alias_ru-RU` as alias, p.sales, p.alias_family, p.family_seo, p.family, p.product_template FROM (SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, MAX(prod.product_quantity) as product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_manufacturer_id=12 AND prod.product_publish=1 AND cat.category_publish=1 AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) GROUP BY prod.family ) as x INNER JOIN fish_jshopping_products p ON p.family=x.family AND p.product_quantity=x.product_quantity WHERE p.product_publish=1 GROUP BY p.family ORDER BY MAX(p.product_quantity=0), p.image='', p.hits DESC LIMIT 0, 16
SHOW FULL COLUMNS FROM `fish_jshopping_users`
select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url from fish_jshopping_manufacturers where manufacturer_publish='1'
SHOW FULL COLUMNS FROM `fish_jshopping_products_extra_field_values`
SELECT id, `name_ru-RU` as name, field_id FROM `fish_jshopping_products_extra_field_values` order by ordering
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 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 ('26629','26857','26862','26856','43399','26997','27581','43621','50594','43620','26993','26873','27578','43617','26994','27571') 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 ('26629','26857','26862','26856','43399','26997','27581','43621','50594','43620','26993','26873','27578','43617','26994','27571') ORDER BY av.value_ordering ASC
SHOW FULL COLUMNS FROM `fish_jshopping_products`
SELECT * FROM fish_jshopping_products WHERE `product_id` = '26629'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '26857'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '26862'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '26856'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '43399'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '26997'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '27581'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '43621'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '50594'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '43620'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '26993'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '26873'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '27578'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '43617'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '26994'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '27571'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=26629 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=26629 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=26857 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=26857 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=26862 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=26862 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=26856 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=26856 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=43399 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=43399 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=26997 ORDER BY product_attr_id
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price FROM `fish_jshopping_products_attr` as PA INNER JOIN fish_jshopping_attr_values as V ON PA.attr_1=V.value_id WHERE PA.product_id=26997 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=27581 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=27581 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=43621 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=43621 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=50594 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=50594 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=43620 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=43620 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=26993 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=26993 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=26873 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=26873 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=27578 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=27578 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=43617 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=43617 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=26994 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=26994 ORDER BY V.value_ordering
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=27571 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=27571 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` = 'Conero GTX NBK' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=26629 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` = 'Jager Evo Low GTX' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=26857 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` = 'Pilgrim DS' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=26862 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` = 'Jager Evo High GTX' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=26856 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` = 'Slope Max Suede GTX' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=43399 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family_seo` = 'Thermoform' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=26997 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family_seo` = 'Hiking Low Socks' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=27581 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` = 'Hiking Low Socks' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=43621 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` = 'Pilgrim GTX Combat FG M' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=50594 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` = 'Hiking Low Socks' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=43620 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` = 'Custom Fit IMS' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=26993 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` = 'Tribute II GTX MS' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=26873 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` = 'Forester Socks' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=27578 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` = 'Backpacking Low' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=43617 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` = 'Custom Fit Pro' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=26994 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` = 'Backpacking Low' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=12 ORDER BY p.product_id=27571 DESC, `name_ru-RU` ASC
SELECT distinct cat.category_id as id, cat.`name_ru-RU` as name FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `fish_jshopping_categories` as cat on cat.category_id=categ.category_id WHERE prod.product_publish=1 AND prod.product_manufacturer_id=12 AND cat.category_publish=1 AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) order by name
SHOW FULL COLUMNS FROM `fish_jshopping_products_reviews`
SELECT `name_ru-RU` as name,`description_ru-RU` as descr,manufacturer_logo,`short_description_ru-RU` as short_descr FROM `fish_jshopping_manufacturers` WHERE manufacturer_id=12
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 18:18:39') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-09 18:18:39') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 137 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=137 ORDER BY filter.filter_ordering
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 (842,22,845,844,843,63,41,47,67,42,64,91,89,54,46,258) AND pr.product_manufacturer_id in (12) 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 (2398,2382,2487,2632,2825,2400,2578,9635,5893,2414,7184,9701) 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 (842,22,845,844,843,63,41,47,67,42,64,91,89,54,46,258) AND pr.product_manufacturer_id in (12)
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (243,246,248,245,249,250,247,252,292) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (243,246,248,245,249,250,247,252,292) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price asc LIMIT 57, 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`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (73,74,76,77,78,79,81,82,83,84) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name asc LIMIT 564, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (101,107,156,183,146,188,189,190,192,168,194,195,196) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (101,107,156,183,146,188,189,190,192,168,194,195,196) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price desc LIMIT 612, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (102,103,104,106,124,136,171,177,105,108,198,269,273,277,125,126,133,135,137,161,180,182,144,307,178,304) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (102,103,104,106,124,136,171,177,105,108,198,269,273,277,125,126,133,135,137,161,180,182,144,307,178,304) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name desc LIMIT 1643, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (65,66,67,166,275,305,94,138,139,197,140,141,142,165,174,187,200,172,175,176,206,270,199) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (65,66,67,166,275,305,94,138,139,197,140,141,142,165,174,187,200,172,175,176,206,270,199) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price desc LIMIT 436, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (21,22,41,42,46,47,63,64,88,89,91,258) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (21,22,41,42,46,47,63,64,88,89,91,258) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name desc LIMIT 31, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,34,109,159,160,179,181,185,36,48,49,68,71,92,255,295) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (29,30,32,33,35,31,54,57,70,97,110,186,201,202,203,208,290,296,297,298,299,300,301,302,34,109,159,160,179,181,185,36,48,49,68,71,92,255,295) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name asc LIMIT 705, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (58,59,93,184,291,293) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (58,59,93,184,291,293) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name desc LIMIT 144, 1
32 × SELECT * FROM fish_jshopping_products
17 × SELECT * FROM `fish_jshopping_products_attr`
16 × SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p`
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
8 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
8 × SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
2 × SELECT id, `name_ru-RU` as name, field_id FROM `fish_jshopping_products_extra_field_values`
2 × SELECT * FROM fish_jshopping_manufacturers
2 × SELECT distinct cat.category_id as id, cat.`name_ru-RU` as name FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `fish_jshopping_categories` as cat on cat.category_id=categ.category_id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions`
1 × SELECT id, image, `name_ru-RU` as name FROM `fish_jshopping_product_labels`
1 × select product_id as id, `alias_ru-RU` as alias from fish_jshopping_products
1 × SELECT fa.id,fa.required,fa.`name_ru-RU` AS name,fa.type FROM `fish_jshopping_free_attr` AS fa
1 × SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname FROM `fish_jshopping_attr` as A left join `fish_jshopping_attr_groups` as G on A.` group`=G.id
1 × SELECT 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 extension_id FROM fish_extensions
1 × SELECT id,`name_ru-RU` as name,image,color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT `name_ru-RU` as name,`description_ru-RU` as descr,manufacturer_logo,`short_description_ru-RU` as short_descr FROM `fish_jshopping_manufacturers`
1 × SELECT 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 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 product_publish, product_id, `name_ru-RU` as name, `alias_ru-RU` as alias, alias_family, family FROM fish_jshopping_products
1 × SELECT id, rules FROM `fish_viewlevels
1 × SELECT b.id FROM fish_usergroups AS a LEFT JOIN fish_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM fish_extensions
1 × SELECT `params` FROM `fish_extensions`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM fish_menu AS m LEFT JOIN fish_extensions AS e ON m.component_id = e.extension_id
1 × SELECT id, image, color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT * FROM fish_jshopping_config
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies`
1 × select category_id as id, `alias_ru-RU` as alias from fish_jshopping_categories
1 × SELECT COUNT(distinct prod.product_id) FROM `fish_jshopping_products` as prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
1 × select manufacturer_id as id, `alias_ru-RU` as alias from fish_jshopping_manufacturers
1 × SELECT * FROM fish_languages
1 × SELECT id, home, template, s.params FROM fish_template_styles as s LEFT JOIN fish_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × select 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 p.product_id, x.category_id, p.`name_ru-RU` as name, p.`short_description_ru-RU` as short_description, p.product_ean, p.manufacturer_code, p.image, p.product_price, p.currency_id, p.product_tax_id as tax_id, p.product_old_price, p.product_weight, p.average_rating, p.reviews_count, p.hits, p.weight_volume_units, p.basic_price_unit_id, p.label_id, p.product_manufacturer_id, p.min_price, MAX(p.product_quantity) as product_quantity, p.different_prices, p.`alias_ru-RU` as alias, p.sales, p.alias_family, p.family_seo, p.family, p.product_template FROM (SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, MAX(prod.product_quantity) as product_quantity, prod.different_prices, `prod`.`alias_ru-RU` as alias, prod.sales, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
1 × UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"b3c8fa1b842ea1cab79a3b3b98e8fbd6\"}'
1 × SHOW FULL COLUMNS FROM `fish_jshopping_config
1 × SHOW FULL COLUMNS FROM `fish_jshopping_currencies
1 × SHOW FULL COLUMNS FROM `fish_jshopping_manufacturers
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_filters
