1114 : The table '/tmp/#sql_7055_7' is full
(SELECT id, number_rooms, secondary, area, floor, all_floors, street, house, address_area, address_area_micro, address_area_zhk, price, price_m2, text, foto, agency, date from kaliningrad_kvartiry_prodaja WHERE moderated is not null and number_rooms >= 0 and number_rooms =3 and address_area_zhk = 'Дом Нефтяника' order by date desc, id desc LIMIT 7 ) UNION ALL (SELECT id, number_rooms, secondary, area, floor, all_floors, street, house, address_area, address_area_micro, address_area_zhk, price, price_m2, text, foto, agency, date from kaliningrad_kvartiry_prodaja WHERE moderated is not null and number_rooms >= 0 ORDER BY RAND() LIMIT 7 )
Error in sql