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

---

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

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