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 200, 50-247

Member Directory

Filters:
Assistants List
Rescue Photos
General Member

Curt McAdams

Waynesville, Ohio
Livefire Photography
Curt McAdams
General Member

Somer McCain

Estes Park, Colorado
Somer McCain
General Member

Ron McCarthy

Surrey, British Columbia
Ron McCarthy
General Member

Susan McClafferty

Boyce, Virginia
Mareish Media LLC Available Services: Art.
Susan McClafferty
General Member

Priscilla Miller

Bernardsville, New Jersey
P K Miller Photography Available Services: Digital, Editorial, Farm, Portrait, Race, Stock.
Priscilla Miller
General Member

Samantha Mirzaee

Ottawa, Ontario
Samantha Mirzaee Photography Available Services: Art, Advertising & Commercial, Black & White, Digital, Event or Show, Editorial, Portrait, Race, Stock.
Samantha Mirzaee
General Member

Jane Mitchell

West Nyack, New York
Jane Mitchell Photography
Jane Mitchell
General Member

Nancy Mitchell

Bellevue, Washington
Nancy Mitchell Photography Available Services: Art, Black & White, Digital, Event or Show, Farm, Portrait, Race.
Nancy Mitchell
General Member

Elizabeth Monaghan

Campvelville, Ontario
Grand Elizabethan Equine
Elizabeth Monaghan
General Member

Jeanne Morency

Middleburg, Virginia
Jeanne Morency
General Member

Denise Nelson

Gray, Tennessee
Denise Nelson's Photography
Denise Nelson
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

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

Dawn Pontz

Collingswood, New Jersey
Signature Studio
Dawn Pontz
General Member

Teresa Poplin

Teresa Poplin
General Member

Claire Porter

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

Jane Roybal

Lewistown, Montana
Spirit Horse
Jane Roybal
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

Heather Sacha

Heather Sacha
General Member

Amanda Sanders

Louisville, Kentucky
Bluegrass Girl Photography Available Services: Art, Event or Show, Farm, Portrait.
Amanda Sanders
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

Kathy Sherbert

Kathy Sherbert
General Member

Shelly Simpson

Ocala, Florida
ivegotyourpicture.com Available Services: Art, Digital, Event or Show, Farm, Portrait.
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

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
General Member

Svatia Zaplatilova

Brno, Czech Republic
SZFoto Available Services: Art, Advertising & Commercial, Photography Clinic, Event or Show, Portrait, Stock, Video.
Svatia Zaplatilova
showing 201 - 247 of 247 members