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 100,10
Lucia

Lucia

Lagos State
View Portfolio
Ebite

Ebite

Delta State
View Portfolio
Opara

Opara

Imo State
View Portfolio
Efetabo

Efetabo

Delta State
View Portfolio
Monica

Monica

Delta State
View Portfolio
Esther

Esther

Abia State
View Portfolio
Misturah

Misturah

Lagos State
View Portfolio
ADIGUN

ADIGUN

Ondo State
View Portfolio
Mordecai

Mordecai

Osun State
View Portfolio
Virginia

Virginia

Lagos State
View Portfolio