Symfony Profiler

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  place p0_

SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  place p0_
WHERE
  p0_.email IS NOT NULL
  AND p0_.email <> ''

SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '';

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  place p0_
WHERE
  p0_.email IS NULL
  OR p0_.email = ''

SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NULL OR p0_.email = '';

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  place p0_
WHERE
  p0_.email IS NOT NULL
  AND p0_.email <> ''
  AND (
    p0_.opted_out = 0
    OR p0_.opted_out IS NULL
  )
  AND (
    p0_.dead = 0
    OR p0_.dead IS NULL
  )

SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL);

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  place p0_
WHERE
  p0_.opted_out = 1

SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.opted_out = 1;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  place p0_
WHERE
  p0_.email IS NOT NULL
  AND p0_.email <> ''
  AND (
    p0_.opted_out = 0
    OR p0_.opted_out IS NULL
  )
  AND (
    p0_.dead = 0
    OR p0_.dead IS NULL
  )
  AND p0_.osm_data_date IS NOT NULL
  AND p0_.osm_data_date <= ?

SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= '2026-01-12 22:25:28';

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  place p0_
WHERE
  p0_.email IS NOT NULL
  AND p0_.email <> ''
  AND (
    p0_.opted_out = 0
    OR p0_.opted_out IS NULL
  )
  AND (
    p0_.dead = 0
    OR p0_.dead IS NULL
  )
  AND p0_.osm_data_date IS NOT NULL
  AND p0_.osm_data_date <= ?

SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= '2025-07-12 22:25:28';

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  place p0_
WHERE
  p0_.email IS NOT NULL
  AND p0_.email <> ''
  AND (
    p0_.opted_out = 0
    OR p0_.opted_out IS NULL
  )
  AND (
    p0_.dead = 0
    OR p0_.dead IS NULL
  )
  AND p0_.osm_data_date IS NOT NULL
  AND p0_.osm_data_date <= ?

SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= '2024-07-12 22:25:29';

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  place p0_
WHERE
  p0_.email IS NOT NULL
  AND p0_.email <> ''
  AND (
    p0_.opted_out = 0
    OR p0_.opted_out IS NULL
  )
  AND (
    p0_.dead = 0
    OR p0_.dead IS NULL
  )
  AND p0_.osm_data_date IS NOT NULL
  AND p0_.osm_data_date <= ?

SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= '2023-07-12 22:25:29';

SELECT
  1

SELECT 1;

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = 'public'
  AND table_name = 'osm_object_meta'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta';

