SELECT * FROM `profiles`  WHERE `country` = 'oman' AND `gender` = 'w' AND `gender` = 'w' AND `active` = '1'  ORDER BY RAND() LIMIT 20
Mysql Error:
Disk full (/tmp/#sql-temptable-2d64b4-2dde3-a3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")