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 100, 50-241

Member Directory

Filters:
Assistants List
Rescue Photos
Pro Member

Chelsea Tracy

Chesapeake, Virginia
Chelsea Tracy Photography Available Services: Art, Black & White, Photography Clinic, Digital, Event or Show, Editorial, Farm, Merchandise, Portrait.
Chelsea Tracy
Pro Member

Scott Trees

Tryon, North Carolina
Scott Trees Photography Available Services: Art, Advertising & Commercial, Black & White, Photography Clinic, Digital, Editorial, Farm, Merchandise, Portrait, Race, Stock, Video.
Scott Trees
Pro Member

Aubray Vande Corput

Seymour, Wisconsin
Copper Arrow Photography Available Services: Art, Advertising & Commercial, Black & White, Event or Show, Editorial, Farm, Portrait, Stock.
Aubray Vande Corput
Pro Member

Robin Wadhams

Hotchkiss, Colorado
Robin Wadhams Photography Available Services: Art, Black & White, Event or Show, Farm.
Robin Wadhams
Pro Member

Carol Walker

Longmont, Colorado
Living Images by Carol Walker, LLC Available Services: Art, Advertising & Commercial, Black & White, Digital, Editorial, Farm, Merchandise, Portrait, Stock.
Carol Walker
Pro Member

Kimberly Wallace

Boerne, Texas
Haven Creek Photography Available Services: Art, Black & White, Digital, Farm, Portrait.
Kimberly Wallace
Pro Member

Carrie Washburn

Carbondale, Colorado
Carrie Cathleen Photography Available Services: Art, Advertising & Commercial, Black & White, Digital, Event or Show, Editorial, Farm, Merchandise, Portrait, Stock.
Carrie Washburn
Pro Member

Lea Watson

Aubrey, Texas
Lea Sage Watson Available Services: Art, Advertising & Commercial, Photography Clinic, Digital, Farm, Graphic Design, Portrait, Video.
Lea Watson
Pro Member

Cindy Westerlund

McDonald, Pennsylvania
Cindy West Photography Available Services: Art, Black & White, Digital, Editorial, Portrait.
Cindy Westerlund
Pro Member

Lindsey Williams

Rocky Mount, North Carolina
LifeExposed: Photos by Lindsey Available Services: Art, Advertising & Commercial, Black & White, Digital, Editorial, Farm, Portrait, Stock.
Lindsey Williams
Pro Member

Catherine Willis

Fuente Alamo de Murcia,, Spain
Swingletree Photography Available Services: Art, Advertising & Commercial, Black & White, Digital, Event or Show, Editorial, Farm, Merchandise, Portrait, Stock.
Catherine Willis
Pro Member

Darlene Wohlart

Ocala, Florida
Darlene Wohlart Photography Available Services: Art, Advertising & Commercial, Black & White, Digital, Editorial, Farm, Merchandise, Portrait, Stock.
Darlene Wohlart
Pro Member

Brandy Yi

La Crescenta, California
Brandy Yi Equine Photography
Brandy Yi
Pro Member

Emma Ziff

London, United Kingdom
Emma Ziff Photography Available Services: Art, Photography Clinic, Portrait.
Emma Ziff
Associate Pro Member

Jill Brammer

Jupiter, Florida
Jill Brammer Photography Available Services: Art, Advertising & Commercial, Black & White, Digital, Editorial, Farm, Portrait, Stock.
Jill Brammer
Associate Pro Member

Bethani Chadbourne

South Grafton, Massachusetts
Pictorial Tales by Bethani Available Services: Art, Advertising & Commercial, Digital, Editorial, Farm, Portrait.
Bethani Chadbourne
Associate Pro Member

Ellen L Chappell

Albany, Oregon
Ellen L Chappell Photography Available Services: Art, Advertising & Commercial, Black & White, Digital, Event or Show, Farm, Portrait.
Ellen L Chappell
Associate Pro Member

Bridgette Daugherty