SELECT
  COUNT(*) AS total,
  COUNT(*) FILTER (
    WHERE
      COALESCE(tags -> 'email', '') <> ''
      OR COALESCE(tags -> 'contact:email', '') <> ''
  ) AS with_email,
  COUNT(*) FILTER (
    WHERE
      COALESCE(tags -> 'phone', '') <> ''
      OR COALESCE(tags -> 'contact:phone', '') <> ''
  ) AS with_phone,
  COUNT(*) FILTER (
    WHERE
      COALESCE(tags -> 'website', '') <> ''
      OR COALESCE(tags -> 'contact:website', '') <> ''
      OR COALESCE(tags -> 'url', '') <> ''
      OR COALESCE(tags -> 'contact:url', '') <> ''
  ) AS with_website,
  COUNT(*) FILTER (
    WHERE
      COALESCE(tags -> 'opening_hours', '') <> ''
  ) AS with_opening_hours,
  COUNT(*) FILTER (
    WHERE
      (
        COALESCE(tags -> 'addr:street', '') <> ''
        AND COALESCE(tags -> 'addr:housenumber', '') <> ''
      )
      OR (
        COALESCE(tags -> 'contact:street', '') <> ''
        AND COALESCE(tags -> 'contact:housenumber', '') <> ''
      )
  ) AS with_address,
  COUNT(*) FILTER (
    WHERE
      COALESCE(tags -> 'ref:FR:SIRET', '') <> ''
  ) AS with_siret,
  COUNT(*) FILTER (
    WHERE
      COALESCE(tags -> 'wheelchair', '') <> ''
  ) AS with_wheelchair,
  COUNT(*) FILTER (
    WHERE
      (tags -> 'amenity') = ANY(
        ARRAY[ 'library',
        'townhall',
        'restaurant',
        'fast_food',
        'cafe',
        'fuel',
        'pharmacy',
        'bank',
        'bar',
        'hospital',
        'post_office',
        'clinic',
        'pub',
        'car_wash',
        'ice_cream',
        'driving_school',
        'cinema',
        'car_rental',
        'nightclub',
        'bureau_de_change',
        'studio',
        'internet_cafe',
        'money_transfer',
        'casino',
        'vehicle_inspection',
        'frozen_food',
        'boat_rental',
        'coworking_space',
        'workshop',
        'personal_service',
        'camping',
        'dancing_school',
        'training',
        'ski_school',
        'ski_rental',
        'dive_centre',
        'driver_training',
        'nursing_home',
        'funeral_hall',
        'doctors',
        'dentist',
        'theatre',
        'kindergarten',
        'language_school',
        'stripclub',
        'veterinary',
        'convenience',
        'supermarket',
        'clothes',
        'hairdresser',
        'car_repair',
        'bakery',
        'beauty',
        'car',
        'hardware',
        'mobile_phone',
        'butcher',
        'furniture',
        'car_parts',
        'alcohol',
        'florist',
        'scooter',
        'variety_store',
        'electronics',
        'shoes',
        'optician',
        'jewelry',
        'mall',
        'gift',
        'doityourself',
        'greengrocer',
        'books',
        'bicycle',
        'chemist',
        'department_store',
        'laundry',
        'travel_agency',
        'stationery',
        'pet',
        'sports',
        'confectionery',
        'tyres',
        'cosmetics',
        'computer',
        'tailor',
        'tobacco',
        'storage_rental',
        'dry_cleaning',
        'trade',
        'copyshop',
        'motorcycle',
        'funeral_directors',
        'beverages',
        'newsagent',
        'garden_centre',
        'massage',
        'pastry',
        'interior_decoration',
        'general',
        'deli',
        'toys',
        'houseware',
        'wine',
        'seafood',
        'pawnbroker',
        'tattoo',
        'paint',
        'wholesale',
        'photo',
        'second_hand',
        'bed',
        'kitchen',
        'outdoor',
        'fabric',
        'antiques',
        'coffee',
        'gas',
        'e-cigarette',
        'perfumery',
        'craft',
        'hearing_aids',
        'money_lender',
        'appliance',
        'electrical',
        'tea',
        'motorcycle_repair',
        'boutique',
        'baby_goods',
        'bag',
        'musical_instrument',
        'dairy',
        'pet_grooming',
        'music',
        'carpet',
        'rental',
        'fashion_accessories',
        'cheese',
        'chocolate',
        'medical_supply',
        'leather',
        'sewing',
        'cannabis',
        'locksmith',
        'games',
        'video_games',
        'hifi',
        'window_blind',
        'caravan',
        'tool_hire',
        'household_linen',
        'bathroom_furnishing',
        'shoe_repair',
        'watches',
        'nutrition_supplements',
        'fishing',
        'erotic',
        'frame',
        'grocery',
        'boat',
        'repair',
        'weapons',
        'gold_buyer',
        'lighting',
        'pottery',
        'security',
        'groundskeeping',
        'herbalist',
        'curtain',
        'health_food',
        'flooring',
        'printer_ink',
        'anime',
        'camera',
        'scuba_diving',
        'candles',
        'printing',
        'garden_furniture',
        'food',
        'estate_agent',
        'insurance',
        'it',
        'accountant',
        'employment_agency',
        'tax_advisor',
        'financial',
        'advertising_agency',
        'logistics',
        'newspaper',
        'financial_advisor',
        'consulting',
        'travel_agent',
        'coworking',
        'moving_company',
        'lawyer',
        'architect',
        'construction_company',
        'credit_broker',
        'graphic_design',
        'property_management',
        'cleaning' ] :: text[]
      )
  ) AS cat_amenity,
  COUNT(*) FILTER (
    WHERE
      exist(tags, 'shop')
      AND COALESCE(tags -> 'shop', '') NOT ILIKE '%vacant%'
      AND COALESCE(tags -> 'shop', '') <> ''
  ) AS cat_shop,
  COUNT(*) FILTER (
    WHERE
      (tags -> 'tourism') = ANY(
        ARRAY[ 'hotel', 'hostel', 'motel',
        'wilderness_hut', 'yes', 'chalet',
        'gallery', 'guest_house', 'museum',
        'zoo', 'theme_park', 'aquarium',
        'alpine_hut', 'apartment' ] :: text[]
      )
  ) AS cat_tourism,
  COUNT(*) FILTER (
    WHERE
      exist(tags, 'healthcare')
      AND COALESCE(tags -> 'healthcare', '') <> ''
  ) AS cat_healthcare,
  COUNT(*) FILTER (
    WHERE
      exist(tags, 'office')
      AND COALESCE(tags -> 'office', '') <> ''
  ) AS cat_office,
  COUNT(*) FILTER (
    WHERE
      (tags -> 'information') = 'office'
  ) AS cat_information_office
