QUERY:
SELECT DISTINCT e.*
FROM elgg_entities e
JOIN elgg_users_entity u ON e.guid = u.guid
JOIN
  (SELECT subm1.*, s1.string
   FROM elgg_metadata subm1
   JOIN elgg_metastrings s1 ON subm1.value_id = s1.id) AS m1 ON e.guid = m1.entity_guid
JOIN
  (SELECT subm2.*, s2.string
   FROM elgg_metadata subm2
   JOIN elgg_metastrings s2 ON subm2.value_id = s2.id) AS m2 ON e.guid = m2.entity_guid
JOIN
  (SELECT subm3.*, s3.string
   FROM elgg_metadata subm3
   JOIN elgg_metastrings s3 ON subm3.value_id = s3.id) AS m3 ON e.guid = m3.entity_guid
JOIN
  (SELECT subm4.*, s4.string
   FROM elgg_metadata subm4
   JOIN elgg_metastrings s4 ON subm4.value_id = s4.id) AS m4 ON e.guid = m4.entity_guid
JOIN
  (SELECT subm5.*, s5.string
   FROM elgg_metadata subm5
   JOIN elgg_metastrings s5 ON subm5.value_id = s5.id) AS m5 ON e.guid = m5.entity_guid
JOIN
  (SELECT subm6.*, s6.string
   FROM elgg_metadata subm6
   JOIN elgg_metastrings s6 ON subm6.value_id = s6.id) AS m6 ON e.guid = m6.entity_guid
JOIN
  (SELECT subm7.*, s7.string
   FROM elgg_metadata subm7
   JOIN elgg_metastrings s7 ON subm7.value_id = s7.id) AS m7 ON e.guid = m7.entity_guid
JOIN
  (SELECT subm8.*, s8.string
   FROM elgg_metadata subm8
   JOIN elgg_metastrings s8 ON subm8.value_id = s8.id) AS m8 ON e.guid = m8.entity_guid
WHERE ((m1.name_id='22991'
        AND m1.string IN ('Html',
                          'Css',
                          'Javascript',
                          'Dhtml',
                          'Actionscript',
                          'Open laszlo',
                          'Javafx',
                          'Flex',
                          'VisualBasic',
                          'Ajax'))
       AND (m2.name_id='22996'
            AND m2.string IN ('ASP.NET',
                              'Cold Fusion',
                              'Java',
                              'Ssjs',
                              'Cgi',
                              'SMX',
                              'Php',
                              'Perl',
                              'Lassso',
                              'WebDna',
                              'Python',
                              'VB.NET',
                              'Ruby',
                              'ASP'))
       AND (m3.name_id='23000'
            AND m3.string IN ('Mysql',
                              'Mssql',
                              'Postgresql',
                              'Oracle',
                              'Sybase',
                              'BigTable',
                              'Microsoft Access',
                              'OpenOffice Base',
                              'XML',
                              'DB-FAST',
                              'Java DB',
                              'fastDB',
                              'H2',
                              'Helix databse',
                              'HSQLDB'))
       AND (m4.name_id='23068'
            AND m4.string IN ('Eclipse IDE',
                              'Apache Server',
                              'JDK',
                              'Tomcat',
                              'Ant',
                              'JBOSS',
                              'JUNIT',
                              'XAMPP',
                              'Notepad ++',
                              'Photoshop',
                              'CVS',
                              'Git',
                              'FileZilla'))
       AND (m5.name_id='23073'
            AND m5.string IN ('Browser Testing',
                              'Automated'))
       AND (((m6.name_id='681')
             OR (m6.name_id='22949'))
            AND m6.string = 'BHM')
       AND (((m7.name_id='795')
             OR (m7.name_id='22954'))
            AND m7.string = '2003')
       AND (((m8.name_id='22961')
             OR (m8.name_id='22965'))
            AND m8.string = 'Microsoft Certified Professional (MCP)'))
  AND ((1 = 1)
       AND e.enabled='yes')
  AND ((1 = 1)
       AND m1.enabled='yes')
  AND ((1 = 1)
       AND m2.enabled='yes')
  AND ((1 = 1)
       AND m3.enabled='yes')
  AND ((1 = 1)
       AND m4.enabled='yes')
  AND ((1 = 1)
       AND m5.enabled='yes')
  AND ((1 = 1)
       AND m6.enabled='yes')
  AND ((1 = 1)
       AND m7.enabled='yes')
  AND ((1 = 1)
       AND m8.enabled='yes')
ORDER BY e.time_created DESC LIMIT 0,
                                   10