SELECT
a.*,
b.pass AS pass,
b.want AS want,
b.rec AS rec,
t.tjc AS t_tjc,
t.tag AS t_tag
FROM
g_applist a
LEFT JOIN g_applist_info b ON a.id=b.sid
LEFT JOIN g_app_tag t ON a.id=t.sid
WHERE
1=1 and a.area like "%%" and a.sqdb like "%%" and t.tag like "%咖啡%"
ORDER BY
a.avgscore desc
LIMIT 10
搜索-这里网,时尚,生活,美食,北京