FROM
  osm_object_meta
WHERE
  (
    (tags -> 'amenity') = ANY(
      ARRAY[ 'library',
      'townhall',
      'restaurant',
      'fast_food',
      'cafe',
      'fuel',
      'pharmacy',
      'bank',
      'bar',
      'hospital',
      'post_office',
      'clinic',
      'pub',
      'car_wash',
      'ice_cream',
      'driving_school',
      'cinema',
      'car_rental',
      'nightclub',
      'bureau_de_change',
      'studio',
      'internet_cafe',
      'money_transfer',
      'casino',
      'vehicle_inspection',
      'frozen_food',
      'boat_rental',
      'coworking_space',
      'workshop',
      'personal_service',
      'camping',
      'dancing_school',
      'training',
      'ski_school',
      'ski_rental',
      'dive_centre',
      'driver_training',
      'nursing_home',
      'funeral_hall',
      'doctors',
      'dentist',
      'theatre',
      'kindergarten',
      'language_school',
      'stripclub',
      'veterinary',
      'convenience',
      'supermarket',
      'clothes',
      'hairdresser',
      'car_repair',
      'bakery',
      'beauty',
      'car',
      'hardware',
      'mobile_phone',
      'butcher',
      'furniture',
      'car_parts',
      'alcohol',
      'florist',
      'scooter',
      'variety_store',
      'electronics',
      'shoes',
      'optician',
      'jewelry',
      'mall',
      'gift',
      'doityourself',
      'greengrocer',
      'books',
      'bicycle',
      'chemist',
      'department_store',
      'laundry',
      'travel_agency',
      'stationery',
      'pet',
      'sports',
      'confectionery',
      'tyres',
      'cosmetics',
      'computer',
      'tailor',
      'tobacco',
      'storage_rental',
      'dry_cleaning',
      'trade',
      'copyshop',
      'motorcycle',
      'funeral_directors',
      'beverages',
      'newsagent',
      'garden_centre',
      'massage',
      'pastry',
      'interior_decoration',
      'general',
      'deli',
      'toys',
      'houseware',
      'wine',
      'seafood',
      'pawnbroker',
      'tattoo',
      'paint',
      'wholesale',
      'photo',
      'second_hand',
      'bed',
      'kitchen',
      'outdoor',
      'fabric',
      'antiques',
      'coffee',
      'gas',
      'e-cigarette',
      'perfumery',
      'craft',
      'hearing_aids',
      'money_lender',
      'appliance',
      'electrical',
      'tea',
      'motorcycle_repair',
      'boutique',
      'baby_goods',
      'bag',
      'musical_instrument',
      'dairy',
      'pet_grooming',
      'music',
      'carpet',
      'rental',
      'fashion_accessories',
      'cheese',
      'chocolate',
      'medical_supply',
      'leather',
      'sewing',
      'cannabis',
      'locksmith',
      'games',
      'video_games',
      'hifi',
      'window_blind',
      'caravan',
      'tool_hire',
      'household_linen',
      'bathroom_furnishing',
      'shoe_repair',
      'watches',
      'nutrition_supplements',
      'fishing',
      'erotic',
      'frame',
      'grocery',
      'boat',
      'repair',
      'weapons',
      'gold_buyer',
      'lighting',
      'pottery',
      'security',
      'groundskeeping',
      'herbalist',
      'curtain',
      'health_food',
      'flooring',
      'printer_ink',
      'anime',
      'camera',
      'scuba_diving',
      'candles',
      'printing',
      'garden_furniture',
      'food',
      'estate_agent',
      'insurance',
      'it',
      'accountant',
      'employment_agency',
      'tax_advisor',
      'financial',
      'advertising_agency',
      'logistics',
      'newspaper',
      'financial_advisor',
      'consulting',
      'travel_agent',
      'coworking',
      'moving_company',
      'lawyer',
      'architect',
      'construction_company',
      'credit_broker',
      'graphic_design',
      'property_management',
      'cleaning' ] :: text[]
    )
    OR (
      exist(tags, 'shop')
      AND COALESCE(tags -> 'shop', '') NOT ILIKE '%vacant%'
      AND COALESCE(tags -> 'shop', '') <> ''
    )
    OR (tags -> 'tourism') = ANY(
      ARRAY[ 'hotel', 'hostel', 'motel',
      'wilderness_hut', 'yes', 'chalet',
      'gallery', 'guest_house', 'museum',
      'zoo', 'theme_park', 'aquarium',
      'alpine_hut', 'apartment' ] :: text[]
    )
    OR (
      exist(tags, 'healthcare')
      AND COALESCE(tags -> 'healthcare', '') <> ''
    )
    OR (tags -> 'information') = 'office'
    OR (
      exist(tags, 'office')
      AND COALESCE(tags -> 'office', '') <> ''
    )
  )

