Talent DirectoryBack
 to     
Order by:
select u.id as userid,u.username as username,u.fullmember,u.name_visibility,u.fname,u.country,u.state,u.reg_date, (SELECT COUNT(*) FROM star_favourite AS t2 WHERE t2.user_id= 0 and t2.favourite=u.id) AS tstate, sui.image_path1 as imeh_p from star_user as u left join star_pro_image_lock as spil on u.id = spil.user_id and spil.status = 2 left join star_user_images as sui on sui.user_id = u.id and profile_img='Y' where u.status='Y' and u.user_type='T' group by u.id order by u.fullmember ASC, spil.date_time DESC, u.reg_date ASC limit 20,10
Yusuf

Yusuf

Lagos State
View Portfolio
Chioma

Chioma

Imo State
View Portfolio
Abbie

Abbie

Abia State
View Portfolio
Aselimhe

Aselimhe

Lagos State
View Portfolio
Anozie

Anozie

Imo State
View Portfolio
Xvel

Xvel

Anambra State
View Portfolio
Bello

Bello

Lagos State
View Portfolio
Moyinoluwa Diamond

Moyinoluwa Diamond

Oyo State
View Portfolio
Joy

Joy

Enugu State
View Portfolio
Okediji

Okediji

Oyo State
View Portfolio