select * from c_movies where id in (select aid from c_tag where name in (select name from c_tag where siteid=87 and aid=1) and siteid=87) order by (select count(aid) from c_tag where name in(select name from c_tag where aid=6) and id=c_movies.id)
tag排序SQL语句
2009-7-12 11:31:4
Tags: sql mysql
发布:subin | 分类:MYSQL / MSSQL / Access | 评论:1 | 引用:0 | 浏览:
- 相关文章:
mysql 1406 错误 解决方式 (2009-7-7 14:4:30)
PHP操作Access类 (2009-4-4 11:36:42)
DELETE FROM x join xx WHERE 语句 (2009-3-28 17:52:6)
PHP防注入代码 (2009-1-7 20:52:14)
Advanced SQL Injection with MySQL (2009-1-7 20:38:15)
SQL Injection with MySQL (2009-1-7 20:25:10)
mysql timestamp列 设置为 默认时间 (2008-12-29 0:3:22)
mysql 用户登陆失败. (2008-12-28 16:41:1)
mysql 启动时 发生系统错误 1067。 (2008-12-28 15:30:34)
mysql top 是使用方法 (2008-12-3 11:9:16)
◎欢迎参与讨论，请在这里发表您的看法、交流您的观点。
