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 30,10
Tosan

Tosan

Abia State
View Portfolio
Mary

Mary

Osun State
View Portfolio
ANNABEL

ANNABEL

Akwa Ibom State
View Portfolio
Christiana

Christiana

FCT Abuja
View Portfolio
Damilola

Damilola

Ondo State
View Portfolio
Atuluku

Atuluku

Kogi State
View Portfolio
Onuche

Onuche

Kogi State
View Portfolio
Omololu

Omololu

Lagos State
View Portfolio
Ugbaja

Ugbaja

Anambra State
View Portfolio
Emmanuella

Emmanuella

Lagos State
View Portfolio