Select count(catalog.id) as n FROM catalog, catalog_category as tree where tree.id=catalog.category and tree.hide=0 and catalog.hide=0 and catalog.flag_import=0 and catalog.total_cost>0 and factory in (Select id from catalog_factory where alias=272 ) limit 1
MySQL server has gone away
Каталог товаровс доставкой по России
товаров:
Select catalog_brands.* from catalog_brands, catalog_factory where catalog_brands.idf=catalog_factory.id and catalog_factory.alias=272 and catalog_brands.hide=0 limit 1
MySQL server has gone away
Select catalog.id, catalog.short, catalog.about, 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, catalog_category as tree where tree.id=catalog.category and tree.hide=0 and catalog.hide=0 and catalog.flag_import=0 and catalog.total_cost>0 and factory in (Select id from catalog_factory where alias=272 ) order by if(total_count>0,1,0) desc, catalog.defsort desc, catalog.timecreate desc limit 0,60
MySQL server has gone away
