All_New_Bapa

SELECT
    `poidata`.`id` AS `id`,
    `poidata`.`shop_id` AS `shop_id`,
    `poidata`.`name` AS `name`,
    `poidata`.`real_city` AS `real_city`,
    `poidata`.`province` AS `province`,
    `poidata`.`phone` AS `phone`,
    `poidata`.`address` AS `address`,
    `poidata`.`avg_price` AS `avg_price`,
    `poidata`.`small_cate` AS `small_cate`,
    `poidata`.`dishes` AS `dishes` 
FROM
    `poidata` 
WHERE
    (
        `poidata`.`small_cate` IN (
            '奶茶/果汁',
            '面包/饮品',
            '面包甜点',
            '甜品饮品',
            '甜品',
            '饮料冰品',
            '冰淇淋',
            '蛋挞',
            '冰品',
            '新式甜品',
            '雪糕饮品',
            '甜品饮料',
            '饮品',
            '西式甜点',
            '港台甜品',
            '传统甜品' 
        ) 
    ) 

All_New_Casual_dining

SELECT
    `poidata`.`id` AS `id`,
    `poidata`.`shop_id` AS `shop_id`,
    `poidata`.`name` AS `name`,
    `poidata`.`real_city` AS `real_city`,
    `poidata`.`province` AS `province`,
    `poidata`.`phone` AS `phone`,
    `poidata`.`address` AS `address`,
    `poidata`.`avg_price` AS `avg_price`,
    `poidata`.`small_cate` AS `small_cate`,
    `poidata`.`dishes` AS `dishes` 
FROM
    `poidata` 
WHERE
    (
    `poidata`.`small_cate` IN ( '西餐', '法国菜', '西式正餐', '牛排', '创意菜', '西班牙菜', '印度菜', '意大利菜', '日式烧烤/烤肉', '日本菜', '拉美烧烤', '俄罗斯菜', '日式自助' ) 
    )

All_New_Coffee

SELECT
    `poidata`.`id` AS `id`,
    `poidata`.`shop_id` AS `shop_id`,
    `poidata`.`name` AS `name`,
    `poidata`.`real_city` AS `real_city`,
    `poidata`.`province` AS `province`,
    `poidata`.`phone` AS `phone`,
    `poidata`.`address` AS `address`,
    `poidata`.`avg_price` AS `avg_price`,
    `poidata`.`small_cate` AS `small_cate`,
    `poidata`.`dishes` AS `dishes` 
FROM
    `poidata` 
WHERE
    ( `poidata`.`small_cate` = '咖啡厅' )

All_New_Fine_Dining

SELECT
    `poidata`.`id` AS `id`,
    `poidata`.`shop_id` AS `shop_id`,
    `poidata`.`name` AS `name`,
    `poidata`.`real_city` AS `real_city`,
    `poidata`.`province` AS `province`,
    `poidata`.`phone` AS `phone`,
    `poidata`.`address` AS `address`,
    `poidata`.`avg_price` AS `avg_price`,
    `poidata`.`small_cate` AS `small_cate`,
    `poidata`.`dishes` AS `dishes` 
FROM
    `poidata` 
WHERE
    (
        `poidata`.`small_cate` IN (
            '西餐',
            '法国菜',
            '西式正餐',
            '牛排',
            '创意菜',
            '西班牙菜',
            '印度菜',
            '意大利菜',
            '日式烧烤/烤肉',
            '日本菜',
            '拉美烧烤',
            '俄罗斯菜',
            '日式自助',
            '粤菜馆',
            '粤菜/潮州菜',
            '粤菜',
            '燕翅鲍',
            '潮粤菜' 
        ) 
    )

All_New_milktea

SELECT
    `poidata`.`id` AS `id`,
    `poidata`.`shop_id` AS `shop_id`,
    `poidata`.`name` AS `name`,
    `poidata`.`real_city` AS `real_city`,
    `poidata`.`province` AS `province`,
    `poidata`.`phone` AS `phone`,
    `poidata`.`address` AS `address`,
    `poidata`.`avg_price` AS `avg_price`,
    `poidata`.`small_cate` AS `small_cate`,
    `poidata`.`dishes` AS `dishes` 
FROM
    `poidata` 
WHERE
    ( `poidata`.`small_cate` IN ( '奶茶/果汁', '面包/饮品', '面包甜点', '甜品饮品', '饮料冰品', '雪糕饮品', '甜品饮料', '饮品' ) )

All_new_qsr

SELECT
    `poidata`.`id` AS `id`,
    `poidata`.`shop_id` AS `shop_id`,
    `poidata`.`name` AS `name`,
    `poidata`.`real_city` AS `real_city`,
    `poidata`.`province` AS `province`,
    `poidata`.`phone` AS `phone`,
    `poidata`.`address` AS `address`,
    `poidata`.`avg_price` AS `avg_price`,
    `poidata`.`small_cate` AS `small_cate`,
    `poidata`.`dishes` AS `dishes` 
FROM
    `poidata` 
WHERE
    ( `poidata`.`small_cate` IN ( '西式简餐', '比萨', '快餐简餐', '西餐' ) )