Error Number: 1021
Disk full (/tmp/#sql_23aadf_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT smb.id, cabins, smb.companyid as charter_id, snbt.macrocruise_name as type_id, model as model_name, year as buildYear, snbt.macrocruise_name as macro_boat_type, smba.name as naziv_marine, smb.base as marina_id, smb.companyid as companyId, d1.name as location_name, r1.nameEN as region_name , smc.nameENG as drzava_name, smb.id as boat_id, smb.name as boat_name, model as model_name, (SELECT path FROM sync_mmk_downloaded_images smdi WHERE smdi.boat_id = smb.id LIMIT 1) as picture, berths as berthsTotal FROM sync_mmk_boats smb LEFT JOIN sync_mmk_bases smba ON smba.id = smb.base LEFT JOIN destinations d1 ON d1.id = smba.macrocruise_destination_id LEFT JOIN region1 r1 ON smba.macrocruise_region1_id = r1.id LEFT JOIN sync_mmk_countries smc ON smba.countryId = smc.id LEFT JOIN sync_nausys_boat_types snbt ON (snbt.mmk_name = smb.kind AND snbt.is_shown = 1) WHERE snbt.macrocruise_name = NULL AND (smb.cabins = NULL OR smb.base = NULL OR smb.model = NULL) ORDER BY RAND() LIMIT 8
Filename: controllers/Boats.php
Line Number: 79