(Select catalog.*, tree.alias as catalias, tree.title as cattitle from catalog, catalog_category as tree where tree.id=catalog.category and catalog.total_cost>0 and exists(Select * from catalog_link where groupcat="Сыпучие, порошковые средства" and catalog_link.catalog_art="95091" and catalog.art1c=catalog_link.art limit 1) order by rand() limit 1) UNION (Select catalog.*, tree.alias as catalias, tree.title as cattitle from catalog, catalog_category as tree where tree.id=catalog.category and catalog.total_cost>0 and exists(Select * from catalog_link where groupcat="Прочее" and catalog_link.catalog_art="95091" and catalog.art1c=catalog_link.art limit 1) order by rand() limit 1) UNION (Select catalog.*, tree.alias as catalias, tree.title as cattitle from catalog, catalog_category as tree where tree.id=catalog.category and catalog.total_cost>0 and exists(Select * from catalog_link where groupcat="Очистители" and catalog_link.catalog_art="95091" and catalog.art1c=catalog_link.art limit 1) order by rand() limit 1) UNION (Select catalog.*, tree.alias as catalias, tree.title as cattitle from catalog, catalog_category as tree where tree.id=catalog.category and catalog.total_cost>0 and exists(Select * from catalog_link where groupcat="Пасты" and catalog_link.catalog_art="95091" and catalog.art1c=catalog_link.art limit 1) order by rand() limit 1)

---

Disk full (/tmp/#sql_76e4_61.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

Наш сайт использует файлы cookie. Cookie - небольшие фрагменты данных (файлы), которые с помощью браузера сохраняет на компьютере пользователя веб-сервер (сайт). Пользуясь сайтом, Вы даете согласие на обработку и использование ваших данных.