Код товара: 9467-003
Cерия блесен со специальной обработанной поверхностью. «Молотковая» поверхность блесны придает приманке очень привлекательную световую игру, мягко бликуя на солнце и не отпугивая потенциальную добычу. В зависимости от размера и веса применяется для ловли окуня, хариуса, форели, лосося, щуки и других видов рыб. Все блесны серии Hammered обладают завидными полетными характеристиками. Тяжелые варианты блесны без крючка примечательны тем, что рыболов по своему усмотрению может вооружить их любыми гармонирующими по размеру крючками, в зависимости от условий ловли. При этом рабочие качества блесны совершенно не страдают. Блесна будет работать также бесперебойно с мощным одинарником или тройником и на течении, и в стоячей воде. При ловле лососевых на каменистых реках это дает еще одно преимущество – достаточно заменить быстро тупящийся крючок на уловистой блесне, и вы снова в бою. Вам не нужно теряеть время на поиск новой приманки в ваших коробочках с блеснами. Незаменима при ловле жереха на больших дистанциях заброса.
Звоните, наши специалисты Вам помогут!
Все товары, представленные в интернет-магазине, можно приобрести в розничном магазине "Rybaki.ru".
Адрес: Москва, ул. 5-я Кабельная, д. 2, стр. 1, уровень 5 в ТРК "СпортЕХ"
График работы: ежедневно с 10:00 до 21:00
Код товара: 12069-003
.
Код товара: 11973-018
Код товара: 14322-639
Код товара: 9471-002
Код товара: 2316-207
Код товара: 15014-045
Код товара: 9440-411
Блесна T-Grovel 2.0G - это компактная блесна, изготовленная из толстого металла. Достаточно глубоко проштампована в задней части, что определяет характер её движений в воде. Эта блесна станет отличным выбором для ловли пассивных или «наколотых» хищников в реках. Приличная масса позволяет осуществлять дальние забросы, не подходя слишком близко к перспективным участкам и не пугая рыбу.
Код товара: 6407-055
Классический уловистый виброхвост от LUCKY JOHN.
Код товара: 12040-031
Код товара: 14285-981
Код товара: 14164-933
Код товара: 11872-016
Код товара: 13285-017
Код товара: 12053-054
Код товара: 14285-786
Согласен на получение рассылок и обработку персональных данных. С условиями использования сайта и положениями Политики конфиденциальности ознакомился.
Отправляя форму, даю согласие на обработку моих персональных данных. С положениями Политики конфиденциальности ознакомился.
{ "__default": { "session": { "counter": 18, "timer": { "start": 1781177732, "last": 1781177767, "now": 1781177770 }, "token": "EzHsBYPagNk1M2SXa0vXseT7ZnA1t3cW" }, "registry": { "manufacturers": "", "categorys": "", "fprice_from": "", "fprice_to": "", "extra_fields": "", "available_only": "", "sale": "", "jshoping": { "list": { "front": { "productorder": "", "productorderby": "", "productlimit": "", "product": { "cat": { "771manufacturers": "", "771categorys": "", "771fprice_from": "", "771fprice_to": "", "771extra_fields": "", "771available_only": "", "771sale": "", "771attrs": "", "125manufacturers": "", "125categorys": "", "125fprice_from": "", "125fprice_to": "", "125extra_fields": "", "125available_only": "", "125sale": "", "125attrs": "", "241manufacturers": "", "241categorys": "", "241fprice_from": "", "241fprice_to": "", "241extra_fields": "", "241available_only": "", "241sale": "", "241attrs": "", "247manufacturers": "", "247categorys": "", "247fprice_from": "", "247fprice_to": "", "247extra_fields": "", "247available_only": "", "247sale": "", "247attrs": "", "4manufacturers": "", "4categorys": "", "4fprice_from": "", "4fprice_to": "", "4extra_fields": "", "4available_only": "", "4sale": "", "4attrs": "", "98manufacturers": "", "98categorys": "", "98fprice_from": "", "98fprice_to": "", "98extra_fields": "", "98available_only": "", "98sale": "", "98attrs": "" }, "manf": { "70manufacturers": "", "70categorys": "", "70fprice_from": "", "70fprice_to": "", "70extra_fields": "", "70available_only": "", "70sale": "", "70attrs": "" } } } } }, "attrs": "", "start": 256 }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "js_id_currency_orig": "1", "js_id_currency": "1", "js_history_sel_lang": "ru-RU", "js_prev_user_id": 0, "jshop_checked_language": [ "en-GB", "ru-RU" ], "jshop_end_page_buy_product": "/primanki?start=256", "product_back_value": [], "jshop_end_page_list_product": "/primanki?start=256" } }
SELECT `data` FROM `fish_session` WHERE `session_id` = X'353836767162317534656669616666356167316769396d36756b'
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\":\"fc93fb789198aa2c600955e38875e480\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT * FROM fish_languages WHERE published=1 ORDER BY ordering ASC
SELECT id, home, template, s.params FROM fish_template_styles as s LEFT JOIN fish_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SELECT id, image, color FROM `fish_jshopping_products_extra_field_values` WHERE image !='' OR color!=''
SHOW FULL COLUMNS FROM `fish_jshopping_config`
SELECT * FROM fish_jshopping_config WHERE `id` = '1'
SHOW FULL COLUMNS FROM `fish_jshopping_currencies`
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering
SHOW FULL COLUMNS FROM `fish_jshopping_categories`
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (98)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (99,100,145,147,167,191,193,278,287,752,981)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (406,412,413,415,416,417,900,409,410,438,439,440,449,450,451)
SELECT category_id FROM fish_jshopping_categories WHERE category_parent_id IN (414)
SELECT * FROM fish_jshopping_categories WHERE `category_id` = '98'
SELECT `name_ru-RU` as name,`description_ru-RU` as description,`short_description_ru-RU` as short_description, category_id, category_publish, ordering, category_image, `alias_ru-RU` as alias FROM `fish_jshopping_categories` WHERE category_parent_id = '98' AND category_publish = '1' AND access IN (1,1,5) ORDER BY ordering asc
select id,link from fish_menu where `type`='component' and published=1 and link like '%option=com_jshopping%' and client_id=0 and (language='*' or language='ru-RU') and access IN (1,1,5)
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 99
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 100
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 145
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 147
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 167
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 191
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 193
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 278
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 287
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 752
SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id WHERE p.product_publish = 1 AND p.access IN(1,1,5) AND ptc.category_id = 981
SHOW FULL COLUMNS FROM `fish_jshopping_vendors`
SELECT id FROM fish_jshopping_vendors WHERE `main`=1
SELECT * FROM fish_jshopping_vendors WHERE `id` = '1'
SHOW FULL COLUMNS FROM `fish_jshopping_products_extra_fields`
SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.` group`, G.`name_ru-RU` as groupname, multilist FROM `fish_jshopping_products_extra_fields` as F left join `fish_jshopping_products_extra_field_groups` as G on G.id=F. group order by G.ordering, F.ordering
SHOW FULL COLUMNS FROM `fish_jshopping_taxes`
SELECT tax_id, tax_name, tax_value FROM `fish_jshopping_taxes`
SELECT COUNT(distinct prod.product_id) FROM `fish_jshopping_products_to_categories` AS pr_cat INNER JOIN `fish_jshopping_products` AS prod ON pr_cat.product_id = prod.product_id WHERE pr_cat.category_id IN (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414) AND prod.product_publish=1 AND prod.listing_product>0 AND prod.access IN (1,1,5) AND prod.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 (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414) AND prod.product_publish=1 AND prod.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.hits DESC LIMIT 256, 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 ('17877','18866','18686','57044','15320','35887','77296','17318','5563','18757','50887','38954','18248','5112','18779','50349') ORDER BY product_attr_id
SHOW FULL COLUMNS FROM `fish_jshopping_products`
SELECT * FROM fish_jshopping_products WHERE `product_id` = '17877'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=17877 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '18866'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=18866 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '18686'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=18686 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '57044'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=57044 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '15320'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=15320 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '35887'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=35887 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '77296'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=77296 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '17318'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=17318 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '5563'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=5563 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '18757'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=18757 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '50887'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=50887 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '38954'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=38954 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '18248'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=18248 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '5112'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=5112 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '18779'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=18779 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '50349'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=50349 ORDER BY product_attr_id
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Блесна колеблющаяся RIVER OLD Satellite Hammered Vespa' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=177 ORDER BY p.product_id=17877 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` = 'Мормышка вольфрамовая LUCKY JOHN Уралка с отв. Корон. и Бисер.' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=125 ORDER BY p.product_id=18866 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` = 'Мормышка вольфрамовая LUCKY JOHN Капля с отв. и кембриком' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=125 ORDER BY p.product_id=18686 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Твистер BAIT BREATH Curly Grub' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=132 ORDER BY p.product_id=57044 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` = 'Блесна колеблющаяся RIVER OLD Satellite Hammered Cherry Vespa' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=177 ORDER BY p.product_id=15320 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` = 'Блесна колеблющаяся RAPALA Minnow Spoon незацепляйка' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=95 ORDER BY p.product_id=35887 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` = 'Воблер YO-ZURI 3DS Vibe S' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=249 ORDER BY p.product_id=77296 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family` = 'Блесна колеблющаяся JACKALL TIMON T-Grovel' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=233 ORDER BY p.product_id=17318 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` = 'Виброхвост LUCKY JOHN Minnow' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=125 ORDER BY p.product_id=5563 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` = 'Мормышка вольфрамовая LUCKY JOHN Личинка с петелькой' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=125 ORDER BY p.product_id=18757 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` = 'Воблер ZIP BAITS Orbit SP-SR' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=232 ORDER BY p.product_id=50887 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` = 'Мормышка горизонтальная ТУЛА на кр. MARUTO № 2' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=74 ORDER BY p.product_id=38954 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` = 'Балансир LUCKY JOHN Classic 8 + Тр.' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=125 ORDER BY p.product_id=18248 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` = 'Насадка HAYABUSA Free Slide Fintail Short Rubber SE148' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=110 ORDER BY p.product_id=5112 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` = 'Мормышка вольфрамовая LUCKY JOHN Муравей Покраска с петелькой' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=125 ORDER BY p.product_id=18779 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` = 'Блесна колеблющаяся GOD HANDS Area Ranryu Special Color Edition' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=417 ORDER BY p.product_id=50349 DESC, `name_ru-RU` ASC
SELECT distinct man.manufacturer_id as id, man.`name_ru-RU` as name, man.`alias_ru-RU` as alias, manufacturer_logo FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `fish_jshopping_manufacturers` as man on prod.product_manufacturer_id=man.manufacturer_id WHERE categ.category_id IN (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414) AND prod.product_publish=1 AND prod.product_manufacturer_id!=0 AND prod.access IN (1,1,5) order by name
SHOW FULL COLUMNS FROM `fish_jshopping_products_reviews`
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-11 11:36:11') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-11 11:36:11') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 128 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SHOW FULL COLUMNS FROM `fish_jshopping_filters`
SELECT filter.* FROM `fish_jshopping_filters` AS `filter` INNER JOIN `fish_jshopping_filter2menu` AS `fm` ON fm.filter_id=filter.filter_id WHERE filter.filter_publish=1 AND fm.menuitem_id=128 ORDER BY filter.filter_ordering
SELECT 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 (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414) AND 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 (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414) AND 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 (2996,2326,2325,2817,2999,2994,2881,3289,2877,2879,2742,3002,3290,2880,2882,2884,3001,2997,2689,3013,3014,2885,3020,2237,3021,2709,2415,2475,2711,2416,2707,2714,3036,2361,3037,2708,2851,2285,2267,2287,2362,2270,2276,2829,2830,2271,2371,2372,2277,2269,2472,2710,4755,2327,2278,2283,2284,2286,2364,2365,2366,2367,2368,2369,2370,2373,3038,2827,2756,2722,3285,2587,2862,3007,2828,3006,3237,3238,2607,4270,2765,3010,7367,4707,2294,4747,2321,4951,4965,3027,6032,7008,3059,7837,7861,8005,3015,8148,8161,8785,9515) ORDER BY name
SELECT min(CAST(`pr`.`extra_field_25` as DECIMAL(10,1))) as min,max(CAST(`pr`.`extra_field_25` as DECIMAL(10,1))) as max FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id` WHERE pr.product_publish=1 AND prc.category_id in (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414)
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 (98,99,100,145,147,167,191,193,278,287,752,981,101,107,183,146,188,189,190,192,336,339,340,341,342,343,344,345,346,348,351,352,353,636,148,204,205,306,168,169,170,253,459,460,461,478,479,480,481,482,483,484,485,489,490,491,494,495,497,502,503,506,507,508,509,512,560,894,896,194,195,196,754,757,758,759,760,761,762,763,764,766,767,768,769,399,400,401,402,403,404,405,407,408,411,446,499,500,501,893,505,487,488,496,510,442,443,899,437,448,426,427,428,429,434,436,514,454,455,898,457,347,349,350,493,492,895,511,513,637,755,756,897,765,406,412,413,415,416,417,900,409,410,438,439,440,449,450,451,414)
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (243,246,248,245,249,250,247,252,292) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (243,246,248,245,249,250,247,252,292) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name desc LIMIT 220, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (73,74,76,77,78,79,81,82,83,84) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (73,74,76,77,78,79,81,82,83,84) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price desc LIMIT 495, 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='', name asc LIMIT 701, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (102,103,104,106,124,136,171,177,105,108,198,269,273,277,125,126,133,135,137,161,180,182,144,307,178,304) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (102,103,104,106,124,136,171,177,105,108,198,269,273,277,125,126,133,135,137,161,180,182,144,307,178,304) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name asc LIMIT 71, 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 1001, 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='', prod.product_price asc LIMIT 314, 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 2127, 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='', name asc LIMIT 55, 1
18 × SELECT category_id FROM fish_jshopping_categories
17 × SELECT * FROM `fish_jshopping_products_attr`
16 × SELECT * FROM fish_jshopping_products
16 × SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p`
11 × SELECT COUNT(ptc.product_id) FROM fish_jshopping_products_to_categories AS ptc LEFT JOIN fish_jshopping_products AS p ON p.product_id = ptc.product_id
8 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions`
2 × SELECT distinct man.manufacturer_id as id, man.`name_ru-RU` as name, man.`alias_ru-RU` as alias, manufacturer_logo FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `fish_jshopping_manufacturers` as man on prod.product_manufacturer_id=man.manufacturer_id
1 × select manufacturer_id as id, `alias_ru-RU` as alias from fish_jshopping_manufacturers
1 × select product_id as id, `alias_ru-RU` as alias from fish_jshopping_products
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 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 extension_id FROM fish_extensions
1 × SELECT id,`name_ru-RU` as name,image,color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT min(CAST(`pr`.`extra_field_25` as DECIMAL(10,1))) as min,max(CAST(`pr`.`extra_field_25` as DECIMAL(10,1))) as max FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id`
1 × SELECT min(CAST(pr.`product_price` as DECIMAL)) as min,max(CAST(pr.`product_price` as DECIMAL)) as max FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_products_to_categories` AS `prc` ON `prc`.`product_id`=`pr`.`product_id`
1 × SELECT filter.* FROM `fish_jshopping_filters` AS `filter` INNER JOIN `fish_jshopping_filter2menu` AS `fm` ON fm.filter_id=filter.filter_id
1 × SELECT A.attr_id, A.`name_ru-RU` as name, A.`description_ru-RU` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_ru-RU` as groupname FROM `fish_jshopping_attr` as A left join `fish_jshopping_attr_groups` as G on A.` group`=G.id
1 × SELECT 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 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 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 `data` FROM `fish_session`
1 × SELECT id, image, `name_ru-RU` as name FROM `fish_jshopping_product_labels`
1 × SELECT id, image, color FROM `fish_jshopping_products_extra_field_values`
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 * FROM fish_jshopping_config
1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id)
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies`
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 manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url from fish_jshopping_manufacturers
1 × UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"fc93fb789198aa2c600955e38875e480\"}'
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