Berkeley Springs, West Virginia
Blaze Horse Photography LLC Available Services: Art, Portrait.
Bridgette Daugherty
Associate Pro Member

Kate Hall

Alexandria, Virginia
Aster Equine Photography LLC
Kate Hall
Associate Pro Member

Jackie Harris

Hookstown, Pennsylvania
Roam Photos Available Services: Art, Advertising & Commercial, Black & White, Digital, Editorial, Farm, Portrait.
Jackie Harris
Associate Pro Member

Carol Hill

Canton, New York
C A Hill Photo Available Services: Digital, Event or Show, Farm, Portrait.
Carol Hill
Associate Pro Member

Linda Kremer

Gauting, Germany
Linda Kremer
Associate Pro Member

Mary Ellen Moore

Clinton Corners, New York
memoorephotography Available Services: Art, Black & White, Event or Show, Farm, Portrait.
Mary Ellen Moore
Associate Pro Member

Molly Morris

San Luis Obispo, California
Molly Virginia Morris Photography Available Services: Advertising & Commercial, Event or Show, Portrait.
Molly Morris
General Member

Sue Abbott

Dereham, United Kingdom
SueAbbottEquestrianPhotography
Sue Abbott
General Member

Marian Adoranti

Hamilton, Ontario
Marian Adoranti Photography Available Services: Art, Portrait.
Marian Adoranti
General Member

Heather Astley

Norfolk, Massachusetts
Heather Astley
General Member

Max Bailey

Richmond, Indiana
Max Bailey Photography Available Services: Event or Show, Portrait.
Max Bailey
General Member

Karen Bayerl

Pittsville, Wisconsin
Karen Bayerl
General Member

Laura Berard

Carmichael, California
Laura Berard
General Member

Morgan Billings

Spring Hill, Tennessee
Mane Memories Photography Available Services: Black & White, Digital, Farm, Portrait.
Morgan Billings
General Member

Diane Bliessen

Kreuzau, Germany
Available Services: Art, Advertising & Commercial, Black & White, Digital, Event or Show, Editorial, Farm, Portrait.
Diane Bliessen
General Member

Maria Borkowski

Watford City, North Dakota
We Three B's Available Services: Art, Advertising & Commercial, Black & White, Photography Clinic, Digital, Event or Show, Farm, Portrait.
Maria Borkowski
General Member

Sheila Brauning

Allen, Texas
Sheila Brauning Photography Available Services: Portrait.
Sheila Brauning
General Member

Sharon Buchanan

Simpson, Illinois
Sharon Buchanan
General Member

Janet Chanay

Dolores, Colorado
JEchanay photographs
Janet Chanay
General Member

Christine Charron

Christine Charron
General Member

Jillian Chilson

Richmond, Virginia
Jills FotoLuv
Jillian Chilson
General Member

Lyn Clark

Casper, Wyoming
Lyn Clark
General Member

Gretchen Clark

Phoenix, Arizona
Gretchen Clark
General Member

Lisa Cohen

Ridgefield, Connecticut
Silver Mountain Studio Available Services: Art, Advertising & Commercial, Black & White, Digital, Event or Show, Editorial, Farm, Portrait.
Lisa Cohen
General Member

Joanne Collins

Salem, Oregon
Joanne Collins
General Member

Kathy Colman

Truckee, California
Kathy Colman Photography
Kathy Colman
General Member

sarah Connaughton

East Aurora, New York
sarah Connaughton
General Member

Sarah Corbin

New York, New York
Corbinart Available Services: Art, Black & White, Digital.
Sarah Corbin
General Member

Anne Corder

Martinez, California
Anne Corder
General Member

Diane Costello

Half Moon Bay, California
Fog Dog Studios
Diane Costello
General Member

Lisa Cover

Ardmore, Oklahoma
Circle 2 Images
Lisa Cover
General Member

Randall Crew

Lamoni, Iowa
Available Services: Portrait.
Randall Crew
General Member

Lisa Cueman

Dorset, Vermont
lisa cueman photography
Lisa Cueman
showing 101 - 150 of 241 members