SELECT * FROM `profiles`  WHERE `country` = 'united-arab-emirates' AND `gender` = 'w' AND `gender` = 'w' AND `active` = '1'  ORDER BY RAND() LIMIT 20

Mysql Error:

Error writing file '/tmp/#sql-temptable-277-779d2-59bb.MAD' (Errcode: 28 "No space left on device")