SELECT
            COUNT(*)                                                                  AS total,
            COUNT(*) FILTER (WHERE COALESCE(tags->'email','') <> '' OR COALESCE(tags->'contact:email','') <> '')  AS with_email,
            COUNT(*) FILTER (WHERE COALESCE(tags->'phone','') <> '' OR COALESCE(tags->'contact:phone','') <> '')  AS with_phone,
            COUNT(*) FILTER (WHERE COALESCE(tags->'website','') <> '' OR COALESCE(tags->'contact:website','') <> ''
                                OR COALESCE(tags->'url','') <> '' OR COALESCE(tags->'contact:url','') <> '')      AS with_website,
            COUNT(*) FILTER (WHERE COALESCE(tags->'opening_hours','') <> '')                                       AS with_opening_hours,
            COUNT(*) FILTER (WHERE
                (COALESCE(tags->'addr:street','') <> '' AND COALESCE(tags->'addr:housenumber','') <> '')
             OR (COALESCE(tags->'contact:street','') <> '' AND COALESCE(tags->'contact:housenumber','') <> '')
            )                                                                                                     AS with_address,
            COUNT(*) FILTER (WHERE COALESCE(tags->'ref:FR:SIRET','') <> '')                                        AS with_siret,
            COUNT(*) FILTER (WHERE COALESCE(tags->'wheelchair','') <> '')                                          AS with_wheelchair,
            COUNT(*) FILTER (WHERE (tags->'amenity') = ANY(ARRAY['library','townhall','restaurant','fast_food','cafe','fuel','pharmacy','bank','bar','hospital','post_office','clinic','pub','car_wash','ice_cream','driving_school','cinema','car_rental','nightclub','bureau_de_change','studio','internet_cafe','money_transfer','casino','vehicle_inspection','frozen_food','boat_rental','coworking_space','workshop','personal_service','camping','dancing_school','training','ski_school','ski_rental','dive_centre','driver_training','nursing_home','funeral_hall','doctors','dentist','theatre','kindergarten','language_school','stripclub','veterinary','convenience','supermarket','clothes','hairdresser','car_repair','bakery','beauty','car','hardware','mobile_phone','butcher','furniture','car_parts','alcohol','florist','scooter','variety_store','electronics','shoes','optician','jewelry','mall','gift','doityourself','greengrocer','books','bicycle','chemist','department_store','laundry','travel_agency','stationery','pet','sports','confectionery','tyres','cosmetics','computer','tailor','tobacco','storage_rental','dry_cleaning','trade','copyshop','motorcycle','funeral_directors','beverages','newsagent','garden_centre','massage','pastry','interior_decoration','general','deli','toys','houseware','wine','seafood','pawnbroker','tattoo','paint','wholesale','photo','second_hand','bed','kitchen','outdoor','fabric','antiques','coffee','gas','e-cigarette','perfumery','craft','hearing_aids','money_lender','appliance','electrical','tea','motorcycle_repair','boutique','baby_goods','bag','musical_instrument','dairy','pet_grooming','music','carpet','rental','fashion_accessories','cheese','chocolate','medical_supply','leather','sewing','cannabis','locksmith','games','video_games','hifi','window_blind','caravan','tool_hire','household_linen','bathroom_furnishing','shoe_repair','watches','nutrition_supplements','fishing','erotic','frame','grocery','boat','repair','weapons','gold_buyer','lighting','pottery','security','groundskeeping','herbalist','curtain','health_food','flooring','printer_ink','anime','camera','scuba_diving','candles','printing','garden_furniture','food','estate_agent','insurance','it','accountant','employment_agency','tax_advisor','financial','advertising_agency','logistics','newspaper','financial_advisor','consulting','travel_agent','coworking','moving_company','lawyer','architect','construction_company','credit_broker','graphic_design','property_management','cleaning']::text[]))                                          AS cat_amenity,
            COUNT(*) FILTER (WHERE exist(tags, 'shop') AND COALESCE(tags->'shop','') NOT ILIKE '%vacant%' AND COALESCE(tags->'shop','') <> '') AS cat_shop,
            COUNT(*) FILTER (WHERE (tags->'tourism') = ANY(ARRAY['hotel','hostel','motel','wilderness_hut','yes','chalet','gallery','guest_house','museum','zoo','theme_park','aquarium','alpine_hut','apartment']::text[]))                                          AS cat_tourism,
            COUNT(*) FILTER (WHERE exist(tags, 'healthcare') AND COALESCE(tags->'healthcare','') <> '')             AS cat_healthcare,
            COUNT(*) FILTER (WHERE exist(tags, 'office') AND COALESCE(tags->'office','') <> '')                     AS cat_office,
            COUNT(*) FILTER (WHERE (tags->'information') = 'office')                                                AS cat_information_office
        FROM osm_object_meta
        WHERE (
              (tags->'amenity') = ANY(ARRAY['library','townhall','restaurant','fast_food','cafe','fuel','pharmacy','bank','bar','hospital','post_office','clinic','pub','car_wash','ice_cream','driving_school','cinema','car_rental','nightclub','bureau_de_change','studio','internet_cafe','money_transfer','casino','vehicle_inspection','frozen_food','boat_rental','coworking_space','workshop','personal_service','camping','dancing_school','training','ski_school','ski_rental','dive_centre','driver_training','nursing_home','funeral_hall','doctors','dentist','theatre','kindergarten','language_school','stripclub','veterinary','convenience','supermarket','clothes','hairdresser','car_repair','bakery','beauty','car','hardware','mobile_phone','butcher','furniture','car_parts','alcohol','florist','scooter','variety_store','electronics','shoes','optician','jewelry','mall','gift','doityourself','greengrocer','books','bicycle','chemist','department_store','laundry','travel_agency','stationery','pet','sports','confectionery','tyres','cosmetics','computer','tailor','tobacco','storage_rental','dry_cleaning','trade','copyshop','motorcycle','funeral_directors','beverages','newsagent','garden_centre','massage','pastry','interior_decoration','general','deli','toys','houseware','wine','seafood','pawnbroker','tattoo','paint','wholesale','photo','second_hand','bed','kitchen','outdoor','fabric','antiques','coffee','gas','e-cigarette','perfumery','craft','hearing_aids','money_lender','appliance','electrical','tea','motorcycle_repair','boutique','baby_goods','bag','musical_instrument','dairy','pet_grooming','music','carpet','rental','fashion_accessories','cheese','chocolate','medical_supply','leather','sewing','cannabis','locksmith','games','video_games','hifi','window_blind','caravan','tool_hire','household_linen','bathroom_furnishing','shoe_repair','watches','nutrition_supplements','fishing','erotic','frame','grocery','boat','repair','weapons','gold_buyer','lighting','pottery','security','groundskeeping','herbalist','curtain','health_food','flooring','printer_ink','anime','camera','scuba_diving','candles','printing','garden_furniture','food','estate_agent','insurance','it','accountant','employment_agency','tax_advisor','financial','advertising_agency','logistics','newspaper','financial_advisor','consulting','travel_agent','coworking','moving_company','lawyer','architect','construction_company','credit_broker','graphic_design','property_management','cleaning']::text[])
           OR (exist(tags, 'shop') AND COALESCE(tags->'shop','') NOT ILIKE '%vacant%' AND COALESCE(tags->'shop','') <> '')
           OR (tags->'tourism') = ANY(ARRAY['hotel','hostel','motel','wilderness_hut','yes','chalet','gallery','guest_house','museum','zoo','theme_park','aquarium','alpine_hut','apartment']::text[])
           OR (exist(tags, 'healthcare') AND COALESCE(tags->'healthcare','') <> '')
           OR (tags->'information') = 'office'
           OR (exist(tags, 'office') AND COALESCE(tags->'office','') <> '')
        );

