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

Member Directory

Filters:
Assistants List
Rescue Photos
General Member

Gen Quinn

MYRTLEFORD, Australia
Ingenius Photography
Gen Quinn
General Member

Susan (Sue) Ratcliffe

Mississauga, Ontario
Sue Ratcliffe Photography Available Services: Black & White, Photography Clinic, Event or Show, Farm, Portrait, Stock.
Susan (Sue) Ratcliffe
General Member

Christine Reed

Omaha, Nebraska
Christine Reed
General Member

Amy Rice

Nipomo, California
Mementos by Amy
Amy Rice
General Member

Sara Roche

Westport, Connecticut
Sara Roche
General Member

Libby Rosen

Mill Spring, North Carolina
Good Dog Day Available Services: Art.
Libby Rosen
General Member

Kathy Russell

Front Royal, Virginia
Available Services: Art, Digital, Event or Show, Farm, Portrait, Race.
Kathy Russell
General Member

Linda Russell

Truckee, California
Available Services: Digital.
Linda Russell
General Member

Adrianne Ryan

Adrianne Ryan
General Member

Heather Sacha

Sumner, Washington
Heather Sacha Photos and Art Available Services: Art, Digital, Event or Show, Farm, Merchandise, Portrait, Race.
Heather Sacha
General Member

Amanda Sanders

Louisville, Kentucky
Bluegrass Girl Photography Available Services: Art, Event or Show, Farm, Portrait.
Amanda Sanders
General Member

Jean Sarchet

Jean Sarchet
General Member

Theodore Scarpino

Biglerille, Pennsylvania
Theodore Scarpino
General Member

Kathryn Schultz

Washington, Georgia
Farm Fresh Photography Available Services: Art, Black & White, Digital, Event or Show, Farm, Portrait.
Kathryn Schultz
General Member

Natalie Seabolt

Craigsville, West Virginia
Summer Pastures Photography Available Services: Art, Farm, Portrait.
Natalie Seabolt
General Member

Sandy Sharkey

Ottawa, Ontario
Sandy Sharkey Photography
Sandy Sharkey
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

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

Newton, 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 - 281 of 281 members