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-266

Member Directory

Filters:
Assistants List
Rescue Photos
General Member

Kathy Sherbert

Kathy Sherbert
General Member

Shelly Simpson

Ocala, Florida
ivegotyourpicture.com
Shelly Simpson
General Member

Kristina Truluck

El Paso, Texas
Truluck Photography Available Services: Art, Advertising & Commercial, Event or Show, Farm, Portrait.
Kristina Truluck
General Member

Catharina Van Leeuwenkamp

Calgary, Alberta
Wishfoal Memories Photography Available Services: Art, Black & White, Digital, Farm, Graphic Design, Portrait.
Catharina Van Leeuwenkamp
General Member

Ann Vassey

Winslow, Maine
AnnVasseyPhotography
Ann Vassey
General Member

Belle Vivienne

Belle Vivienne
General Member

Diana Volk

Sheridan, Wyoming
Diana Volk Photography
Diana Volk
General Member

Elaine Warfield

east jewett, New York
Elaine Warfield Photography Available Services: Art.
Elaine Warfield
General Member

Wendy Warren

West Bloomfield, Michigan
Wendy Warren Photography
Wendy Warren
General Member

Leanna Whipple

Johnston, Iowa
Available Services: Black & White, Digital, Event or Show, Farm, Portrait.
Leanna Whipple
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

Debbie Witt

Debbie Witt
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 - 266 of 266 members