SELECT
  1

SELECT 1;

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = 'public'
  AND table_name = 'osm_object_meta'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta';

SELECT
  (tags -> 'amenity') AS value,
  COUNT(*) AS count
FROM
  osm_object_meta
WHERE
  (tags -> 'amenity') = ANY(
    ARRAY[ 'library',
    'townhall',
    'restaurant',
    'fast_food',
    'cafe',
    'fuel',
    'pharmacy',
    'bank',
    'bar',
    'hospital',
    'post_office',
    'clinic',
    'pub',
    'car_wash',
    'ice_cream',
    'driving_school',
    'cinema',
    'car_rental',
    'nightclub',
    'bureau_de_change',
    'studio',
    'internet_cafe',
    'money_transfer',
    'casino',
    'vehicle_inspection',
    'frozen_food',
    'boat_rental',
    'coworking_space',
    'workshop',
    'personal_service',
    'camping',
    'dancing_school',
    'training',
    'ski_school',
    'ski_rental',
    'dive_centre',
    'driver_training',
    'nursing_home',
    'funeral_hall',
    'doctors',
    'dentist',
    'theatre',
    'kindergarten',
    'language_school',
    'stripclub',
    'veterinary',
    'convenience',
    'supermarket',
    'clothes',
    'hairdresser',
    'car_repair',
    'bakery',
    'beauty',
    'car',
    'hardware',
    'mobile_phone',
    'butcher',
    'furniture',
    'car_parts',
    'alcohol',
    'florist',
    'scooter',
    'variety_store',
    'electronics',
    'shoes',
    'optician',
    'jewelry',
    'mall',
    'gift',
    'doityourself',
    'greengrocer',
    'books',
    'bicycle',
    'chemist',
    'department_store',
    'laundry',
    'travel_agency',
    'stationery',
    'pet',
    'sports',
    'confectionery',
    'tyres',
    'cosmetics',
    'computer',
    'tailor',
    'tobacco',
    'storage_rental',
    'dry_cleaning',
    'trade',
    'copyshop',
    'motorcycle',
    'funeral_directors',
    'beverages',
    'newsagent',
    'garden_centre',
    'massage',
    'pastry',
    'interior_decoration',
    'general',
    'deli',
    'toys',
    'houseware',
    'wine',
    'seafood',
    'pawnbroker',
    'tattoo',
    'paint',
    'wholesale',
    'photo',
    'second_hand',
    'bed',
    'kitchen',
    'outdoor',
    'fabric',
    'antiques',
    'coffee',
    'gas',
    'e-cigarette',
    'perfumery',
    'craft',
    'hearing_aids',
    'money_lender',
    'appliance',
    'electrical',
    'tea',
    'motorcycle_repair',
    'boutique',
    'baby_goods',
    'bag',
    'musical_instrument',
    'dairy',
    'pet_grooming',
    'music',
    'carpet',
    'rental',
    'fashion_accessories',
    'cheese',
    'chocolate',
    'medical_supply',
    'leather',
    'sewing',
    'cannabis',
    'locksmith',
    'games',
    'video_games',
    'hifi',
    'window_blind',
    'caravan',
    'tool_hire',
    'household_linen',
    'bathroom_furnishing',
    'shoe_repair',
    'watches',
    'nutrition_supplements',
    'fishing',
    'erotic',
    'frame',
    'grocery',
    'boat',
    'repair',
    'weapons',
    'gold_buyer',
    'lighting',
    'pottery',
    'security',
    'groundskeeping',
    'herbalist',
    'curtain',
    'health_food',
    'flooring',
    'printer_ink',
    'anime',
    'camera',
    'scuba_diving',
    'candles',
    'printing',
    'garden_furniture',
    'food',
    'estate_agent',
    'insurance',
    'it',
    'accountant',
    'employment_agency',
    'tax_advisor',
    'financial',
    'advertising_agency',
    'logistics',
    'newspaper',
    'financial_advisor',
    'consulting',
    'travel_agent',
    'coworking',
    'moving_company',
    'lawyer',
    'architect',
    'construction_company',
    'credit_broker',
    'graphic_design',
    'property_management',
    'cleaning' ] :: text[]
  )
