(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="123872" 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="123872" 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="123872" 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="123872" and catalog.art1c=catalog_link.art limit 1) order by rand() limit 1)

---

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

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