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

---

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

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