Код товара: 15116-992
Звоните, наши специалисты Вам помогут!
Все товары, представленные в интернет-магазине, можно приобрести в розничном магазине "Rybaki.ru".
Адрес: Москва, ул. 5-я Кабельная, д. 2, стр. 1, уровень 5 в ТРК "СпортЕХ"
График работы: ежедневно с 10:00 до 21:00
Код товара: 14325-715
Код товара: 6840-114
Джиг-Головка HAYABUSA EX926 "Brush easy" 1,4 гр, черный никель, кр. Незацепляйка № 2 (4 шт.)
Код товара: 15114-229
Код товара: 6311-401
Популярный классический объемный виброхвост KEITECH.
Код товара: 15114-230
Код товара: 9709-238
Воблер LUCKY CRAFT Pointer 100 SR 18 гр. цв. Ghost Monnow
Код товара: 6025-223
Классический воблер класса минноу с повышенной плавучестью.
Код товара: 5482-662
Запасной комель для спиннинга Provokator New 662L
Код товара: 14325-747
Код товара: 13512-400
Код товара: 14325-827
Код товара: 15361
Код товара: 14105-007
Код товара: 14840
Код товара: 5011-016
Согласен на получение рассылок и обработку персональных данных. С условиями использования сайта и положениями Политики конфиденциальности ознакомился.
Отправляя форму, даю согласие на обработку моих персональных данных. С положениями Политики конфиденциальности ознакомился.
{ "__default": { "session": { "counter": 6, "timer": { "start": 1781522438, "last": 1781522449, "now": 1781522450 }, "token": "ZbbPx6XxlZbhgG2Yf1adRTwLiZCUYIyG" }, "registry": { "jshoping": { "list": { "front": { "product": { "cat": { "140manufacturers": "", "140categorys": "", "140fprice_from": "", "140fprice_to": "", "140extra_fields": "", "140available_only": "", "140sale": "", "140attrs": "", "102manufacturers": "", "102categorys": "", "102fprice_from": "", "102fprice_to": "", "102extra_fields": "", "102available_only": "", "102sale": "", "102attrs": "" }, "fulllist": { "2manufacturers": "", "2categorys": "", "2fprice_from": "", "2fprice_to": "", "2extra_fields": "", "2available_only": "", "2sale": "", "2attrs": "" }, "manf": { "121manufacturers": "", "121categorys": "", "121fprice_from": "", "121fprice_to": "", "121extra_fields": "", "121available_only": "", "121sale": "", "121attrs": "", "246manufacturers": "", "246categorys": "", "246fprice_from": "", "246fprice_to": "", "246extra_fields": "", "246available_only": "", "246sale": "", "246attrs": "" } }, "productorder": "", "productorderby": "", "productlimit": "" } } }, "start": 368 }, "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": "/rasprodazha?start=368", "jshop_end_page_list_product": "/rasprodazha?start=368" } }
SELECT `data` FROM `fish_session` WHERE `session_id` = X'616a35343632626b66623067373975376a6d3861393131347371'
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\":\"01b298eb94aa86ffbd078f0299a196d4\"}' 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_products`
SHOW FULL COLUMNS FROM `fish_jshopping_config_seo`
SELECT id, alias, `title_ru-RU` as title, `keyword_ru-RU` as keyword, `description_ru-RU` as description FROM `fish_jshopping_config_seo` where alias='all-products'
SHOW FULL COLUMNS FROM `fish_jshopping_vendors`
SELECT id FROM fish_jshopping_vendors WHERE `main`=1
SELECT * FROM fish_jshopping_vendors WHERE `id` = '1'
SHOW FULL COLUMNS FROM `fish_jshopping_products_extra_fields`
SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.` group`, G.`name_ru-RU` as groupname, multilist FROM `fish_jshopping_products_extra_fields` as F left join `fish_jshopping_products_extra_field_groups` as G on G.id=F. group order by G.ordering, F.ordering
SHOW FULL COLUMNS FROM `fish_jshopping_taxes`
SELECT tax_id, tax_name, tax_value FROM `fish_jshopping_taxes`
SELECT COUNT(distinct prod.product_id) FROM `fish_jshopping_products` as prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.label_id in (2) AND prod.listing_product >0
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 p.product_id, x.category_id, p.`name_ru-RU` as name, p.`short_description_ru-RU` as short_description, p.product_ean, p.manufacturer_code, p.image, p.product_price, p.currency_id, p.product_tax_id as tax_id, p.product_old_price, p.product_weight, p.average_rating, p.reviews_count, p.hits, p.weight_volume_units, p.basic_price_unit_id, p.label_id, p.product_manufacturer_id, p.min_price, MAX(p.product_quantity) as product_quantity, p.different_prices, p.sales, p.`alias_ru-RU` as alias, p.alias_family, p.family_seo, p.family, p.product_template FROM (SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, MAX(prod.product_quantity) as product_quantity, prod.different_prices, prod.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) 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.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.label_id in (2) GROUP BY prod.family ) as x INNER JOIN fish_jshopping_products p ON p.family=x.family AND p.product_quantity=x.product_quantity WHERE p.product_publish=1 GROUP BY p.family ORDER BY MAX(p.product_quantity=0), p.image='', p.hits DESC LIMIT 368, 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 ('85675','58227','24295','85172','4772','85173','20254','17983','11742','58182','60190','58117','87239','26670','74404','59019') ORDER BY product_attr_id
SELECT pa.product_id,pa.count,av.attr_id, pa.attr_1 ,av.`name_ru-RU` as value_name,av.image FROM fish_jshopping_products_attr AS pa LEFT JOIN fish_jshopping_attr_values AS av ON pa.attr_1=av.value_id WHERE pa.product_id IN ('85675','58227','24295','85172','4772','85173','20254','17983','11742','58182','60190','58117','87239','26670','74404','59019') ORDER BY av.value_ordering ASC
SELECT * FROM fish_jshopping_products WHERE `product_id` = '87239'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '74404'
SELECT * FROM fish_jshopping_products WHERE `product_id` = '85675'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=85675 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '58227'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=58227 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '24295'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=24295 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '85172'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=85172 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '4772'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=4772 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '85173'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=85173 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '20254'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=20254 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '17983'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=17983 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '11742'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=11742 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '58182'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=58182 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '60190'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=60190 ORDER BY product_attr_id
SELECT * FROM fish_jshopping_products WHERE `product_id` = '58117'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=58117 ORDER BY product_attr_id
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=87239 ORDER BY product_attr_id
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price FROM `fish_jshopping_products_attr` as PA INNER JOIN fish_jshopping_attr_values as V ON PA.attr_1=V.value_id WHERE PA.product_id=87239 ORDER BY V.value_ordering
SELECT * FROM fish_jshopping_products WHERE `product_id` = '26670'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=26670 ORDER BY product_attr_id
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=74404 ORDER BY product_attr_id
SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price FROM `fish_jshopping_products_attr` as PA INNER JOIN fish_jshopping_attr_values as V ON PA.attr_1=V.value_id WHERE PA.product_id=74404 ORDER BY V.value_ordering
SELECT * FROM fish_jshopping_products WHERE `product_id` = '59019'
SELECT * FROM `fish_jshopping_products_attr` WHERE product_id=59019 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` = 'Мультитул LEATHERMAN Curl цв. Металлик, чехол нейлон' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=97 ORDER BY p.product_id=85675 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` = 'Оснастка KOTA Фидер-Канал № 7 вес 28 г' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=449 ORDER BY p.product_id=58227 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 EX926 кр. № 2' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=110 ORDER BY p.product_id=24295 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` = 'Мультитул СЛЕДОПЫТ PF-MT-06 малый, (9 предметов)' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=334 ORDER BY p.product_id=85172 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` = 'Виброхвост KEITECH Easy Shiner' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=138 ORDER BY p.product_id=4772 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` = 'Мультитул СЛЕДОПЫТ PF-MT-07 средний, (9 предметов)' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=334 ORDER BY p.product_id=85173 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 CRAFT Pointer SP' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=234 ORDER BY p.product_id=20254 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` = 'Воблер MEGABASS Vision Oneten F' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=228 ORDER BY p.product_id=17983 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` = 'Комель NORSTREAM Provokator New' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=121 ORDER BY p.product_id=11742 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` = 'Оснастка KOTA жереховая-шайба № 20 55 г' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=449 ORDER BY p.product_id=58182 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` = 'Джиг-Головка MIKADO Aberdeen BN кр.№ 4/0' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=77 ORDER BY p.product_id=60190 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` = 'Поводок флюорокарбоновый ZETTECH с пружиной, 100% Fluoro (3 шт.)' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=445 ORDER BY p.product_id=58117 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family_seo` = '309 Trail Lite GTX' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=505 ORDER BY p.product_id=87239 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 Pro Series Spanky Worm' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=125 ORDER BY p.product_id=26670 DESC, `name_ru-RU` ASC
SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p` WHERE `p`.`family_seo` = 'Varmland Vest' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=543 ORDER BY p.product_id=74404 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` = 'Крючок одинарный GAMAKATSU G-Method Allr' AND `p`.`product_publish` =1 AND `p`.`product_manufacturer_id`=106 ORDER BY p.product_id=59019 DESC, `name_ru-RU` ASC
SHOW FULL COLUMNS FROM `fish_jshopping_manufacturers`
SELECT `alias_ru-RU` as alias, 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 name asc
SHOW FULL COLUMNS FROM `fish_jshopping_categories`
SELECT `name_ru-RU` as name, category_id, category_parent_id, category_publish FROM `fish_jshopping_categories` where category_publish = '1' and access IN (1,1,5) ORDER BY category_parent_id, ordering
SHOW FULL COLUMNS FROM `fish_jshopping_products_reviews`
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-15 11:20:51') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-15 11:20:51') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 327 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=327 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_manufacturers` AS `man` ON pr.product_manufacturer_id=man.manufacturer_id WHERE pr.product_publish=1 AND pr.label_id=2 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` WHERE pr.product_publish=1 AND pr.label_id=2 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 (2313,2247,2251,7355,2423,2310,2356,2390,2571,2354,2817,2325,2326,2881,2994,3290,2879,2880,2877,2999,2622,3014,2352,2995,2613,3286,2383,2318,2813,2814,2323,2359,7008,2689,2761,2749,2746,7347,7346,2302,2402,3065,2838,2583,2588,2637,7350,2358,2742,2754,2751,2417,2579,2424,2792,2471,2332,2280,2304,2415,2237,2707,3036,2902,2832,2705,7365,3172,7362,7177,7185,2911,2382,2453,2632,2763,3018,2483,2478,2825,2249,2327,2330,2859,2816,2664,2582,2658,2665,2291,2349,2289,2419,2454,2469,2470,2572,7476,2506,2517,2518,2567,2629,7368,2441,3025,8121,2642,2695,2704,2301,2753,3038,2250,2425,2260,2384,2587,8085,2730,2829,2385,2389,2303,2392,7348,2388,2487,3006,2687,2525,3087,3193,2387,2434,2299,2718,3294,2339,4250,2946,2863,4270,6108,4307,4306,2400,2786,4747,3289,4757,2738,2726,2725,2942,2969,4855,2395,7398,2337,7517,7522,4893,4972,4976,2492,2481,2239,2258,2345,2259,2673,3240,4707,2708,2765,2669,7372,7498,5676,5700,2845,4789,5708,2633,5735,2736,2771,2591,2416,2256,2341,2987,2321,2578,2808,8026,3242,3020,7323,2908,6397,4415,9595,3109,2847,6476,2733,9635,2398,5893,7409,6776,2635,2769,2920,3248,7353,2939,2445,7157,5152,7162,3267,2854,7247,7109,2899,5107,7171,9318,7172,7167,7179,3069,7158,2778,2784,7153,7147,7166,2931,7240,4779,7174,2780,7719,7963,2719,2803,7940,2552,7933,7907,2723,7942,7948,7837,2862,2884,4880,7154,7929,7922,2731,7959,8040,8041,8042,8060,8127,8084,2463,8102,8115,2855,8095,8093,8110,3263,8104,2376,7699,5145,2414,8376,8341,2706,2252,6032,7160,8120,7251,9205,6446,7408,7152,2840,7252,5719,7169,2409,8225,2255,3059,2900,2734,8681,8678,8679,8680,8669,8676,2501,8682,2503,8683,7020,2767,2802,7033,8793,8794,8028,2676,8788,8647,7175,2682,8881,5105,9234,2513,2437,7063,7014,7066,2648,2790,7434,8126,5155,2562,9693,6740) ORDER BY name
SELECT min(CAST(pr.`product_price` as DECIMAL)) as min,max(CAST(pr.`product_price` as DECIMAL)) as max FROM `fish_jshopping_products` AS `pr` WHERE pr.product_publish=1 AND pr.label_id=2
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 164, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (73,74,76,77,78,79,81,82,83,84) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (73,74,76,77,78,79,81,82,83,84) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name asc LIMIT 124, 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 desc LIMIT 635, 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 1385, 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 1828, 1
SELECT count(distinct prod.product_id) FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.listing_product>0 AND pr_cat.category_id IN (21,22,41,42,46,47,63,64,88,89,91,258) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.sales, prod.`alias_ru-RU` as alias, prod.alias_family, prod.family_seo, prod.family, prod.product_template FROM `fish_jshopping_products` AS prod INNER JOIN `fish_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND pr_cat.category_id IN (21,22,41,42,46,47,63,64,88,89,91,258) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.listing_product >0 GROUP BY product_id ORDER BY prod.product_quantity=0, prod.image='', name asc LIMIT 246, 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='', prod.product_price desc LIMIT 3690, 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 82, 1
18 × SELECT * FROM fish_jshopping_products
17 × SELECT * FROM `fish_jshopping_products_attr`
16 × SELECT DISTINCT(p.product_id), p.*, p.`name_ru-RU` as name, p.`alias_ru-RU` as alias, p.fregat_id FROM `fish_jshopping_products` AS `p`
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
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `fish_extensions`
2 × SELECT distinct PA.attr_1 as val_id, V.`name_ru-RU` as value_name, V.image, PA.ean, PA.fregat_id, PA.count, PA.manufacturer_code, PA.price, PA.old_price FROM `fish_jshopping_products_attr` as PA INNER JOIN fish_jshopping_attr_values as V ON PA.attr_1=V.value_id
2 × SELECT id, `name_ru-RU` as name, field_id FROM `fish_jshopping_products_extra_field_values`
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 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 pa.product_id,pa.count,av.attr_id, pa.attr_1 ,av.`name_ru-RU` as value_name,av.image FROM fish_jshopping_products_attr AS pa LEFT JOIN fish_jshopping_attr_values AS av ON pa.attr_1=av.value_id
1 × SELECT `params` FROM `fish_extensions`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM fish_extensions
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 `alias_ru-RU` as alias, 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 `name_ru-RU` as name, category_id, category_parent_id, category_publish FROM `fish_jshopping_categories`
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 distinct man.manufacturer_id as id,`man`.`name_ru-RU` AS `name` FROM `fish_jshopping_products` AS `pr` LEFT JOIN `fish_jshopping_manufacturers` AS `man` ON pr.product_manufacturer_id=man.manufacturer_id
1 × SELECT extension_id FROM fish_extensions
1 × SELECT DISTINCT(pr.extra_field_45) as id FROM `fish_jshopping_products` AS `pr`
1 × SELECT id,`name_ru-RU` as name,image,color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT min(CAST(pr.`product_price` as DECIMAL)) as min,max(CAST(pr.`product_price` as DECIMAL)) as max FROM `fish_jshopping_products` AS `pr`
1 × SELECT id, rules FROM `fish_viewlevels
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 fa.id,fa.required,fa.`name_ru-RU` AS name,fa.type FROM `fish_jshopping_free_attr` AS fa
1 × SELECT id, image, color FROM `fish_jshopping_products_extra_field_values`
1 × SELECT tax_id, tax_name, tax_value FROM `fish_jshopping_taxes
1 × SELECT * FROM fish_jshopping_config
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `fish_jshopping_currencies`
1 × SELECT id, alias, `title_ru-RU` as title, `keyword_ru-RU` as keyword, `description_ru-RU` as description FROM `fish_jshopping_config_seo`
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 COUNT(distinct prod.product_id) FROM `fish_jshopping_products` as prod LEFT JOIN `fish_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
1 × select category_id as id, `alias_ru-RU` as alias from fish_jshopping_categories
1 × select id,link from fish_menu
1 × SELECT p.product_id, x.category_id, p.`name_ru-RU` as name, p.`short_description_ru-RU` as short_description, p.product_ean, p.manufacturer_code, p.image, p.product_price, p.currency_id, p.product_tax_id as tax_id, p.product_old_price, p.product_weight, p.average_rating, p.reviews_count, p.hits, p.weight_volume_units, p.basic_price_unit_id, p.label_id, p.product_manufacturer_id, p.min_price, MAX(p.product_quantity) as product_quantity, p.different_prices, p.sales, p.`alias_ru-RU` as alias, p.alias_family, p.family_seo, p.family, p.product_template FROM (SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, MAX(prod.product_quantity) as product_quantity, prod.different_prices, prod.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) LEFT JOIN `fish_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url from fish_jshopping_manufacturers
1 × SELECT * FROM fish_languages
1 × SELECT id, image, `name_ru-RU` as name FROM `fish_jshopping_product_labels`
1 × select product_id as id, `alias_ru-RU` as alias from fish_jshopping_products
1 × SELECT `data` FROM `fish_session`
1 × UPDATE `fish_extensions` SET `params` = '{\"mediaversion\":\"01b298eb94aa86ffbd078f0299a196d4\"}'
1 × SHOW FULL COLUMNS FROM `fish_jshopping_config
1 × SHOW FULL COLUMNS FROM `fish_jshopping_currencies
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products
1 × SHOW FULL COLUMNS FROM `fish_jshopping_config_seo
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_manufacturers
1 × SHOW FULL COLUMNS FROM `fish_jshopping_categories
1 × SHOW FULL COLUMNS FROM `fish_jshopping_products_reviews
1 × SHOW FULL COLUMNS FROM `fish_jshopping_filters