Can't create/write to file '/tmp/#sql_483_2.MAI' (Errcode: 28 "No space left on device") SELECT DISTINCT e.IS_BUILD as is_build, e.EVENTS_ID id, e.IS_SHOW, fe.*, fe.TITLE et, e.INVITATION, e.EXHIBITORS, 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, fp.TITLE pt, ft.TOWNS_ID tid, t.TITLE tt, r.REGIONS_ID rid,
r.TITLE rt, ffe.USERS_ID, p.PLACES_ID pid
FROM EVENTS e
INNER JOIN FIRMS fe ON fe.FIRMS_ID=e.EVENTS_ID
LEFT JOIN FIRMS_TOWNS ft ON ft.FIRMS_ID=fe.FIRMS_ID
LEFT JOIN ORGANIZERS o ON e.ORGANIZERS_ID=o.ORGANIZERS_ID
LEFT JOIN FIRMS fo ON fo.FIRMS_ID=o.ORGANIZERS_ID
LEFT JOIN FAVORITE_FIRMS ffe ON ffe.FIRMS_ID=e.EVENTS_ID
LEFT JOIN PLACES p ON e.PLACES_ID=p.PLACES_ID
LEFT JOIN FIRMS fp ON fp.FIRMS_ID=p.PLACES_ID
LEFT JOIN TOWNS t ON ft.TOWNS_ID=t.TOWNS_ID
LEFT JOIN REGIONS r ON r.REGIONS_ID=t.REGIONS_ID
WHERE e.EVENTS_ID='13116' Can't create/write to file '/tmp/#sql_483_2.MAI' (Errcode: 28 "No space left on device") SELECT DISTINCT e.EVENTS_ID id, f.TITLE
FROM EVENTS e
LEFT JOIN EVENTS_THEMES ON EVENTS_THEMES.EVENTS_ID=e.EVENTS_ID
JOIN FIRMS f ON e.EVENTS_ID=f.FIRMS_ID
JOIN FIRMS_TOWNS ft ON f.FIRMS_ID=ft.FIRMS_ID
WHERE e.DATE_END >= curdate() AND ft.TOWNS_ID='' AND ft.REGIONS_ID='' /*AND e.DATE_BEGIN <= ADDDATE(curdate(), INTERVAL 3 MONTH)*/ AND EVENTS_THEMES.THEMES_ID IN (0) AND e.EVENTS_ID <> '' Can't create/write to file '/tmp/#sql_483_2.MAI' (Errcode: 28 "No space left on device") SELECT DISTINCT* FROM SERVICE LEFT JOIN FIRMS_SERVICE fs ON fs.SERVICE_ID=SERVICE.SERVICE_ID WHERE fs.FIRMS_ID='13116' ORDER BY SERVICE.ORDERBY,SERVICE.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
Выставочный портал GeneralExpo.ru / Выставки / Все выставочные мероприятия / Информация о выставочном мероприятии