Select Category
photographers
advertising photographers
animal photographers
architecture photographers
beauty photographers
car photographers
children photographers
celebrity photographers
cgi/ 3d photographers
documentary photographers
fashion photographers
food & drink photographers
interiors & exteriors photographers
landscape photographers
lingerie photographers
music
people & lifestyle photographers
portrait photographers
product & corporate photographers
sport photographers
still life photographers
travel photographers
underwater 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
underwater equipment
equipment dealer
digital capture
photo library/stock
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/ electrical material
mobile units/ location vans
sound equipment
steadicam
underwater equipment
associations
equipment dealer film
expendables
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' agents
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
bars and nightclubs
models/casting/actors
fashion models
people models
children models
senior models
sport models
plus size models
actors
celebrities
casting agencies
casting directors
associations
makeup/hair/styling
styling, hair and make up agents
hair and make up artists
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
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
production supply/rentals
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 (122)
Australia (69)
Austria (4)
Belgium (184)
Brazil (95)
Canada (6)
Cape Verde (1)
China (55)
Colombia (1)
Costa Rica (1)
Croatia (2)
Cuba (2)
Curacao (1)
Cyprus (1)
Czech Republic (110)
Denmark (2)
Dominican Republic (1)
France (125)
Germany (639)
Greece (3)
Hungary (2)
India (67)
Ireland (1)
Israel (1)
Italy (64)
Jamaica (1)
Japan (2)
Lithuania (1)
Malaysia (1)
Mauritius (1)
Mexico (71)
Morocco (2)
Mozambique (1)
Netherlands (103)
New Zealand (7)
Nicaragua (1)
Peru (2)
Poland (63)
Portugal (70)
Romania (1)
Russia (114)
Slovakia (6)
Slovenia (4)
South Africa (63)
Spain (269)
Sweden (3)
Switzerland (156)
Thailand (1)
Turkey (95)
United Arab Emirates (1)
United Kingdom (370)
United States (411)
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)
Almeria (1)
Alpujarras (1)
Amsterdam (102)
Antwerp (1)
Athens (3)
Atlanta (1)
Auckland (3)
Bangkok (1)
Barcelona (231)
Baroda (1)
Beijing (49)
Belo Horizonte (1)
Bergheim (1)
Berkeley (1)
Berlin (143)
Beverly Hills (1)
Bodrum (1)
Bogota (1)
Boston (2)
Bratislava (6)
Brussels (183)
Bucharest (1)
Budapest (2)
Buenos Aires (122)
Cadiz (1)
Cagliari, Sardinia (1)
Cape Town (63)
Chicago (127)
Christchurch (1)
Cologne (8)
Copenhagen (2)
Curitiba (1)
Dallas (1)
Dubai (1)
Dublin (1)
Dubrovnik (1)
Dusseldorf (80)
Edinburgh (3)
Eichenzell (1)
Faro (1)
Florence (1)
Fortaleza (1)
Frankfurt (6)
Geneve (1)
Göppingen (1)
Hamburg (203)
Havana (2)
Hollywood (1)
Hong Kong (3)
Ibiza (1)
International (1)
Istanbul (94)
Jaipur (1)
Jenkinstown (1)
Jodhpur (1)
Karlsruhe (1)
Kingston (1)
Kuala Lumpur (1)
Las Palmas G.C. (1)
Lima (2)
Lisbon (69)
Ljubljana (4)
London (368)
Los Angeles (14)
Lübeck (1)
Madrid (58)
Malaga (2)
Manchester (1)
Maputo (1)
Marrakech (2)
Marseille (2)
Melbourne (1)
Mexico City (69)
Miami (71)
Milan (60)
Montevideo (57)
Montpellier (1)
Moscow (114)
Mumbai (66)
Munich (192)
Naples (1)
Natal (1)
Neu-Anspach (1)
New Delhi (1)
New York (190)
Nice (1)
Nicosia (1)
Nueremberg (1)
Ocotal (1)
Olbia (1)
Palma de Mallorca (4)
Paris (120)
Playa del Carmen (2)
Port Louis (1)
Porto Alegre (2)
Prague (110)
Praia (Cape Verde) (1)
Punta del Este (1)
Queenstown (1)
Recife (1)
Rio de Janeiro (43)
Salvador de Bahia (1)
San Diego (2)
San Francisco (3)
San Jose (1)
Santa Monica (2)
Santo Domingo (1)
Sao Paulo (49)
Scottsdale, AZ (1)
Seattle (1)
Shanghai (3)
Sintra (1)
Stockholm (3)
Stone Town (1)
Stuttgart (8)
Sydney (69)
Tel Aviv (1)
Tenerife (3)
Tokyo (2)
Toronto (5)
Toulouse (1)
Turin (1)
Utrecht (1)
Vancouver (1)
Vienna (3)
Viernheim (1)
Vilnius (1)
Wahlwies (1)
Warsaw (62)
Wellington (2)
Wiesbaden (1)
Willemstad (1)
Wroclaw (1)
Zagreb (1)
Zell Am See (1)
Zurich (155)
