Каталог

Пн-пт 09:00-18:00 | сб 10:00-17:00 | вс - выходной

Главная
Каталог
Избранное
Войти
Select catalog.id, catalog.title, catalog.about, catalog.timesync, catalog.alias, catalog.total_count, catalog.total_cost, catalog.total_sale, catalog.flag_sale, catalog.art1c, (Select count(*) from catalog_prices where catalog_prices.idc=catalog.id limit 1) as active, (Select news.title_ru from news where news.category_id=2 and news.hide=0 and news.art like CONCAT("%",catalog.art1c,"%") limit 1) as stock_title, (Select count(*) 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.short, catalog.photo, catalog.cropped, tree.alias as catalias, tree.title as cattitle FROM catalog, catalog_category as tree where tree.id=catalog.category and catalog.photo!="" and catalog.total_cost>0 and exists(Select * from sliders_link where sliders_link.idt=18 and sliders_link.catalog_id=catalog.id limit 1) order by rand()
Disk full (/tmp/#sql_76e4_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Обновления
Select *, (Select fname from news_photo where news_photo.idt=news.id order by news_photo.tomain desc, news_photo.id asc limit 1) as fname, (Select title_ru from news_category where news_category.id=news.subcat_id limit 1) as cat_title from news where category_id=3 and subcat_id!=9 and logo!="" and hide=0 order by rand() limit 8
Disk full (/tmp/#sql_76e4_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Select *, (Select fname from news_photo where news_photo.idt=news.id order by news_photo.tomain desc, news_photo.id asc limit 1) as fname from news where category_id=4 and hide=0 and logo!="" order by rand() limit 8
Disk full (/tmp/#sql_76e4_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Select catalog.id, catalog.title, catalog.about, catalog.timesync, catalog.alias, catalog.total_count, catalog.total_cost, catalog.total_sale, catalog.flag_sale, catalog.art1c, (Select count(*) from catalog_prices where catalog_prices.idc=catalog.id limit 1) as active, (Select news.title_ru from news where news.category_id=2 and news.hide=0 and news.art like CONCAT("%",catalog.art1c,"%") limit 1) as stock_title, (Select count(*) 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.short, catalog.photo, catalog.cropped, tree.alias as catalias, tree.title as cattitle FROM catalog, catalog_category as tree where tree.id=catalog.category and catalog.photo!="" and catalog.total_cost>0 and exists(Select * from sliders_link where sliders_link.idt=16 and sliders_link.catalog_id=catalog.id limit 1) order by rand()
Disk full (/tmp/#sql_76e4_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Select catalog.id, catalog.title, catalog.about, catalog.timesync, catalog.alias, catalog.total_count, catalog.total_cost, catalog.total_sale, catalog.flag_sale, catalog.art1c, (Select count(*) from catalog_prices where catalog_prices.idc=catalog.id limit 1) as active, (Select news.title_ru from news where news.category_id=2 and news.hide=0 and news.art like CONCAT("%",catalog.art1c,"%") limit 1) as stock_title, (Select count(*) 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.short, catalog.photo, catalog.cropped, tree.alias as catalias, tree.title as cattitle FROM catalog, catalog_category as tree where tree.id=catalog.category and catalog.photo!="" and catalog.total_cost>0 and exists(Select * from sliders_link where sliders_link.idt=17 and sliders_link.catalog_id=catalog.id limit 1) order by rand()
Disk full (/tmp/#sql_76e4_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Select catalog.id, catalog.title, catalog.about, catalog.timesync, catalog.alias, catalog.total_count, catalog.total_cost, catalog.total_sale, catalog.flag_sale, catalog.art1c, (Select count(*) from catalog_prices where catalog_prices.idc=catalog.id limit 1) as active, (Select news.title_ru from news where news.category_id=2 and news.hide=0 and news.art like CONCAT("%",catalog.art1c,"%") limit 1) as stock_title, (Select count(*) 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.short, catalog.photo, catalog.cropped, tree.alias as catalias, tree.title as cattitle FROM catalog, catalog_category as tree where tree.id=catalog.category and catalog.photo!="" and catalog.total_cost>0 and exists(Select * from sliders_link where sliders_link.idt=14 and sliders_link.catalog_id=catalog.id limit 1) order by rand()
Disk full (/tmp/#sql_76e4_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Наш сайт использует файлы cookie. Cookie - небольшие фрагменты данных (файлы), которые с помощью браузера сохраняет на компьютере пользователя веб-сервер (сайт). Пользуясь сайтом, Вы даете согласие на обработку и использование ваших данных.
Подробнее
Select * from notification where hide=0 and timestart<=1765679346 and timestop>=1765679346 and exists(Select 1 from notification_page where idt=notification.id and name="" limit 1) order by rand() limit 1
Disk full (/tmp/#sql_76e4_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")