SELECT
      se_users.user_id,
      se_users.user_username,
      se_users.user_fname,
      se_users.user_lname,
      se_users.user_photo
    FROM
      se_profilevalues
    LEFT JOIN
      se_users
      ON se_profilevalues.profilevalue_user_id=se_users.user_id
    LEFT JOIN
      se_levels
      ON se_levels.level_id=se_users.user_level_id
    WHERE
      se_users.user_verified='1' AND
      se_users.user_enabled='1' AND
      (se_users.user_search='1' OR se_levels.level_profile_search='0') AND
      (se_users.user_username LIKE '%torre%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%torre%' OR `se_profilevalues`.`profilevalue_1` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_5` IN (SELECT CASE WHEN languagevar_id='500382' THEN 1 WHEN languagevar_id='500383' THEN 2 WHEN languagevar_id='500629' THEN 3 END AS value FROM se_languagevars WHERE languagevar_id IN (500382, 500383, 500629) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_6` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_7` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_8` IN (SELECT CASE WHEN languagevar_id='500572' THEN 1 WHEN languagevar_id='500573' THEN 2 WHEN languagevar_id='500574' THEN 3 WHEN languagevar_id='500575' THEN 4 WHEN languagevar_id='500576' THEN 5 WHEN languagevar_id='500577' THEN 6 WHEN languagevar_id='500578' THEN 7 WHEN languagevar_id='500579' THEN 8 WHEN languagevar_id='500580' THEN 9 WHEN languagevar_id='500581' THEN 10 WHEN languagevar_id='500582' THEN 11 WHEN languagevar_id='500583' THEN 12 WHEN languagevar_id='500584' THEN 13 WHEN languagevar_id='500585' THEN 14 WHEN languagevar_id='500586' THEN 15 WHEN languagevar_id='500587' THEN 16 WHEN languagevar_id='500588' THEN 17 WHEN languagevar_id='500589' THEN 18 WHEN languagevar_id='500590' THEN 19 WHEN languagevar_id='500591' THEN 20 WHEN languagevar_id='500731' THEN 21 WHEN languagevar_id='500732' THEN 22 END AS value FROM se_languagevars WHERE languagevar_id IN (500572, 500573, 500574, 500575, 500576, 500577, 500578, 500579, 500580, 500581, 500582, 500583, 500584, 500585, 500586, 500587, 500588, 500589, 500590, 500591, 500731, 500732) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_9` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_11` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_12` IN (SELECT CASE WHEN languagevar_id='500740' THEN 1 WHEN languagevar_id='500741' THEN 2 WHEN languagevar_id='500742' THEN 3 END AS value FROM se_languagevars WHERE languagevar_id IN (500740, 500741, 500742) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_13` IN (SELECT CASE WHEN languagevar_id='500747' THEN 1 WHEN languagevar_id='500748' THEN 2 WHEN languagevar_id='500749' THEN 3 WHEN languagevar_id='500750' THEN 4 WHEN languagevar_id='500751' THEN 5 END AS value FROM se_languagevars WHERE languagevar_id IN (500747, 500748, 500749, 500750, 500751) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_14` IN (SELECT CASE WHEN languagevar_id='500755' THEN 1 WHEN languagevar_id='500756' THEN 2 WHEN languagevar_id='500757' THEN 3 WHEN languagevar_id='500758' THEN 4 WHEN languagevar_id='500759' THEN 5 WHEN languagevar_id='500760' THEN 6 WHEN languagevar_id='500761' THEN 7 WHEN languagevar_id='500762' THEN 8 END AS value FROM se_languagevars WHERE languagevar_id IN (500755, 500756, 500757, 500758, 500759, 500760, 500761, 500762) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_15` IN (SELECT CASE WHEN languagevar_id='500766' THEN 1 WHEN languagevar_id='500767' THEN 2 WHEN languagevar_id='500768' THEN 3 WHEN languagevar_id='500769' THEN 4 WHEN languagevar_id='500770' THEN 5 WHEN languagevar_id='500938' THEN 6 END AS value FROM se_languagevars WHERE languagevar_id IN (500766, 500767, 500768, 500769, 500770, 500938) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_16` IN (SELECT CASE WHEN languagevar_id='500774' THEN 1 WHEN languagevar_id='500775' THEN 2 WHEN languagevar_id='500776' THEN 3 WHEN languagevar_id='500777' THEN 4 WHEN languagevar_id='500778' THEN 5 END AS value FROM se_languagevars WHERE languagevar_id IN (500774, 500775, 500776, 500777, 500778) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_17` IN (SELECT CASE WHEN languagevar_id='500782' THEN 1 WHEN languagevar_id='500783' THEN 2 WHEN languagevar_id='500784' THEN 3 WHEN languagevar_id='500785' THEN 4 WHEN languagevar_id='500786' THEN 5 WHEN languagevar_id='500787' THEN 6 WHEN languagevar_id='500788' THEN 7 WHEN languagevar_id='500789' THEN 8 END AS value FROM se_languagevars WHERE languagevar_id IN (500782, 500783, 500784, 500785, 500786, 500787, 500788, 500789) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_18` IN (SELECT CASE WHEN languagevar_id='500793' THEN 1 WHEN languagevar_id='500794' THEN 2 WHEN languagevar_id='500795' THEN 3 END AS value FROM se_languagevars WHERE languagevar_id IN (500793, 500794, 500795) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_19` IN (SELECT CASE WHEN languagevar_id='500799' THEN 1 WHEN languagevar_id='500800' THEN 2 WHEN languagevar_id='500801' THEN 3 END AS value FROM se_languagevars WHERE languagevar_id IN (500799, 500800, 500801) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_20` IN (SELECT CASE WHEN languagevar_id='500812' THEN 1 WHEN languagevar_id='500813' THEN 2 WHEN languagevar_id='500814' THEN 3 WHEN languagevar_id='500815' THEN 4 END AS value FROM se_languagevars WHERE languagevar_id IN (500812, 500813, 500814, 500815) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_21` IN (SELECT CASE WHEN languagevar_id='500809' THEN 1 WHEN languagevar_id='500810' THEN 2 WHEN languagevar_id='500811' THEN 3 END AS value FROM se_languagevars WHERE languagevar_id IN (500809, 500810, 500811) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_22` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_23` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_24` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_25` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_26` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_27` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_28` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_29` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_30` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_44` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_32` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_33` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_43` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_35` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_45` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_36` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_37` IN (SELECT CASE WHEN languagevar_id='500865' THEN 1 WHEN languagevar_id='500866' THEN 2 WHEN languagevar_id='500867' THEN 3 WHEN languagevar_id='500868' THEN 4 END AS value FROM se_languagevars WHERE languagevar_id IN (500865, 500866, 500867, 500868) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_38` IN (SELECT CASE WHEN languagevar_id='500872' THEN 1 WHEN languagevar_id='500873' THEN 2 WHEN languagevar_id='500874' THEN 3 WHEN languagevar_id='500875' THEN 4 END AS value FROM se_languagevars WHERE languagevar_id IN (500872, 500873, 500874, 500875) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_39` IN (SELECT CASE WHEN languagevar_id='500883' THEN 1 WHEN languagevar_id='500884' THEN 2 WHEN languagevar_id='500885' THEN 3 WHEN languagevar_id='500886' THEN 4 WHEN languagevar_id='500887' THEN 5 WHEN languagevar_id='500888' THEN 6 WHEN languagevar_id='500889' THEN 7 WHEN languagevar_id='500890' THEN 8 WHEN languagevar_id='500891' THEN 9 WHEN languagevar_id='500892' THEN 10 WHEN languagevar_id='500893' THEN 11 WHEN languagevar_id='500894' THEN 12 WHEN languagevar_id='500895' THEN 13 WHEN languagevar_id='500896' THEN 14 WHEN languagevar_id='500897' THEN 15 WHEN languagevar_id='500898' THEN 16 WHEN languagevar_id='500899' THEN 17 WHEN languagevar_id='500900' THEN 18 WHEN languagevar_id='500901' THEN 19 WHEN languagevar_id='500902' THEN 20 WHEN languagevar_id='500903' THEN 21 WHEN languagevar_id='500904' THEN 22 WHEN languagevar_id='500905' THEN 23 WHEN languagevar_id='500906' THEN 24 WHEN languagevar_id='500907' THEN 25 WHEN languagevar_id='500908' THEN 26 WHEN languagevar_id='500909' THEN 27 WHEN languagevar_id='500910' THEN 28 WHEN languagevar_id='500911' THEN 29 WHEN languagevar_id='500912' THEN 30 WHEN languagevar_id='500913' THEN 31 WHEN languagevar_id='500914' THEN 32 WHEN languagevar_id='500915' THEN 33 WHEN languagevar_id='500916' THEN 34 WHEN languagevar_id='500917' THEN 35 WHEN languagevar_id='500918' THEN 36 WHEN languagevar_id='500919' THEN 37 WHEN languagevar_id='500920' THEN 38 WHEN languagevar_id='500921' THEN 39 WHEN languagevar_id='500922' THEN 40 WHEN languagevar_id='500923' THEN 41 WHEN languagevar_id='500924' THEN 42 WHEN languagevar_id='500925' THEN 43 WHEN languagevar_id='500926' THEN 44 WHEN languagevar_id='500927' THEN 45 END AS value FROM se_languagevars WHERE languagevar_id IN (500883, 500884, 500885, 500886, 500887, 500888, 500889, 500890, 500891, 500892, 500893, 500894, 500895, 500896, 500897, 500898, 500899, 500900, 500901, 500902, 500903, 500904, 500905, 500906, 500907, 500908, 500909, 500910, 500911, 500912, 500913, 500914, 500915, 500916, 500917, 500918, 500919, 500920, 500921, 500922, 500923, 500924, 500925, 500926, 500927) AND languagevar_value LIKE '%torre%') OR `se_profilevalues`.`profilevalue_40` LIKE '%torre%' OR `se_profilevalues`.`profilevalue_42` LIKE '%torre%')
   ORDER BY se_users.user_id DESC LIMIT 0, 21;