SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/skaterti/green-gray-ranner.html' LIMIT 0,1 [0.00037217140197754 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('green','gray','ranner') order by url [0.00072097778320312 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('green','gray','ranner') order by url [0.00058484077453613 sec]
SELECT id, url FROM pod_filter WHERE url IN ('green','gray','ranner') [0.00033998489379883 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('green','gray','ranner') [0.00041103363037109 sec]
SELECT sc.url, sc.id AS super_category_id, sc.name AS super_category_name, sc.templ_good_title AS templ_good_title, sc.templ_good_kwds, sc.templ_good_desc AS templ_good_desc, sc.templ_brand_title AS templ_brand_title, sc.templ_brand_kwds, sc.templ_brand_desc AS templ_brand_desc, sc.templ_cat_title AS templ_cat_title, sc.templ_cat_kwds, sc.templ_cat_desc AS templ_cat_desc, 1 AS o FROM pod_cat_category c LEFT JOIN pod_super_category sc ON sc.id=c.super_category_id WHERE c.id='12' [0.00028800964355469 sec]
SELECT f.id, mf.id as mf_id, mf.is_split FROM pod_filter f INNER JOIN pod_filter mf ON f.entry = mf.id WHERE f.id in (32,30,2665) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00034999847412109 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; CREATE TEMPORARY TABLE tmp_base_goods ( id INT NOT NULL PRIMARY KEY, brand_id INT, price DECIMAL(10,2), old_price DECIMAL(10,2), ordr INT, is_present TINYINT(1), sub_icon_id INT, fast_delivery TINYINT(1), is_new TINYINT(1), is_sale TINYINT(1), KEY idx_brand (brand_id) ) ENGINE=MEMORY [0.00032711029052734 sec]
INSERT INTO tmp_base_goods (id, brand_id, price, old_price, ordr, is_present, sub_icon_id, fast_delivery, is_new, is_sale) SELECT g.id, g.brand_id, g.price, g.old_price, g.ordr, g.is_present, g.sub_icon_id, g.fast_delivery, g.is_new, g.is_sale FROM pod_cat_good g WHERE g.cat_id IN (12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196) AND g.entry=0 AND g.is_active AND g.is_present_all_mods UNION SELECT g.id, g.brand_id, g.price, g.old_price, g.ordr, g.is_present, g.sub_icon_id, g.fast_delivery, g.is_new, g.is_sale FROM pod_cat_good g INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id WHERE dc.dop_cat_id IN (12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.18998885154724 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, price DECIMAL(10,2), old_price DECIMAL(10,2), sub_icon_id INT, is_present TINYINT(1), fast_delivery TINYINT(1), is_new TINYINT(1), is_sale TINYINT(1), KEY idx_entry (entry) ) ENGINE=MEMORY [0.00025320053100586 sec]
INSERT INTO tmp_sub_goods (id, entry, price, old_price, sub_icon_id, is_present, fast_delivery, is_new, is_sale) SELECT go.id, go.entry, go.price, go.old_price, go.sub_icon_id, go.is_present, go.fast_delivery, go.is_new, go.is_sale 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.03911304473877 sec]
SELECT g.id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (30,32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2665) WHERE 1 [0.018041849136353 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2b3efed8e5d ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00044107437133789 sec]
INSERT INTO temp_brand_counts_6a2b3efed8e5d (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (30,32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2665) WHERE 1 [0.001194953918457 sec]
SELECT b.id, b.name AS name, pc.name 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_6a2b3efed8e5d 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.00044488906860352 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2b3efed8e5d [0.00013589859008789 sec]
SELECT MIN(min_price) AS min_price, MAX(max_price) AS max_price FROM ( SELECT MIN(g.price) AS min_price, MAX(g.price) AS max_price /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (30,32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2665) WHERE g.is_present AND 1 UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (30,32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2665) WHERE 1 ) A [0.0011169910430908 sec]
SELECT g.id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */,if(g.is_present and g.price >= '134' and g.price <= '973',least(g.price,ifnull(min(pcg.price),g.price)),ifnull(min(pcg.price),g.price)) min_sort_price, if(g.is_present and g.price >= '134' and g.price <= '973',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) max_sort_price FROM tmp_base_goods g LEFT JOIN pod_cat_good pcg ON pcg.entry=g.id AND pcg.is_present=1 AND pcg.price >= '134' AND pcg.price <= '973' WHERE g.id IN (352426,363804,375616,381310,386739,386775,386797,386963,386985,387032,387431,391466,428741,430458,430458,430558,430921,435768,437428,439475,441975,447625,450620,454012,460353,462186,465841,465842,465854,466124,467794,468200,468322,470349,470965,470978,480677,483617,483627,485130,485132,492137,494092,494096,503289,507487,507490) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.0024819374084473 sec]
SELECT g.video, g.threedvideo, g.is_xit, g.is_action, g.is_sale, g.sub_is_action, g.is_new, g.is_pay_for_video, g.id, g.cat_id, g.name AS name, g.name2 AS name2, g.descr, g.size_table, g.artikul, g.image_small, g.image_big, g.price, g.old_price, g.is_present, g.is_present_all_mods, g.sub_icon_id,g.url,g.ordr, g.last_items, g.fast_delivery, g.free_delivery, g.gift, g.timer, g.action_validity, b.name AS brand_name,b.url as burl,b.id as bid, b.country AS brand_country,c.url as curl, c.name AS cat_name, si.name AS sub_icon_name,si.icon AS sub_icon, g.star, g.comment_id, if(g.is_present and g.price >= '134' and g.price <= '973',least(g.price,ifnull(min(pcg.price),g.price)),ifnull(min(pcg.price),g.price)) as min_sort_price, if(g.is_present and g.price >= '134' and g.price <= '973',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) as max_sort_price FROM pod_cat_good g INNER JOIN pod_cat_category c ON c.id=g.cat_id LEFT JOIN pod_cat_brand b ON b.id=g.brand_id LEFT JOIN pod_sub_icon si ON si.id=g.sub_icon_id LEFT JOIN pod_cat_good pcg ON (pcg.entry=g.id and pcg.is_present=1 and pcg.price >= '134' and pcg.price <= '973') WHERE g.id in (465854,503289,480677,494092,465841,454012,465842,391466,428741,439475,381310,466124,450620,430558,386963,485132,352426,470349,386739,483617,430921,386985,492137,363804,470965,441975,507487,386775,483627,468200,460353,435768) GROUP BY g.id ORDER BY g.ordr desc [0.003931999206543 sec]
SELECT g.ordr, g.is_xit, g.is_pay_for_video, g.is_action, g.is_sale, g.is_new, g.last_items, g.fast_delivery, g.free_delivery, g.gift, g.timer, g.action_validity, g.id, g.entry, g.name AS name, g.price, g.old_price, g.artikul, g.sub_icon_id, g.is_present, si.name AS sub_icon_name, si.icon AS sub_icon FROM pod_cat_good g LEFT JOIN pod_sub_icon si ON si.id = g.sub_icon_id WHERE g.entry IN (465854,503289,480677,494092,465841,454012,465842,391466,428741,439475,352426,363804,381310,386739,386775,386963,386985,430558,430921,435768,441975,450620,460353,466124,468200,470349,470965,483617,483627,485132,492137,507487) AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00047707557678223 sec]
SELECT DISTINCT ggd2.good_id AS source_good_id, g.id, g.is_present_all_mods, pc.name AS name, g.url, b.url as burl, c.url as curl, g.is_present, pc.code AS color_code, gg.group_type, gg.param_name, gg.param_name_ua, ggd.text_value, ggd.icon_path FROM pod_goods_group_goods ggd2 JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id JOIN pod_cat_good g ON g.id=ggd.good_id LEFT JOIN pod_cat_brand b ON g.brand_id=b.id LEFT JOIN pod_cat_category c ON g.cat_id=c.id LEFT JOIN pod_colors pc ON pc.id=ggd.color_id WHERE ggd2.good_id IN (465854,503289,480677,494092,465841,454012,465842,391466,428741,439475,352426,363804,381310,386739,386775,386963,386985,430558,430921,435768,441975,450620,460353,466124,468200,470349,470965,483617,483627,485132,492137,507487) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.003309965133667 sec]
SELECT id, name AS name, url FROM pod_filter WHERE id in (32,30,2665) AND is_active='1' [0.00022792816162109 sec]
SELECT cf.id, cf.info AS info, cf.title AS title, cf.metadesc AS metadesc, cf.seo_text AS seo_text, cf.tagH1 AS tagH1, cf.is_active FROM pod_set_cat_filter cf INNER JOIN pod_filter f ON cf.filter_value_id = f.id WHERE cf.cat_id = 12 AND f.id = '32' LIMIT 1 [0.00022196769714355 sec]
SELECT cf.id, cf.info AS info, cf.title AS title, cf.metadesc AS metadesc, cf.seo_text AS seo_text, cf.tagH1 AS tagH1, cf.is_active FROM pod_set_cat_subicon cf INNER JOIN pod_sub_icon f ON cf.subicon_id = f.id WHERE cf.cat_id = 12 AND f.url = 'green' LIMIT 1 [0.00024700164794922 sec]
SELECT id, name AS name, url, entry FROM pod_cat_category WHERE is_active='1' AND is_hidden='0' AND entry='0' AND super_category_id='1' AND id!='12' ORDER BY ordr [0.0005650520324707 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee0149; CREATE TEMPORARY TABLE tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee0149 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.0002591609954834 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee0149; CREATE TEMPORARY TABLE tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee0149 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00026798248291016 sec]
INSERT INTO tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee0149 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee0149 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (30,32,2665) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 12 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.014317035675049 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee0149; CREATE TEMPORARY TABLE tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee0149 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00045514106750488 sec]
INSERT IGNORE INTO tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee0149 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee0149 p GROUP BY p.filter_id [0.00050187110900879 sec]
SELECT c.filter_id, c.count, f.entry, f.name AS name, f.url, f.ord, fm.name AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee0149 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.00037193298339844 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee0149 [0.00019311904907227 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee0149 [9.4890594482422E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee0149 [8.9168548583984E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5; CREATE TEMPORARY TABLE tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00036096572875977 sec]
INSERT INTO tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (30,32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2665) WHERE g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (30,32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2665) WHERE 1 ) A [0.0053751468658447 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5; CREATE TEMPORARY TABLE tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00048303604125977 sec]
INSERT INTO tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (30,32,2665) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 12 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.0092949867248535 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5; CREATE TEMPORARY TABLE tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00048398971557617 sec]
INSERT IGNORE INTO tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 p GROUP BY p.filter_id [0.00048089027404785 sec]
SELECT c.filter_id, c.count, f.entry, f.name AS name, f.url, f.ord, fm.name AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 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.00041103363037109 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 [0.00033998489379883 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 [0.00012898445129395 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee49f5 [0.00012707710266113 sec]
SELECT f.id, mf.id as mf_id, mf.is_split FROM pod_filter f INNER JOIN pod_filter mf ON f.entry = mf.id WHERE f.id in (2665) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00044798851013184 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee97de; CREATE TEMPORARY TABLE tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee97de ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00029706954956055 sec]
INSERT INTO tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee97de (id) SELECT A.id FROM ( SELECT g.id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (2665) WHERE 1 ) A [0.00048398971557617 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee97de; CREATE TEMPORARY TABLE tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee97de ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00019407272338867 sec]
INSERT INTO tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee97de (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee97de A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 20 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.0059359073638916 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee97de; CREATE TEMPORARY TABLE tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee97de ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00022292137145996 sec]
INSERT INTO tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee97de (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee97de p GROUP BY p.filter_id [0.00022101402282715 sec]
INSERT IGNORE INTO tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee97de (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee97de c ON c.filter_id = pf.id WHERE pf.id in (30,32) AND c.filter_id IS NULL [0.00017213821411133 sec]
SELECT c.filter_id, c.count, f.entry, f.name AS name, f.url, f.ord, fm.name AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee97de 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.0002129077911377 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efee97de [0.00015687942504883 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efee97de [0.00010395050048828 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efee97de [7.7009201049805E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9; CREATE TEMPORARY TABLE tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00019598007202148 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9; CREATE TEMPORARY TABLE tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00045490264892578 sec]
INSERT INTO tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 1043 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.014240980148315 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9; CREATE TEMPORARY TABLE tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00043296813964844 sec]
INSERT INTO tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 p GROUP BY p.filter_id [0.00052118301391602 sec]
INSERT IGNORE INTO tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 c ON c.filter_id = pf.id WHERE pf.id in (2665) AND c.filter_id IS NULL [0.00037908554077148 sec]
SELECT c.filter_id, c.count, f.entry, f.name AS name, f.url, f.ord, fm.name AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 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.00047397613525391 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 [0.00031208992004395 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 [0.00017499923706055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3efeebdf9 [0.00013208389282227 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3eff00f6f; CREATE TEMPORARY TABLE tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3eff00f6f ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00024819374084473 sec]
INSERT IGNORE INTO tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3eff00f6f (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 /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (30,32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2665) WHERE g.is_present AND 1 UNION SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (30,32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2665) WHERE 1 ) A [0.0035209655761719 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3eff00f6f; CREATE TEMPORARY TABLE tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3eff00f6f ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00036406517028809 sec]
INSERT IGNORE INTO tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3eff00f6f (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3eff00f6f 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.00056719779968262 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3eff00f6f 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.00027704238891602 sec]
----------------------------- SELECT COUNT(*) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.019263982772827 sec]
Array ( [0] => Array ( [COUNT(*)] => 8062 ) ) SELECT COUNT(DISTINCT filter_id) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.029370784759521 sec]
Array ( [0] => Array ( [COUNT(DISTINCT filter_id)] => 9 ) ) ----------------------------- DROP TEMPORARY TABLE IF EXISTS tmp_A_26k5f2m9nastj590unuet3il7m_6a2b3eff00f6f [0.00035715103149414 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_26k5f2m9nastj590unuet3il7m_6a2b3eff00f6f [0.00015902519226074 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00027990341186523 sec]
Скатерти - купить скатерть в Украине и Киеве, цена в каталоге, интернет магазин Podushka.com.ua
UA
RU
Вход в кабинет

DEVELOPMENT🌷СКИДКИ ДО 70%

ПЕРЕЙТИ
Магазин PODUSHKA ®
  1. Магазин PODUSHKA ®
  2. Домашний текстиль Домашний текстиль
  3. Скатерти Скатерти

Скатерти : зеленый/салатовый, серый, раннер

Как правильно выбрать скатерть: размер, форма, цвет.
Найдено 47 товаров
Вы выбрали
Очистить все фильтры
Скатерти
Материал:
Производитель
SoundSleep (4)
Прованс (19)
Sonex (1)
Villa Grazia (1)
Ecotton (2)
Больше производителей
Умные фильтры
Со скидкой!
Быстрая доставка
Новинка
Распродажа
Размер
размер 30х100 см (2)
Основной цвет
Белый/Молочный (1)
Бежевый/Кремовый (1)
Синий/Голубой (2)
Красный/Бордовый (1)
Фиолетовый/Сиреневый (3)
Розовый/Пудровый (2)
Серый (30)
Коричневый (2)
Зеленый/Салатовый (17)
Бирюзовый/Аквамариновый (1)
Оранжевый/Абрикосовый (2)
Черный (5)
Желтый/Песочный (7)
Золотой (5)
Серебристый (6)
Разноцветный (34)
Хаки (1)
Показать больше
Длина скатерти
140 см и меньше (19)
161-190 см (4)
Ширина скатерти
120 см и менее (21)
Вид скатерти
скатерть (55)
салфетка (58)
настольник (1)
дорожка (13)
набор (2)
раннер (14)
Показать больше
Тип рисунка
цветы (5)
однотонные (2)
геометрический рисунок (2)
новогодний (1)
люди (4)
пасхальный (1)
Показать больше
Цена
—
грн

Смотрите также
Сортировать:
по популярности
Выбрать производителя
Ранер новогодний водостойкий Winter Love SoundSleep серый - 20 %
Ранер новогодний водостойкий Winter Love SoundSleep серый
Код: 465854
delivary icon

Производитель: SoundSleep (Украина)

Цена:
184 грн 230 грн
Ранер Jordan Sonex серый
Ранер Jordan Sonex серый
Код: 503289

Производитель: Sonex (Украина)

Цена:
528 грн
Дорожка хлопковая Flora Прованс
Дорожка хлопковая Flora Прованс
Код: 480677

Производитель: Прованс (Украина)

Цена:
249 грн
Дорожка новогодняя Noel Прованс
Дорожка новогодняя Noel Прованс
Код: 494092

Производитель: Прованс (Украина)

Цена:
134 грн
Ранер водостойкий SoundSleep Loisa темно-серый - 10 %
Ранер водостойкий SoundSleep Loisa темно-серый
Код: 465841
delivary icon

Производитель: SoundSleep (Украина)

Цена:
201 грн 223 грн
Дорожка гобеленовая Афины Прованс
Дорожка гобеленовая Афины Прованс
Код: 454012

Производитель: Прованс (Украина)

размер 40х140 см

463 грн
В 1 клик Купить
Цена:
295 грн
Ранер водостойкий SoundSleep Loisa серый - 10 %
Ранер водостойкий SoundSleep Loisa серый
Код: 465842
delivary icon

Производитель: SoundSleep (Украина)

Цена:
201 грн 223 грн
Дорожка хлопковая Мира Прованс
Дорожка хлопковая Мира Прованс
Код: 391466

Производитель: Прованс (Украина)

Цена:
299 грн
Дорожка хлопковая Орхидея Прованс
Дорожка хлопковая Орхидея Прованс
Код: 428741

Производитель: Прованс (Украина)

Цена:
236 грн
Раннер с рюшами Muslin Graphite SoundSleep графит - 31 %
Раннер с рюшами Muslin Graphite SoundSleep графит
Код: 439475
delivary icon

Производитель: SoundSleep (Украина)

Цена:
349 грн 503 грн
Гобеленовый раннер Baena Lefard - 21 %
Гобеленовый раннер Baena Lefard
Код: 352426

Производитель: Lefard (Украина)

размер 45х140 см

655 грн
В 1 клик Купить
Цена:
396 грн 500 грн
Дорожка льняная с мережкой LiMaSo NPL12
Дорожка льняная с мережкой LiMaSo NPL12
Код: 363804

Производитель: LiMaSo (Украина)

Цена:
972 грн
Раннер хлопковый столовый New Chambray Centrotex ментоловый
Раннер хлопковый столовый New Chambray Centrotex ментоловый
Код: 381310

Производитель: Centrotex (Италия)

Цена:
594 грн
Дорожка гобеленовая LiMaSo EDEN1178
star line
1
Дорожка гобеленовая LiMaSo EDEN1178
Код: 386739

Производитель: LiMaSo (Украина)

размер 45х140 см

973 грн
В 1 клик Купить
Цена:
686 грн
Дорожка гобеленовая LiMaSo EDEN1183
Дорожка гобеленовая LiMaSo EDEN1183
Код: 386775

Производитель: LiMaSo (Украина)

размер 45х140 см

973 грн
В 1 клик Купить
Цена:
686 грн
Дорожка гобеленовая LiMaSo ZOOM004
Дорожка гобеленовая LiMaSo ZOOM004
Код: 386963

Производитель: LiMaSo (Украина)

размер 45х140 см

973 грн
В 1 клик Купить
Цена:
686 грн
Дорожка гобеленовая LiMaSo ZOOM007
Дорожка гобеленовая LiMaSo ZOOM007
Код: 386985

Производитель: LiMaSo (Украина)

размер 45х140 см

973 грн
В 1 клик Купить
Цена:
686 грн
Дорожка хлопковая Клетка Прованс
Дорожка хлопковая Клетка Прованс
Код: 430558

Производитель: Прованс (Украина)

Цена:
189 грн
Раннер Merry Christmas Прованс серый
Раннер Merry Christmas Прованс серый
Код: 430921

Производитель: Прованс (Украина)

Цена:
149 грн
Раннер 45х140 см Ягодка Lefard
Раннер 45х140 см Ягодка Lefard
Код: 435768

Производитель: Lefard (Украина)

Цена:
317 грн
Раннер с тефлоновой пропиткой Серебряные лепестки Villa Grazia
Раннер с тефлоновой пропиткой Серебряные лепестки Villa Grazia
Код: 441975

Производитель: Villa Grazia (Украина)

размер 45x140 см

928 грн
В 1 клик Купить
Цена:
669 грн
Дорожка Тереза Цветочки с кантом Прованс
Дорожка Тереза Цветочки с кантом Прованс
Код: 450620

Производитель: Прованс (Украина)

размер 40х160 см

499 грн
В 1 клик Купить
Цена:
449 грн
Дорожка гобеленовая Garden Прованс
Дорожка гобеленовая Garden Прованс
Код: 460353

Производитель: Прованс (Украина)

размер 40х140 см

579 грн
В 1 клик Купить
Цена:
369 грн
Дорожка новогодняя Шапочки на зеленом Прованс
Дорожка новогодняя Шапочки на зеленом Прованс
Код: 466124

Производитель: Прованс (Украина)

размер 40х180 см

404 грн
В 1 клик Купить
Цена:
314 грн
Ранер Leaves Ardesto
Ранер Leaves Ardesto
Код: 468200

Производитель: Ardesto (КНР)

Цена:
209 грн
Дорожка Rino Прованс серый
Дорожка Rino Прованс серый
Код: 470349

Производитель: Прованс (Украина)

Цена:
219 грн
Раннер Lefard серый
Раннер Lefard серый
Код: 470965

Производитель: Lefard (Украина)

Цена:
465 грн
Дорожка хлопковая Раф Прованс
Дорожка хлопковая Раф Прованс
Код: 483617

Производитель: Прованс (Украина)

Цена:
149 грн
Дорожка Фраппе Прованс
Дорожка Фраппе Прованс
Код: 483627

Производитель: Прованс (Украина)

Цена:
149 грн
Дорожка водоотталкивающая V11 Grey DUCK Ecotton
Дорожка водоотталкивающая V11 Grey DUCK Ecotton
Код: 485132

Производитель: Ecotton (Украина)

Цена:
305 грн
Раннер гобеленовый Сицилийский лимон Lefard
Раннер гобеленовый Сицилийский лимон Lefard
Код: 492137

Производитель: Lefard (Украина)

Цена:
675 грн
Раннер гобеленовый Lefard серый Новинка
Раннер гобеленовый Lefard серый
Код: 507487

Производитель: Lefard (Украина)

Цена:
503 грн
1 2