select t_user.sex,t_user.level,t_user.properties,t_user.flickrid,t_user.instagram,t_user.tumblr,t_user.website,t_user.twitter,t_user.bluesky,t_user.facebook_fansite,t_user.subdomain,tmp_user_judgement.pagerank,ifnull(tmp_user_judgement.favs,0) as favs,ifnull(tmp_user_judgement.stars,0) as stars,t_user.about,t_user.status,t_user.actualranking,t_user.lastranking,t_user.actualranking is null or t_user.lastranking is null or t_user.lastranking = t_user.actualranking as tendenceSame, t_user.location,t_user.username,t_user.id,t_user.city,t_user.uid,t_user.portfolio,t_user.profilepic as pp from t_user  LEFT JOIN tmp_user_judgement ON t_user.id=tmp_user_judgement.uid LEFT JOIN t_user_ranking ON t_user.id=t_user_ranking.uid where t_user.status>0 and t_user.portfolio>0 AND ((t_user.portfolio=3 and t_user.id in (select fuid from t_user_relation where uid=30194 and t_user_relation.value&128)) or (SELECT COUNT(t_images.id)>0 FROM t_images WHERE t_images.uid=t_user.id and t_images.active>0)) and (t_user.actualranking is not null or t_user.portfolio=3) and t_user.category_paths like '%,24,%' and t_user.location_path like '%,46,%' and YEAR(t_user.created)=2025 and t_user.portfolio!=3 and t_user_ranking.category=24 and t_user.id not in (SELECT fuid FROM t_user_relation WHERE t_user_relation.value=2 AND uid=30194) order by t_user_ranking.ranking asc,t_user.portfolio=1 desc,t_user.portfolio=2 asc,t_user.portfolio=4 asc,t_user.id desc limit 0,5