Select Category
photographers
advertising 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 photographers
music photographers
people & lifestyle photographers
portrait photographers
sports photographers
still life photographers
travel photographers
underwater photographers
marine photographers
* new talents
photo agents
photo assistants
photo production
cgi 3d rendering
post production
colour management
creative post production
photolabs
retouching
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
online portfolios
portfolios
photo galleries
photo associations
film production
commercial production
tv/ video production
music video production
movie production
internet production
animation production
film post production
editing
2d compositing
cgi & 3d
colour grading
digital capture
duplicates/ transfers
dvd authoring
special effects
laboratories film
motion graphics
sound design/scoring
sound/ music recording studios
sound tracks/ dubbing
subtitling/ transcriptions
voice over agencies
equipment rent film
avid rental
camera/ accessories cinema
camera/ accessories video
camera car
crane/ hot head/ travelling
earth/ satellite links
high definition
lighting/ grip equipment
mobile units/ location vans
sound equipment
steadicam
underwater equipment
associations
production supply film
expendables
production rentals
tapes/ film stock
rental studios film
directors
film
short film
tv
documentary
music videos
internet video
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 / testimonials/ real people directors
commercials / visual directors
directors' reps
dop
dop agents
film library
associations
production
locations
location service and scouts
lofts and houses
rental studios photo
rental studios film
hotels
office rentals
other locations
restaurants, bars, nightclubs
models actors casting
fashion models
people models
children models
senior models
sport models
plus size models
actors
celebrities
casting agencies
casting directors
dancers
associations
trained animals
makeup hair styling
styling, hair and make up agents
hair and make up artists
fashion stylists
food stylists / home economists
interiors / still life styling
special effects make up
illustration
illustrators' agents
illustrators
creativity
advertising agencies
animators
art buyer
art direction
branding
copywriter
costume designer
design companies
digital creative services
fashion communication
fashion designer
graphic design
marketing services
packaging
storyboard
tailor/ seamstress
voice over artists
web design
associations and related links
service
action cars
car prep
car rental
cleaning
computer
customs clearance
flowers
installations & audiovisual engineering
insurance
massages
messengers
mobile units/ location vans
model makers
office equipment rental
office rentals
portable flooring/ decking
portable wc
precision drivers
props/ furnishing
security
sets/ stages
set/ scenery construction
set/ scenery design
special effects/ mechanic
special effects/ silicone & make up
special effects/ fireworks
trained animals
translation/interpretation
travel agencies
walkie talkies rental
wardrobe
mobile telephone service
media
book publishers
directories
magazines
newspapers
tv stations
associations and related links
event
event production
event management
event facilities
advertising events
fashion events
film events
music & multimedia events
photo events
art events
associations and related links
hotel
hotels
apartments
associations and related links
food
catering
restaurants
night
bars and nightclubs
info
Worldwide
Argentina (116)
Australia (79)
Austria (5)
Belarus (5)
Belgium (211)
Brazil (83)
Canada (7)
Cape Verde (1)
China (55)
Colombia (1)
Costa Rica (2)
Croatia (2)
Cuba (2)
Cyprus (1)
Czech Republic (110)
Denmark (3)
Dominican Republic (1)
France (144)
Germany (582)
Greece (3)
Hungary (8)
India (75)
Ireland (1)
Israel (1)
Italy (68)
Jamaica (1)
Japan (2)
Kazakhstan (1)
Lithuania (1)
Malaysia (1)
Mauritius (1)
Mexico (76)
Morocco (2)
Mozambique (1)
Netherland Antilles (1)
Netherlands (105)
New Zealand (8)
Nicaragua (1)
Peru (2)
Poland (67)
Portugal (72)
Romania (1)
Russia (121)
Serbia (1)
Singapore (1)
Slovakia (6)
Slovenia (4)
South Africa (73)
Spain (254)
Sweden (2)
Switzerland (162)
Thailand (1)
Turkey (100)
United Arab Emirates (1)
United Kingdom (379)
United States (542)
Uruguay (58)
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
Aachen (1)
Almaty (1)
Almeria (1)
Alpujarras (1)
Amsterdam (104)
Antwerp (1)
Athens (3)
Atlanta (2)
Auckland (4)
Bangkok (1)
Barcelona (214)
Baroda (1)
Beijing (49)
Belgrade (1)
Belo Horizonte (1)
Bergheim (1)
Berlin (144)
Beverly Hills (1)
Bodrum (1)
Bogota (1)
Boston (2)
Bratislava (6)
Brussels (210)
Bucharest (1)
Budapest (8)
Buenos Aires (116)
Cadiz (1)
Cagliari, Sardinia (1)
Cape Town (73)
Chicago (131)
Christchurch (1)
Cologne (9)
Copenhagen (3)
Curitiba (1)
Dubai (1)
Dublin (1)
Dubrovnik (1)
Dusseldorf (97)
Edinburgh (3)
Eichenzell (1)
Faro (1)
Florence (2)
Frankfurt (5)
Geneve (1)
Graz (1)
Göppingen (1)
Hamburg (183)
Havana (2)
Hollywood (1)
Hong Kong (3)
Ibiza (1)
International (1)
Istanbul (99)
Jaipur (1)
Jenkinstown (1)
Jodhpur (1)
Karlsruhe (1)
Kingston (1)
Kuala Lumpur (1)
Las Palmas G.C. (1)
Lima (2)
Lisbon (71)
Ljubljana (4)
London (378)
Los Angeles (23)
Lübeck (1)
Madrid (52)
Malaga (5)
Manchester (1)
Maputo (1)
Marrakech (2)
Marseille (1)
Melbourne (2)
Mexico City (74)
Miami (162)
Milan (64)
Minsk (5)
Montevideo (57)
Montpellier (1)
Moscow (121)
Mumbai (74)
Munich (135)
Naples (1)
Natal (1)
Neu-Anspach (1)
New Delhi (1)
New York (229)
Nice (1)
Nicosia (1)
Nueremberg (1)
Ocotal (1)
Olbia (1)
Palma de Mallorca (5)
Paris (141)
Philadelphia (1)
Playa del Carmen (2)
Port Louis (1)
Porto Alegre (2)
Prague (110)
Praia (Cape Verde) (1)
Punta del Este (1)
Queenstown (2)
Recife (1)
Rio de Janeiro (39)
Salvador de Bahia (1)
San Diego (2)
San Francisco (5)
San Jose (2)
Santa Monica (2)
Santo Domingo (1)
Sao Paulo (42)
Scottsdale, AZ (1)
Seattle (2)
Shanghai (3)
Singapore (1)
Sintra (1)
Stockholm (2)
Stone Town (1)
Stuttgart (10)
Sydney (78)
Tel Aviv (1)
Tenerife (4)
Tokyo (2)
Toronto (5)
Turin (1)
Utrecht (1)
Valencia (1)
Vancouver (2)
Vienna (3)
Viernheim (1)
Vilnius (1)
Wahlwies (1)
Warsaw (66)
Wellington (2)
Wiesbaden (1)
Willemstad (1)
Wroclaw (1)
Zagreb (1)
Zell Am See (1)
Zurich (161)
