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 90,10
Clinton

Clinton

Delta State
View Portfolio
Amayindi

Amayindi

FCT Abuja
View Portfolio
Ebuka

Ebuka

Lagos State
View Portfolio
Rebecca

Rebecca

Kaduna State
View Portfolio
Paul

Paul

Lagos State
View Portfolio
Christiana

Christiana

Lagos State
View Portfolio
Mayowa Mike

Mayowa Mike

Lagos State
View Portfolio
Bilyamin Y

Bilyamin Y

Kano State
View Portfolio
Blessing

Blessing

Benue State
View Portfolio
Nzubechukwu

Nzubechukwu

Anambra State
View Portfolio