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

---

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

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