Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device") SELECT p.*, 
	IF ( ( list_as_whole = 0 OR bedrooms = 0 OR ( from_feed = 1 AND feed_overwrite=0 ) ), MIN(r.price_per_week), MIN(r.price_per_week) / bedrooms ) AS price_per_week, 
	price, price_frequency, p2.filename AS image_file, p2.slot_id AS image_slot FROM property p JOIN property_room r ON r.property_id = p.id LEFT JOIN property_photo p2 ON p2.property_id = p.id JOIN landlord l ON l.id = p.landlord_id WHERE l.status = 'A' AND p.id <> 36232 AND p.status = 'A' AND ( 3959 * acos( cos( radians(50.3822) )
										* cos( radians( p.lat ) )
										* cos( radians( p.lng )
										- radians(-4.13915) )
										+ sin( radians(50.3822) )
										* sin( radians( p.lat ) ) ) ) <= 10 GROUP BY p.id ORDER BY rand() LIMIT 0, 4