GROUP BY
  value
ORDER BY
  count DESC
LIMIT
  ?

SELECT (tags->'amenity') AS value, COUNT(*) AS count
                FROM osm_object_meta
                WHERE (tags->'amenity') = ANY(ARRAY['library','townhall','restaurant','fast_food','cafe','fuel','pharmacy','bank','bar','hospital','post_office','clinic','pub','car_wash','ice_cream','driving_school','cinema','car_rental','nightclub','bureau_de_change','studio','internet_cafe','money_transfer','casino','vehicle_inspection','frozen_food','boat_rental','coworking_space','workshop','personal_service','camping','dancing_school','training','ski_school','ski_rental','dive_centre','driver_training','nursing_home','funeral_hall','doctors','dentist','theatre','kindergarten','language_school','stripclub','veterinary','convenience','supermarket','clothes','hairdresser','car_repair','bakery','beauty','car','hardware','mobile_phone','butcher','furniture','car_parts','alcohol','florist','scooter','variety_store','electronics','shoes','optician','jewelry','mall','gift','doityourself','greengrocer','books','bicycle','chemist','department_store','laundry','travel_agency','stationery','pet','sports','confectionery','tyres','cosmetics','computer','tailor','tobacco','storage_rental','dry_cleaning','trade','copyshop','motorcycle','funeral_directors','beverages','newsagent','garden_centre','massage','pastry','interior_decoration','general','deli','toys','houseware','wine','seafood','pawnbroker','tattoo','paint','wholesale','photo','second_hand','bed','kitchen','outdoor','fabric','antiques','coffee','gas','e-cigarette','perfumery','craft','hearing_aids','money_lender','appliance','electrical','tea','motorcycle_repair','boutique','baby_goods','bag','musical_instrument','dairy','pet_grooming','music','carpet','rental','fashion_accessories','cheese','chocolate','medical_supply','leather','sewing','cannabis','locksmith','games','video_games','hifi','window_blind','caravan','tool_hire','household_linen','bathroom_furnishing','shoe_repair','watches','nutrition_supplements','fishing','erotic','frame','grocery','boat','repair','weapons','gold_buyer','lighting','pottery','security','groundskeeping','herbalist','curtain','health_food','flooring','printer_ink','anime','camera','scuba_diving','candles','printing','garden_furniture','food','estate_agent','insurance','it','accountant','employment_agency','tax_advisor','financial','advertising_agency','logistics','newspaper','financial_advisor','consulting','travel_agent','coworking','moving_company','lawyer','architect','construction_company','credit_broker','graphic_design','property_management','cleaning']::text[])
                GROUP BY value ORDER BY count DESC LIMIT 15;