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

Member Directory

Filters:
Assistants List
Rescue Photos
General Member

Denise Nelson

Gray, Tennessee
Denise Nelson's Photography
Denise Nelson
General Member

Kathleen Nicholson

kathy nicholson photography
Kathleen Nicholson
General Member

Chelsea Nickell

Caldwell, Kansas
Captivation Photography Available Services: Art, Advertising & Commercial, Black & White, Event or Show, Editorial, Farm, Portrait, Race.
Chelsea Nickell
General Member

Meg O’Reagan

, Georgia
Hooves & Hounds Photography Available Services: Digital, Farm, Portrait.
Meg O’Reagan
General Member

Rebeca Paro

Woodbury, Minnesota
Available Services: Art, Photography Clinic, Portrait.
Rebeca Paro
General Member

Karen Pinkney

Ontario, New York
Karen Pinkney
Karen Pinkney
General Member

Cynthia Pixley

Fredericksburg, Virginia
Pixels by Pixley Photography Available Services: Art, Black & White, Digital, Event or Show, Portrait.
Cynthia Pixley
General Member

Teresa Poplin

Teresa Poplin
General Member

Claire Porter

Austin, Texas
Claire Porter Photography
Claire Porter
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

Elizabeth Ruiz

Woodland, California
Artistic Equine Studios
Elizabeth Ruiz
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

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

Shelly Simpson

Ocala, Florida
ivegotyourpicture.com
Shelly Simpson
General Member

Kendra C Stone

Palestine, Texas
KCS Photography
Kendra C Stone
General Member

Kristina Truluck

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

Catherina Van Leeuwenkamp-Clarke

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

Ann Vassey

Winslow, Maine
AnnVasseyPhotography
Ann Vassey
General Member

Diana Volk

Sheridan, Wyoming
Diana Volk Photography
Diana Volk
General Member

Trudy Walden

Trudy Walden
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

Linda Wiesner

Milton, Ontario
Linda Wiesner Photography Available Services: Art, Photography Clinic, Digital, Farm, Portrait.
Linda Wiesner
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 - 287 of 287 members