Mysql View Of Category

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 ( '西式简餐', '比萨', '快餐简餐', '西餐' ) )