一些ThinkPHP查询语句

去重统计

->count('distinct visit_ip')

多表查询

SELECT a.*,b.* FROM `visit` as a ,`visit_info` as b where a.visit_id=b.visit_id and (a.`visit_ip` LIKE '%手机%' or a.`visit_url` LIKE '%手机%' or b.`visit_client`=(select visit_client_id from visit_client where visit_client_name='手机') or b.`visit_os`=(select visit_os_id from visit_os where visit_os_name='手机') or b.`visit_browser`=(select visit_browser_id from visit_browser where visit_browser_name='手机') ) order by a.visit_id desc limit 0,10

多表统计

select count(*) as total from `visit` as a ,`visit_info` as b where a.visit_id=b.visit_id and (a.`visit_ip` LIKE '%手机%' or a.`visit_url` LIKE '%手机%' or b.`visit_client`=(select visit_client_id from visit_client where visit_client_name='手机') or b.`visit_os`=(select visit_os_id from visit_os where visit_os_name='手机') or b.`visit_browser`=(select visit_browser_id from visit_browser where visit_browser_name='手机') )