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' and find_in_set( 4,u.cat_id) group by u.id order by u.fullmember ASC, spil.date_time DESC, u.reg_date ASC limit 0,10
Hilary

Hilary

Lagos State
View Portfolio
Ifeoluwa

Ifeoluwa

Lagos State
View Portfolio
Omoghene

Omoghene

Delta State
View Portfolio
Victor

Victor

Lagos State
View Portfolio
Clinton

Clinton

Delta State
View Portfolio
Virginia

Virginia

Lagos State
View Portfolio
Abiola

Abiola

Lagos State
View Portfolio
Blessed

Blessed

FCT Abuja
View Portfolio
Udeh

Udeh

Enugu State
View Portfolio
Chibyk

Chibyk

Lagos State
View Portfolio