Select Category
photographers
360° photographers
advertising photographers
aerial photographers
animal photographers
architecture photographers
beauty photographers
car photographers
children photographers
celebrity photographers
cgi/ 3d photographers
corporate & industrial photographers
documentary photographers
fashion photographers
fine art photographers
food & drink photographers
interiors & exteriors photographers
landscape photographers
lingerie & swimwear photographers
liquid photographers
marine photographers
music photographers
people & lifestyle photographers
portrait photographers
resort photographers
sports photographers
still life photographers
travel photographers
underwater photographers
* new talents
photo agents
photo production
photo assistants
digital tech assistants
cgi 3d rendering
post production
colour management
creative post production
digital printing
lenticular printing
matte painting
photolabs
retouching
2d compositing
rental studios
equipment rent
camera/ accessories photography
digital capture service
lighting/ electrical material
mobile units/ location vans
production rentals
underwater equipment
equipment dealer
digital capture
photo library stock
portfolios
film production
commercials production
tv/ video production
music video production
movie production
internet production
animation production
corporate film production
documentary production
making of production
film post production
editing
2d compositing
cgi & 3d
colour grading
digital capture
duplicates/ transfers
dvd authoring
special effects
laboratories film
matte painting
motion graphics
subtitling/ transcriptions
visual effects
vfx & production consulting
sound and music
music composers
sound design/ scoring
sound/ music recording studios
sound tracks/ dubbing
voice over agencies
voice over artists
equipment rent film
avid rental
camera/ accessories cinema
camera/ accessories video
camera car
crane/ hot head/ travelling
high definition
lighting/ grip equipment
mobile units/ location vans
sound equipment
steadicam
underwater equipment
production supply film
expendables
production rentals
rental studios film
directors
film
fashion film
short film
tv
documentary
music videos
internet videos
making of
commercials / advertising directors
commercials / animal directors
commercials / animation directors
commercials / beauty/ fashion directors
commercials / car directors
commercials / comedy directors
commercials / food directors
commercials / hair directors
commercials / kids directors
commercials / live action directors
commercials / special effects directors
commercials / sport directors
commercials / table top
commercials / testimonials/ real people directors
commercials / visual directors
directors' reps
dop
dop agents
steadicam operators
film library
associations
locations
location service and scouts
lofts and houses
rental studios photo
rental studios film
hotels
other locations
models, actors, casting
fashion models
people models
children models
senior models
sport models
plus size models
actors
celebrities
casting agencies
casting directors
dancers
trained animals casting
styling, hair, makeup
styling, hair and make up agents
hair and make up artists
special effects make up
fashion stylists
fashion stills stylists
food stylists / home economists
props, furnishing, interior stylists
product stills stylists
styling, hair and make up assistants
special effects/ silicone & make up
illustration
illustrators' agents
illustrators
3d illustrators
creativity
advertising agencies
animators
art buyers
art direction
branding
costume designers
design companies
digital creative services
fashion communication
fashion designers
graphic design
marketing services
photo editing
storyboard
tailor/ seamstress
web design
digital artists
service
aerial services
action cars
car prep
car rental
car transportation
computer
customs clearance
framing
mobile units/ location vans
model makers
precision drivers
props/ furnishing
set/ scenery construction
set/ scenery design
special effects/ mechanic
special effects/ fireworks
trained animals
travel agencies
wardrobe
catering
event production
event production
event management
venues
hotels and apartments
hotels
apartments
associations & events
hotel associations
event associations
advertising events
media associations
art events
fashion events
film events
music & multimedia events
photo events
creative associations
photo associations
Worldwide
Anguilla (2)
Argentina (146)
Australia (123)
Austria (55)
Barbados (Caribbean) (1)
Belarus (5)
Belgium (147)
Brazil (138)
Canada (134)
Cape Verde (1)
Chile (68)
China (132)
Colombia (4)
Costa Rica (1)
Croatia (1)
Cuba (2)
Cyprus (2)
Czech Republic (119)
Denmark (75)
Finland (2)
France (211)
Germany (654)
Greece (11)
Hungary (79)
Iceland (1)
India (101)
Indonesia (1)
Ireland (40)
Israel (2)
Italy (197)
Jamaica (2)
Japan (3)
Kazakhstan (1)
Latvia (1)
Lithuania (2)
Malaysia (1)
Mexico (102)
Morocco (6)
Mozambique (1)
Netherlands (92)
New Zealand (52)
Nicaragua (1)
Norway (2)
Peru (2)
Poland (76)
Portugal (73)
Russia (111)
Saint Martin (Caribbean) (3)
Saint-Barthélemy (Caribbean) (3)
Serbia (1)
Singapore (72)
Slovakia (7)
Slovenia (6)
South Africa (117)
Spain (334)
Sweden (87)
Switzerland (168)
Thailand (3)
Trinidad and Tobago (Caribbean) (1)
Turkey (121)
Turks and Caicos Islands (1)
United Arab Emirates (5)
United Kingdom (605)
United States (1112)
Uruguay (58)
Vietnam (1)
Zanzibar (1)
All Cities
SELECT ID, Name, COUNT(*) total FROM (SELECT DISTINCT cc.ID, cc.Name, COUNT(*) total FROM pp_countries co INNER JOIN pp_clients c ON c.CountryID = co.ID AND c.isCustomer = 1 INNER JOIN pp_invoices i ON i.ClientID = c.ID INNER JOIN pp_listing_details ld ON ld.ClientID = c.ID AND ld.StatusID != 4 INNER JOIN pp_listing l ON l.InvoiceID = i.ID AND l.ListingTypeID > 1 AND l.Ignore != 1 INNER JOIN pp_x_clients_categories x ON x.ClientID = c.ID INNER JOIN pp_cities cc ON c.CityID = cc.ID AND (cc.isShownInSearch =1 OR cc.isShownFrontEnd =1 OR cc.ID =9) GROUP BY c.Name, cc.ID) as zemba GROUP BY Name
Aarhus (2)
Aix-en-Provence (1)
Alicante (1)
Almaty (1)
Almeria (1)
Amsterdam (92)
Anguilla (2)
Antwerp (3)
Athens (9)
Atlanta (7)
Auckland (41)
Austin, TX (2)
Baltimore (1)
Bangalore (1)
Bangkok (1)
Barbados (1)
Barcelona (208)
Baroda (1)
Bayreuth (1)
Beijing (58)
Belfast (1)
Belgrade (1)
Belo Horizonte (2)
Berlin (174)
Biarritz (1)
Birmingham, AL (1)
Bodrum (2)
Bogota (4)
Bologna (1)
Boston (4)
Bratislava (7)
Bremen (1)
Brussels (145)
Budapest (79)
Buenos Aires (143)
Cagliari, Sardinia (1)
Calgary (1)
Canobbio (1)
Cape Town (117)
Chicago (148)
Christchurch (4)
Cleveland, OH (1)
Cologne (11)
Colorado Springs (1)
Columbus (1)
Copenhagen (73)
Corfu (1)
Dallas (25)
Denver (59)
Detroit (1)
Dresden (1)
Dubai (5)
Dublin (39)
Dubrovnik (1)
Dusseldorf (95)
Edinburgh (4)
Eichenzell (1)
Faro (1)
Florence (6)
Fort Laurerdale, FL (1)
Frankfurt (17)
Geneve (1)
Gothenburg (3)
Granada (1)
Graz (1)
Hamburg (220)
Hanover (2)
Havana (2)
Hawaii (2)
Helsinki (2)
Ho Chi Minh (1)
Hollywood (1)
Hong Kong (6)
Honolulu, Hi (1)
Houston (5)
Höchst (1)
Ibiza (20)
Istanbul (119)
Jaipur (1)
Jakarta (1)
Jodhpur (1)
Kansas City (1)
Kingston (2)
Kuala Lumpur (1)
Las Palmas G.C. (2)
Las Vegas (3)
Lausanne (1)
Lima (2)
Lisbon (71)
Ljubljana (6)
London (604)
Los Angeles (210)
Madrid (82)
Malaga (2)
Mallorca (44)
Manchester (1)
Maputo (1)
Marktheidenfeld (1)
Marrakech (5)
Marseille (1)
Melbourne (3)
Mendoza (3)
Menorca (4)
Messina, Sicily (2)
Mexico City (100)
Miami (239)
Milan (130)
Milwaukee, WI (1)
Minneapolis (6)
Minsk (5)
Montevideo (58)
Moscow (109)
Mumbai (94)
Munich (154)
Naples (4)
Nashville (1)
Natal (1)
New Delhi (12)
New Orleans (2)
New York (307)
Nice (1)
Nicosia (3)
Novosibirsk (1)
Nuremberg (5)
Ocotal (1)
Olbia, Sardinia (1)
Orlando, FL (2)
Oslo (2)
Paris (207)
Philadelphia (3)
Phoenix (5)
Phuket (2)
Playa del Carmen (3)
Ponta do Sol (1)
Port of Spain (1)
Portland, OR (2)
Porto Alegre (2)
Prague (119)
Praia (Cape Verde) (1)
Queenstown (5)
Recife (1)
Reykjavik (1)
Riga (1)
Rio de Janeiro (46)
Rome (64)
Saint Martin (3)
Saint Petersburg, FL (6)
Saint-Barthélemy (3)
Salt Lake City, UT (6)
Salvador de Bahia (1)
San Diego (2)
San Francisco (122)
San Jose (1)
San Sebastian (1)
Santa Fe, NM (2)
Santa Monica (1)
Santiago de Chile (68)
Sao Paulo (93)
Scottsdale, AZ (3)
Seattle (9)
Seville (3)
Shanghai (71)
Singapore (73)
Sintra (1)
Sitges (2)
St. Louis, MO (1)
Stockholm (84)
Stone Town (1)
Stuttgart (18)
Sydney (122)
Tel Aviv (2)
Tenerife (4)
Thessaloniki (1)
Tokyo (3)
Toronto (128)
Toulouse (1)
Tulsa, OK (2)
Tulum (1)
Turks and Caicos Islands (1)
Valencia (2)
Vancouver (5)
Venice (3)
Vienna (52)
Vilnius (2)
Warsaw (75)
Washington D.C. (14)
Wellington (1)
Wiesbaden (1)
Wroclaw (1)
Zell Am See (1)
Zurich (166)
