DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; CREATE TEMPORARY TABLE tmp_base_goods (id INT NOT NULL PRIMARY KEY) ENGINE=MEMORY [0.00059700012207031 sec]
INSERT INTO tmp_base_goods (id) SELECT DISTINCT g.id FROM pod_cat_good g WHERE g.cat_id IN (146) AND g.entry=0 AND g.is_active AND g.is_present_all_mods UNION SELECT DISTINCT g.id FROM pod_cat_good g INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id WHERE dc.dop_cat_id IN (146) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.0061860084533691 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods; CREATE TEMPORARY TABLE tmp_sub_goods (id INT NOT NULL PRIMARY KEY, entry INT NOT NULL, KEY idx_entry (entry)) ENGINE=MEMORY [0.0004580020904541 sec]
INSERT INTO tmp_sub_goods (id, entry) SELECT go.id, go.entry FROM pod_cat_good go INNER JOIN tmp_base_goods t ON go.entry = t.id WHERE go.is_active AND go.is_present [0.0012378692626953 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2ac5099a186 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.0003809928894043 sec]
INSERT INTO temp_brand_counts_6a2ac5099a186 (id, gid) SELECT g.brand_id AS id, g.id AS gid -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (501,503) WHERE g.is_present_all_mods AND g.is_active UNION SELECT id, null gid FROM pod_cat_category WHERE id in (1991,2494) [0.030857086181641 sec]
SELECT b.id, b.name_ua AS name, pc.name_ua AS country, b.country_id, b.image_icon, b.url, b.ordr, pc.code, COALESCE(tc.count, 0) as count FROM pod_cat_brand b INNER JOIN ( SELECT id, COUNT(gid) as count FROM temp_brand_counts_6a2ac5099a186 GROUP BY id HAVING COUNT(gid) > 0 ) tc ON b.id = tc.id LEFT JOIN pod_country pc ON (pc.id = b.country_id AND pc.is_active = 1) WHERE b.is_active = '1' ORDER BY b.ordr [0.00081992149353027 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2ac5099a186 [0.00020003318786621 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f; CREATE TEMPORARY TABLE tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00037193298339844 sec]
INSERT INTO tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f (id) SELECT A.id FROM ( SELECT g.id -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (501,503) WHERE g.brand_id IN (1991,2494) AND g.is_present_all_mods AND g.is_active ) A [0.0052189826965332 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f; CREATE TEMPORARY TABLE tmp_pairs_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00033211708068848 sec]
INSERT INTO tmp_pairs_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (501,503) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 146 INNER JOIN pod_filter fm ON gf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active [0.0058779716491699 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f; CREATE TEMPORARY TABLE tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00037598609924316 sec]
INSERT IGNORE INTO tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f p GROUP BY p.filter_id [0.00031113624572754 sec]
SELECT c.filter_id, c.count, f.entry, f.name_ua AS name, f.url, f.ord, fm.name_ua AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f c INNER JOIN pod_filter f ON c.filter_id = f.id INNER JOIN pod_filter fm ON f.entry = fm.id ORDER BY fm.ord DESC, f.ord DESC, c.filter_id [0.00033283233642578 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f [0.00033116340637207 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f [0.00017690658569336 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509a587f [0.00015091896057129 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8; CREATE TEMPORARY TABLE tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00029611587524414 sec]
INSERT INTO tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (501,503) WHERE g.brand_id IN (1991,2494) AND g.is_present AND g.is_present_all_mods AND g.is_active UNION SELECT go.id as id, g.id as entry -- підтовари (tmp) FROM tmp_sub_goods t INNER JOIN pod_cat_good go ON t.id = go.id INNER JOIN pod_cat_good g ON t.entry = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (501,503) WHERE g.brand_id IN (1991,2494) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0011320114135742 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8; CREATE TEMPORARY TABLE tmp_pairs_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00039911270141602 sec]
INSERT INTO tmp_pairs_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (501,503) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 146 INNER JOIN pod_filter fm ON gf.filter_id = fm.id AND fm.is_split = 1 AND fm.is_active INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active [0.00095295906066895 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8; CREATE TEMPORARY TABLE tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00033307075500488 sec]
INSERT IGNORE INTO tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 p GROUP BY p.filter_id [0.00039505958557129 sec]
SELECT c.filter_id, c.count, f.entry, f.name_ua AS name, f.url, f.ord, fm.name_ua AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 c INNER JOIN pod_filter f ON c.filter_id = f.id INNER JOIN pod_filter fm ON f.entry = fm.id ORDER BY fm.ord DESC, f.ord DESC, c.filter_id [0.00041604042053223 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 [0.00030612945556641 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 [0.00014901161193848 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509a92c8 [0.00019383430480957 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509aaf03; CREATE TEMPORARY TABLE tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509aaf03 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00026917457580566 sec]
INSERT IGNORE INTO tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509aaf03 (entry, sub_icon_id) SELECT DISTINCT A.entry, A.sub_icon_id FROM ( SELECT g.id as id, g.id as entry, g.sub_icon_id -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (501,503) WHERE g.brand_id IN (1991,2494) AND g.is_present AND g.is_present_all_mods AND g.is_active UNION SELECT go.id as id, g.id as entry, go.sub_icon_id -- підтовари (tmp) FROM tmp_sub_goods t INNER JOIN pod_cat_good go ON t.id = go.id INNER JOIN pod_cat_good g ON t.entry = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (501,503) WHERE g.brand_id IN (1991,2494) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0011701583862305 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509aaf03; CREATE TEMPORARY TABLE tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509aaf03 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00032305717468262 sec]
INSERT IGNORE INTO tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509aaf03 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509aaf03 A INNER JOIN pod_sub_icon si ON A.sub_icon_id = si.id AND si.is_active_filter = 1 ) AA GROUP BY sub_icon_id [0.00038790702819824 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name_ua AS name, si.url FROM tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509aaf03 c INNER JOIN pod_sub_icon si ON c.sub_icon_id = si.id AND si.is_active_filter = 1 ORDER BY si.ordr, si.name [0.00027990341186523 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_4ln971js6l9930j3ebl95eai8d_6a2ac509aaf03 [0.00023102760314941 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_4ln971js6l9930j3ebl95eai8d_6a2ac509aaf03 [0.00011396408081055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.0002138614654541 sec]
Низькі ціни на Розвиваючі іграшки Learning Resources ... Dodo (Лирнінг Рeсoуркeс ... Дoдo) - великий вибір, фото. Купити Розвиваючі іграшки Learning Resources ... Dodo (Лирнінг Рeсoуркeс ... Дoдo) в Києві і Україні

DEVELOPMENT🌷ЗНИЖКИ ДО 70%

Магазин PODUSHKA ®

Магазин PODUSHKA ®
Іграшки для дітей Іграшки для дітей
Іграшки для малюків Іграшки для малюків
Розвиваючі іграшки Розвиваючі іграшки
Learning Resources ... Dodo Learning Resources ... Dodo

Розвиваючі іграшки Learning Resources ... Dodo

Як правильно вибрати іграшку для дитини