SELECT property.ProName, property.ID, pro_tag.pro_id, pro_tag.tag_id, pro_tag.mins, tags.tag_type, tags.tag_name, tags.tag_value FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id where property.ID in (SELECT property.ID FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id WHERE tags.tag_name = "Pudong" ) and tags.tag_name = "Popular" order by property.ProName asc limit 8
SELECT property.ProName, property.ID, pro_tag.pro_id, pro_tag.tag_id, pro_tag.mins, tags.tag_type, tags.tag_name, tags.tag_value FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id where property.ID in (SELECT property.ID FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id WHERE tags.tag_name = "Downtown" ) and tags.tag_name = "Popular" order by property.ProName asc limit 8
SELECT property.ProName, property.ID, pro_tag.pro_id, pro_tag.tag_id, pro_tag.mins, tags.tag_type, tags.tag_name, tags.tag_value FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id where property.ID in (SELECT property.ID FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id WHERE tags.tag_name = "Hongqiao" ) and tags.tag_name = "Popular" order by property.ProName asc limit 8
SELECT property.ProName, property.ID, pro_tag.pro_id, pro_tag.tag_id, pro_tag.mins, tags.tag_type, tags.tag_name, tags.tag_value FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id where property.ID in (SELECT property.ID FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id WHERE tags.tag_name = "Suburb" ) and tags.tag_name = "Popular" order by property.ProName asc limit 8