Can't create/write to file '/tmp/#sql_483_2.MAI' (Errcode: 28 "No space left on device")
SELECT DISTINCT SQL_CALC_FOUND_ROWS e.EVENTS_ID id, fe.LOGO, fe.TITLE et, DATE_FORMAT( e.DATE_BEGIN, '%d.%m.%Y' ) DATE_BEGIN, DATE_FORMAT( e.DATE_END, '%d.%m.%Y' ) DATE_END, o.ORGANIZERS_ID oid, fo.TITLE ot, p.PLACES_ID pid, fe.ADRESS, fp.TITLE pt, fe.DESCRIPTION, fe.TYPE_OBJECT FROM EVENTS e JOIN FIRMS fe ON e.EVENTS_ID=fe.FIRMS_ID LEFT JOIN ORGANIZERS o ON e.ORGANIZERS_ID=o.ORGANIZERS_ID LEFT JOIN FIRMS fo ON o.ORGANIZERS_ID=fo.FIRMS_ID LEFT JOIN PLACES p ON e.PLACES_ID=p.PLACES_ID LEFT JOIN FIRMS fp ON p.PLACES_ID=fp.FIRMS_ID LEFT JOIN FIRMS_TOWNS ft ON ft.FIRMS_ID=e.EVENTS_ID LEFT JOIN TOWNS t ON ft.TOWNS_ID=t.TOWNS_ID LEFT JOIN REGIONS r ON ft.REGIONS_ID=t.REGIONS_ID WHERE 1=1 AND ft.TOWNS_ID='1228' AND fe.PROMOPLACE=1 AND COALESCE(fe.PROMOPLACE_DATE_END,'')>=curdate() AND (fe.TYPE_OBJECT='expo' OR fe.TYPE_OBJECT='confer') ORDER BY RAND() 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 ') AND ft.TOWNS_ID='1228' AND e.DATE_END>=curdate() AND (fe.TYPE_OBJECT='exp...' at line 11
SELECT DISTINCT SQL_CALC_FOUND_ROWS e.IS_BUILD as is_build, e.EVENTS_ID id, fe.LOGO, fe.TITLE et, DATE_FORMAT( e.DATE_BEGIN, '%d.%m.%Y' ) DATE_BEGIN, DATE_FORMAT( e.DATE_END, '%d.%m.%Y' ) DATE_END, DATEDIFF(DATE_BEGIN, NOW()) is_started, o.ORGANIZERS_ID oid, fo.TITLE ot, p.PLACES_ID pid, fe.ADRESS, fp.TITLE pt, fe.DESCRIPTION, fe.TYPE_OBJECT FROM EVENTS e JOIN FIRMS fe ON e.EVENTS_ID=fe.FIRMS_ID LEFT JOIN ORGANIZERS o ON e.ORGANIZERS_ID=o.ORGANIZERS_ID LEFT JOIN FIRMS fo ON o.ORGANIZERS_ID=fo.FIRMS_ID LEFT JOIN PLACES p ON e.PLACES_ID=p.PLACES_ID LEFT JOIN FIRMS fp ON p.PLACES_ID=fp.FIRMS_ID LEFT JOIN FIRMS_TOWNS ft ON ft.FIRMS_ID=e.EVENTS_ID LEFT JOIN TOWNS t ON ft.TOWNS_ID=t.TOWNS_ID LEFT JOIN REGIONS r ON ft.REGIONS_ID=t.REGIONS_ID WHERE 1=1 AND e.EVENTS_ID NOT IN) AND ft.TOWNS_ID='1228' AND e.DATE_END>=curdate() AND (fe.TYPE_OBJECT='expo' OR fe.TYPE_OBJECT='confer') ORDER BY e.DATE_BEGIN, et LIMIT 0,15
Can't create/write to file '/tmp/#sql_483_2.MAI' (Errcode: 28 "No space left on device")
SELECT DISTINCT o.ORGANIZERS_ID id, f.TITLE FROM EVENTS LEFT JOIN ORGANIZERS o ON o.ORGANIZERS_ID=EVENTS.ORGANIZERS_ID JOIN FIRMS f ON f.FIRMS_ID=o.ORGANIZERS_ID ORDER BY TITLE
Can't create/write to file '/tmp/#sql_483_2.MAI' (Errcode: 28 "No space left on device")
SELECT DISTINCT t.THEMES_ID id, t.TITLE FROM EVENTS_THEMES LEFT JOIN THEMES t ON EVENTS_THEMES.THEMES_ID=t.THEMES_ID ORDER BY TITLE
Can't create/write to file '/tmp/#sql_483_2.MAI' (Errcode: 28 "No space left on device")
SELECT DISTINCT p.PLACES_ID id, f.TITLE FROM EVENTS LEFT JOIN PLACES p ON EVENTS.PLACES_ID=p.PLACES_ID JOIN FIRMS f ON f.FIRMS_ID=p.PLACES_ID ORDER BY TITLE
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 Каталог выставок, каталог выставок 2012, каталог международных выставок, каталог участников выставки

Главная

О проекте

Новости

Выставки

Площадки

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

Услуги

Фотографии

Видео

Контакты

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

Каталог выставок в г. Черноббио


Фотографии



<< < 1 2 .. 161 > >>

Вакансии

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




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