Код товара: 12291-264
.
Звоните, наши специалисты Вам помогут!
Все товары, представленные в интернет-магазине, можно приобрести в розничном магазине "Rybaki.ru".
Адрес: Москва, ул. 5-я Кабельная, д. 2, стр. 1, уровень 5 в ТРК "СпортЕХ"
График работы: ежедневно с 10:00 до 21:00
Код товара: 7510-235
Воблер RAPALA Shadow Rap Deep 11 см код цв. MBS
Код товара: 6429-019
Код товара: 11990-002
Код товара: 10134-010
Уловистая скандинавская колеблющаяся блесна, проверенная временем KUUSAMO Professor 1 115/27 (бусинка).
Код товара: 14168-153
Код товара: 13450-126
Код товара: 14285-573
Код товара: 6406-025
Судаковый виброхвост с узким телом и небольшой лопаткой.
Код товара: 9432-429
Уловистые ультралайтовые воблеры для ловли форели и другого некрупного хищника в условиях прудовых хозяйств, небольших прудов, заливов рек и озер. Небольшой размер и вес характеризуют эти приманки для ловли накоротке, с небольшой дистанцией заброса.
Код товара: 6425-059
Код товара: 14045-021
Код товара: 14325-141
Код товара: 8136-005
Виброхвост NARVAL Commander Shad 12 см код цв. #005 цв. Magic Motoroil
Код товара: 4671-004
Мимо этой уловистой приманки не пройдет ни один осторожный хищник, будь то крупная форель, щука, окунь, голавль, жерех или судак. Успешно используется при ловле спиннингом в непроточных водоемах и в реках с течением. Обладает устойчивой игрой при равномерной проводке, может применяться в качестве джиговой приманки для ловли судака и щуки.
Код товара: 14168-647
Согласен на получение рассылок и обработку персональных данных. С условиями использования сайта и положениями Политики конфиденциальности ознакомился.
Отправляя форму, даю согласие на обработку моих персональных данных. С положениями Политики конфиденциальности ознакомился.
{ "__default": { "session": { "counter": 15, "timer": { "start": 1781177732, "last": 1781177758, "now": 1781177761 }, "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": 208 }, "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=208", "product_back_value": [], "jshop_end_page_list_product": "/primanki?start=208" } }
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\":\"970b4f2d50d5605d2425398c6d8cc14a\"}' 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 208, 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 ('18293','20670','40228','18585','22850','46709','60389','49493','5465','16509','49653','80526','57790','4556','17899','47248') ORDER BY product_attr_id
SHOW FULL COLUMNS FROM `fish_jshopping_products`
SELECT * FROM fish_jshopping_products WHERE `product_id` = '18293'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=18293 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '20670'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=20670 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '40228'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=40228 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '18585'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=18585 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '22850'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=22850 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '46709'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=46709 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '60389'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=60389 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '49493'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=49493 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '5465'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=5465 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '16509'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=16509 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '49653'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=49653 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '80526'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=80526 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '57790'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=57790 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '4556'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=4556 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '17899'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=17899 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '47248'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=47248 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` = 'Балансир RAPALA Jigging Rap' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=95 ORDER BY p.product_id=18293 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 Shadow Rap Deep S' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=95 ORDER BY p.product_id=20670 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 Crystal Minnow F' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=249 ORDER BY p.product_id=40228 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=18585 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` = 'Блесна колеблющаяся KUUSAMO Professor 1 бусинка' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=269 ORDER BY p.product_id=22850 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` = 'Блесна колеблющаяся РУССКАЯ БЛЕСНА Трехгранка Сабунаева' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=178 ORDER BY p.product_id=46709 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=60389 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` = 'Блесна колеблющаяся FOREST Miu Standart' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=270 ORDER BY p.product_id=49493 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 Long John' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=125 ORDER BY p.product_id=5465 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 Noracra' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=233 ORDER BY p.product_id=16509 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` = 'Паста BERKLEY PowerBait Natural Scent Glitter Пелец' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=141 ORDER BY p.product_id=49653 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 TN/60 Trigon' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=142 ORDER BY p.product_id=80526 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` = 'Блесна колеблющаяся РУССКАЯ БЛЕСНА Strike' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=178 ORDER BY p.product_id=57790 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` = 'Виброхвост NARVAL Commander Shad' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=137 ORDER BY p.product_id=4556 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 Viper Levin' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=177 ORDER BY p.product_id=17899 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` = 'Блесна колеблющаяся NOMADIC CODE Code Baster' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=384 ORDER BY p.product_id=47248 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:02') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-11 11:36:02') 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='', prod.product_price desc LIMIT 102, 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 200, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (101,107,156,183,146,188,189,190,192,168,194,195,196) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (101,107,156,183,146,188,189,190,192,168,194,195,196) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price desc LIMIT 802, 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 832, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (65,66,67,166,275,305,94,138,139,197,140,141,142,165,174,187,200,172,175,176,206,270,199) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (65,66,67,166,275,305,94,138,139,197,140,141,142,165,174,187,200,172,175,176,206,270,199) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name desc LIMIT 498, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (21,22,41,42,46,47,63,64,88,89,91,258) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (21,22,41,42,46,47,63,64,88,89,91,258) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name desc LIMIT 264, 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 458, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (58,59,93,184,291,293) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (58,59,93,184,291,293) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', prod.product_price asc LIMIT 64, 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\":\"970b4f2d50d5605d2425398c6d8cc14a\"}'
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
