Select * from catalog_category where id=13 limit 1

MySQL server has gone away

Каталог

Фильтры

Каталог Товаров

Низковольтное оборудование

Сбросить фильтры

Цена (руб)

от

до

Select * from catalog_factory where hide=0 and counter>0 and exists(Select * from catalog where catalog.factory=catalog_factory.id and catalog.total_cost>0 and catalog.category=133 limit 1) order by title asc

MySQL server has gone away

Наличие

Только в наличии

Select * from catalog_city where hide=0 order by pos asc

MySQL server has gone away

Под заказ

Select catalog_props.* from catalog_props, catalog_props_value, catalog where catalog_props.id=catalog_props_value.idp and catalog.id=catalog_props_value.idc and catalog.category=133 group by catalog_props.id order by min(catalog_props_value.pos) asc

MySQL server has gone away

Select count(catalog.id) as n FROM catalog, (SELECT * FROM catalog_category WHERE id = 133 or exists(Select 1 from catalog_category_link where catalog_category_link.idc=133 and catalog_category_link.idp=catalog_category.id limit 1) ) tree where tree.id=catalog.category and tree.hide=0 and catalog.hide=0 and catalog.flag_import=0 and catalog.total_cost>0 limit 1

MySQL server has gone away

Низковольтное оборудование: автоматические выключатели модульныес доставкой по России

товаров:

Select * from catalog_category where up=133 and hide=0 order by pos asc

MySQL server has gone away

Вы можете купить автоматический выключатель от фирм EKF, IEK, TDM ELECTRIC в Петрозаводске, Сортавала и Архангельске, а также оформить доставку в другие города по России.

Select * from catalog_category_set where catalog_category_set.cat=133 order by title asc

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, (SELECT * FROM catalog_category WHERE id = 133 or exists(Select 1 from catalog_category_link where catalog_category_link.idc=133 and catalog_category_link.idp=catalog_category.id limit 1) ) tree where tree.id=catalog.category and tree.hide=0 and catalog.hide=0 and catalog.flag_import=0 and catalog.total_cost>0 order by if(total_count>0,1,0) desc, catalog.pos desc, catalog.defsort desc, catalog.timecreate desc limit 0,60

MySQL server has gone away