Select count(catalog.id) as n FROM catalog, (
SELECT t0.* FROM catalog_category t0 WHERE id = 106
UNION ALL
SELECT t1.* FROM catalog_category AS n0 INNER JOIN catalog_category AS t1 ON n0.id = t1.up WHERE n0.id =106
UNION ALL
SELECT t2.* FROM catalog_category AS n0 INNER JOIN catalog_category AS t1 ON n0.id = t1.up INNER JOIN catalog_category AS t2 ON t1.id = t2.up WHERE n0.id =106
UNION ALL
SELECT t3.* FROM catalog_category AS n0 INNER JOIN catalog_category AS t1 ON n0.id = t1.up INNER JOIN catalog_category AS t2 ON t1.id = t2.up INNER JOIN catalog_category AS t3 ON t2.id = t3.up WHERE n0.id =106
) tree where tree.id=catalog.category and tree.hide=0 and catalog.hide=0 and catalog.flag_import=0 and exists(Select * from catalog_values where catalog_values.idc=catalog.id and ( idv="29a28395-78bf-11ea-a54c-0cc47a52ebf7" ) limit 1) and catalog.total_cost>0 limit 1
Disk full (/tmp/#sql_21c7_37.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Электроустановочные изделия: звонкис доставкой по России
товаров:
Вы можете купить звонки беспроводные на батарейках, в розетку, кнопки звонковые от фирм EKF, REXANT, TDM ELECTRIC в Петрозаводске, Сортавала и Архангельске, а также оформить доставку в другие города по России.
Select catalog.id, catalog.title, catalog.art1c, catalog.timesync,
catalog.alias, catalog.total_count, catalog.short, catalog.photo, catalog.cropped,
catalog.flag_hit, catalog.flag_hot, catalog.flag_new, catalog.flag_best, catalog.is_archive,
(Select count(catalog_photo.id) from catalog_photo where catalog_photo.idt=catalog.id and ( ( catalog_photo.type="1c" and catalog_photo.timesync>catalog.timesync-86400) or catalog_photo.type!="1c" ) limit 1) as count_photo,
catalog.total_cost, catalog.total_sale, catalog.flag_sale, tree.alias as catalias, tree.title as cattitle FROM catalog, (
SELECT t0.* FROM catalog_category t0 WHERE id = 106
UNION ALL
SELECT t1.* FROM catalog_category AS n0 INNER JOIN catalog_category AS t1 ON n0.id = t1.up WHERE n0.id =106
UNION ALL
SELECT t2.* FROM catalog_category AS n0 INNER JOIN catalog_category AS t1 ON n0.id = t1.up INNER JOIN catalog_category AS t2 ON t1.id = t2.up WHERE n0.id =106
UNION ALL
SELECT t3.* FROM catalog_category AS n0 INNER JOIN catalog_category AS t1 ON n0.id = t1.up INNER JOIN catalog_category AS t2 ON t1.id = t2.up INNER JOIN catalog_category AS t3 ON t2.id = t3.up WHERE n0.id =106
) tree where tree.id=catalog.category and tree.hide=0 and catalog.hide=0 and catalog.flag_import=0 and exists(Select * from catalog_values where catalog_values.idc=catalog.id and ( idv="29a28395-78bf-11ea-a54c-0cc47a52ebf7" ) limit 1) and catalog.total_cost>0 order by title asc limit 0,60
Disk full (/tmp/#sql_21c7_37.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
