SELECT distinct(ID), um.meta_value, um1.meta_value from wp_users as us INNER JOIN wp_usermeta as um on  us.id = um.user_id INNER JOIN wp_usermeta as um1 on  us.id = um1.user_id WHERE um.meta_key = 'role' AND um1.meta_key = 'last_name' AND  ( um.meta_value='s2member_level4' OR um.meta_value='s2member_level3' OR um.meta_value='s2member_level2' ) ORDER bY um.meta_value DESC, um1.meta_value ASC LIMIT 250, 50-255

Member Directory

Filters:
Assistants List
Rescue Photos
General Member

Kathy Whisman

E Syracuse, New York
Photos-SDG Available Services: Digital, Portrait.
Kathy Whisman
General Member

Katie Wise

Ramona, California
Sheza Shooting Star Photography Available Services: Art, Advertising & Commercial, Black & White, Digital, Event or Show, Editorial, Farm, Portrait, Race, Stock.
Katie Wise
General Member

Linda Woods

Chappell Hill, Texas
Linda Woods Photography Available Services: Art, Black & White, Digital, Event or Show, Editorial, Farm, Graphic Design, Portrait.
Linda Woods
General Member

Penny York

Available Services: Art, Advertising & Commercial, Black & White, Editorial, Graphic Design, Portrait.
Penny York
General Member

Sarah Zalan

Golden, Colorado
FuzzyButtFoto
Sarah Zalan
showing 251 - 255 of 255 members