Can't create/write to file '/tmp/#sql_483_2.MAI' (Errcode: 28 "No space left on device")
SELECT DISTINCT REGIONS.* FROM FIRMS_TOWNS LEFT JOIN REGIONS ON REGIONS.REGIONS_ID=FIRMS_TOWNS.REGIONS_ID LEFT JOIN FIRMS_SERVICE ON FIRMS_SERVICE.FIRMS_ID=FIRMS_TOWNS.FIRMS_ID WHERE FIRMS_SERVICE.SERVICE_ID='39' ORDER BY TITLE
Can't create/write to file '/tmp/#sql_483_2.MAI' (Errcode: 28 "No space left on device")
SELECT DISTINCT TOWNS.* FROM FIRMS_TOWNS LEFT JOIN TOWNS ON TOWNS.TOWNS_ID=FIRMS_TOWNS.TOWNS_ID LEFT JOIN FIRMS_SERVICE ON FIRMS_SERVICE.FIRMS_ID=FIRMS_TOWNS.FIRMS_ID WHERE FIRMS_SERVICE.SERVICE_ID='39' ORDER BY TITLE
Can't create/write to file '/tmp/#sql_483_4.MAI' (Errcode: 28 "No space left on device")
SELECT DISTINCT SQL_CALC_FOUND_ROWS f.*, (SELECT REGIONS.TITLE FROM REGIONS LEFT JOIN FIRMS_TOWNS ON FIRMS_TOWNS.REGIONS_ID=REGIONS.REGIONS_ID WHERE FIRMS_TOWNS.FIRMS_ID=f.FIRMS_ID ORDER BY IS_MAIN DESC LIMIT 1) rt,(SELECT TOWNS.TITLE FROM TOWNS LEFT JOIN FIRMS_TOWNS ON FIRMS_TOWNS.TOWNS_ID=TOWNS.TOWNS_ID WHERE FIRMS_TOWNS.FIRMS_ID=f.FIRMS_ID ORDER BY IS_MAIN DESC LIMIT 1) tt FROM FIRMS f LEFT JOIN FIRMS_SERVICE fs ON f.FIRMS_ID=fs.FIRMS_ID LEFT JOIN FIRMS_TOWNS ft ON ft.FIRMS_ID=f.FIRMS_ID LEFT JOIN TOWNS ON ft.TOWNS_ID=TOWNS.TOWNS_ID LEFT JOIN REGIONS ON ft.REGIONS_ID=REGIONS.REGIONS_ID WHERE /*f.TYPE_OBJECT='service_comp' AND*/ f.PROMOPLACE=1 AND COALESCE(f.PROMOPLACE_DATE_END,'')>=curdate() AND fs.SERVICE_ID='39' ORDER BY RAND(), f.TITLE LIMIT 3
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY f.TITLE LIMIT 0,10' at line 6
SELECT DISTINCT SQL_CALC_FOUND_ROWS f.*, (SELECT REGIONS.TITLE FROM REGIONS LEFT JOIN FIRMS_TOWNS ON FIRMS_TOWNS.REGIONS_ID=REGIONS.REGIONS_ID WHERE FIRMS_TOWNS.FIRMS_ID=f.FIRMS_ID ORDER BY IS_MAIN DESC LIMIT 1) rt, (SELECT TOWNS.TITLE FROM TOWNS LEFT JOIN FIRMS_TOWNS ON FIRMS_TOWNS.TOWNS_ID=TOWNS.TOWNS_ID WHERE FIRMS_TOWNS.FIRMS_ID=f.FIRMS_ID ORDER BY IS_MAIN DESC LIMIT 1) tt FROM FIRMS f LEFT JOIN FIRMS_SERVICE fs ON f.FIRMS_ID=fs.FIRMS_ID LEFT JOIN FIRMS_TOWNS ft ON ft.FIRMS_ID=f.FIRMS_ID LEFT JOIN TOWNS ON ft.TOWNS_ID=TOWNS.TOWNS_ID LEFT JOIN REGIONS ON ft.REGIONS_ID=REGIONS.REGIONS_ID WHERE /*f.TYPE_OBJECT='service_comp' AND*/ fs.SERVICE_ID='39' AND f.FIRMS_ID NOT IN) ORDER BY f.TITLE LIMIT 0,10
Can't create/write to file '/tmp/#sql_483_2.MAI' (Errcode: 28 "No space left on device")
SELECT DISTINCT PLACES.PLACES_ID, FIRMS.TITLE/*, TOWNS.TITLE TT*/ FROM FIRMS LEFT JOIN PLACES ON FIRMS.FIRMS_ID=PLACES.PLACES_ID /*LEFT JOIN FIRMS_TOWNS ON FIRMS_TOWNS.FIRMS_ID=FIRMS.FIRMS_ID LEFT JOIN TOWNS ON TOWNS.TOWNS_ID=FIRMS_TOWNS.TOWNS_ID*/ WHERE PLACES.IS_MAIN=1 ORDER BY FIRMS.TITLE
Can't create/write to file '/tmp/#sql_483_2.MAI' (Errcode: 28 "No space left on device")
SELECT FIRMS.* FROM ORGANIZERS JOIN FIRMS ON FIRMS.FIRMS_ID=ORGANIZERS.ORGANIZERS_ID WHERE IS_MAIN=1 ORDER BY TITLE Выставочный портал GeneralExpo.ru / Услуги / Список фирм

Главная

О проекте

Новости

Выставки

Площадки

Организаторы

Услуги

Фотографии

Видео

Контакты

Все ближайшие выставки Все тематики Все страны Все города Все площадки Все организаторы Все сервисные компании Все выставочные услуги

Фирмы, предоставляющие услугу

«Переводчики»

Отсортировать по:Названию Городу Стране

Фотографии



<< < 1 2 .. 161 > >>

Вакансии

Все вакансииДобавить вакансию




Добавить выставку
Добавить тендер