File: /home/lbike/web/l-bike.ru/public_html/bitrix/modules/sale/mysql/location.php Line: 111 MySQL Query Error: SELECT DISTINCT L.ID as ID, L.COUNTRY_ID as COUNTRY_ID, L.REGION_ID as REGION_ID, L.CITY_ID as CITY_ID, L.SORT as SORT, COO.NAME as COUNTRY_NAME_ORIG, COO.SHORT_NAME as COUNTRY_SHORT_NAME, REO.NAME as REGION_NAME_ORIG, CIO.NAME as CITY_NAME_ORIG, REO.SHORT_NAME as REGION_SHORT_NAME, CIO.SHORT_NAME as CITY_SHORT_NAME, COL.LANGUAGE_ID as COUNTRY_LID, COL.NAME as COUNTRY_NAME, REL.LANGUAGE_ID as REGION_LID, CIL.LANGUAGE_ID as CITY_LID, REL.NAME as REGION_NAME, CIL.NAME as CITY_NAME, CASE WHEN DEF.LOCATION_CODE IS NULL THEN 'N' ELSE 'Y' END as LOC_DEFAULT FROM b_sale_location L LEFT JOIN b_sale_loc_name COO ON (L.COUNTRY_ID = COO.LOCATION_ID and COO.LANGUAGE_ID = 'en') LEFT JOIN b_sale_loc_name REO ON (L.REGION_ID = REO.LOCATION_ID and REO.LANGUAGE_ID = 'en') LEFT JOIN b_sale_loc_name CIO ON (L.CITY_ID = CIO.LOCATION_ID and CIO.LANGUAGE_ID = 'en') LEFT JOIN b_sale_loc_name COL ON (L.COUNTRY_ID = COL.LOCATION_ID AND COL.LANGUAGE_ID = 'ru') LEFT JOIN b_sale_loc_name REL ON (L.REGION_ID = REL.LOCATION_ID AND REL.LANGUAGE_ID = 'ru') LEFT JOIN b_sale_loc_name CIL ON (L.CITY_ID = CIL.LOCATION_ID AND CIL.LANGUAGE_ID = 'ru') LEFT JOIN b_sale_loc_def2site DEF ON (DEF.LOCATION_CODE = L.CODE) WHERE ((((L.TYPE_ID = 1 )) OR ((L.TYPE_ID = 2 )) OR ((L.TYPE_ID = 3 )))) ORDER BY CIL.NAME ASC [[3] Error writing file '/tmp/MYXDVYm2' (Errcode: 28 - No space left on device)]