SELECT * FROM `profiles`  WHERE `country` = '%D8%A7%D9%84%D8%B1%D8%A8%D8%A7%D8%B7' AND `gender` = 'w' AND `gender` = 'w' AND `active` = '1'  ORDER BY RAND() LIMIT 20

Mysql Error:

Disk full (/tmp/#sql-temptable-277-1a18e0-1179b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")