No type found

query
RESULTSET
query
  ABADVERTISERTYPEID FRIENDLYNAME NAME
1 30053 trade-services Trade Services
2 30054 photographers Photographers
3 30056 schools-pre-play-centres-and-playgroups Schools - Pre, Play Centres & Playgroups
4 30057 high-schools High Schools
5 30058 colleges Colleges
6 30059 after-school-activities After School Activities
7 30061 educational-resource Educational Resource
8 30063 clothing-accessories Clothing Accessories
9 30064 lingerie-and-undergarments Lingerie and Undergarments
10 30065 shoes-and-footwear Shoes and Footwear
11 30066 gift-ideas-and-bomboniere Gift Ideas and Bomboniere
12 30069 food-caterers Food Caterers
13 30070 civil-celebrants Civil Celebrants
14 30073 travel-and-accommodation Travel & Accommodation
15 30076 bands-duos-and-soloist Bands, Duo's and Soloist
16 30077 reception-venues-and-halls-for-hire Reception Venues and Halls for Hire
17 30079 stationery-invitations Stationery - Invitations
18 30082 babysitters-and-child-care Babysitters & Child Care
19 30084 family-planning-and-resource-centres Family Planning & Resource Centres
20 30085 schools-outside-activities Schools - Outside Activities
21 30086 schools-primary Schools - Primary
22 30087 schools-high-secondary Schools - High, Secondary
23 30088 university-college-academy-other University/College/Academy - Other
24 30250 restaurant-and-cafes Restaurant & Cafes
25 30308 household-products Household Products
26 30352 tourism-travel-and-accommodation Tourism, Travel & Accommodation
27 30353 child-services Child Services
28 30354 pet-services Pet Services
29 30356 student-services Student Services
30 30357 senior-services Senior Services
31 30387 other-contact-us Other (Contact Us)
32 30388 accessories-lingerie-and-shoes Accessories, Lingerie & Shoes
33 30389 formal-dresses-and-bridal-gowns Formal Dresses and Bridal Gowns
34 30390 bomboniere-and-wedding-favors Bomboniere and Wedding Favors
35 30391 cakes Cakes
36 30392 marriage-celebrants-civil Marriage Celebrants (Civil)
37 30393 caterers Caterers
38 30394 florist Florist
39 30396 hair-makeup-beauty-health-and-fitness Hair, Makeup, Beauty, Health & Fitness
40 30397 hens-and-bucks-nights Hens & Bucks Nights
41 30398 honeymoon-and-travel Honeymoon & Travel
42 30399 entertainment-mcs-bands-duos-and-soloists Entertainment - MCs,Bands,Duo's & Soloists
43 30400 photography Photography
44 30401 reception-venues-and-halls-for-hire-1 Reception Venues & Halls For Hire 1
45 30402 specialised-services-and-unique-ideas Specialised Services and Unique Ideas
46 30403 stationery-and-invitations Stationery and Invitations
47 30404 transport-limousine-and-car-hire Transport, Limousine and Car Hire
48 30405 videography-and-dvd-specialists Videography and DVD Specialists
49 30406 event-planners Event Planners
50 30407 churches Churches
51 30408 jewellery-and-wedding-rings Jewellery and Wedding Rings
52 30409 party-decorations-and-hire Party, Decorations and Hire
53 30410 health-and-fitness-training Health & Fitness Training
54 30412 household-furniture Household Furniture
55 30413 entertainment-djs-sound-and-lighting Entertainment - DJs, Sound & Lighting
56 30414 bridal-dance-classes Bridal Dance Classes
57 30415 garden-locati8ons-vineyards-and-golf-club-weddings Garden Locati8ons, Vineyards & Golf Club Weddings
58 30707 wedding-services Wedding Services
CACHED false
EXECUTIONTIME 0
SQL select abAdvertiserTypeID, Name, '' AS FriendlyName from abAdvertiserType where CompanyCode = 'ADS'
query
RESULTSET
query
  ABADVERTISERTYPEID FRIENDLYNAME NAME
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM application.friendlyServices WHERE FriendlyName LIKE 'accessories-lingerie-shoes'