| ID |
SQL命令 |
| [1] |
SELECT name,addons FROM hd_hooks WHERE status=1 |
| [2] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=52 |
| [3] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=53 |
| [4] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=54 |
| [5] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=57 |
| [6] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=58 |
| [7] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=81 |
| [8] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=82 |
| [9] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=52 |
| [10] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=53 |
| [11] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=54 |
| [12] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=57 |
| [13] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=58 |
| [14] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=81 |
| [15] |
SELECT * FROM hd_category c JOIN hd_content t ON c.cid=t.cid WHERE c.cid=82 |
| [16] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(61,60,62,63,121,107) AND find_in_set('图片',flag) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,5 |
| [17] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(61) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,7 |
| [18] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(60) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,7 |
| [19] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(62) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,7 |
| [20] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(63) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,7 |
| [21] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(75,76) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,16 |
| [22] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(77) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,16 |
| [23] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(78) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,16 |
| [24] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(79,80) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,16 |
| [25] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(68) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,100 |
| [26] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(56) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,100 |
| [27] |
SELECT * FROM hd_content content INNER JOIN hd_category category ON category.cid=content.cid INNER JOIN hd_user user ON user.uid=content.uid INNER JOIN hd_model model ON model.mid=category.mid WHERE category.cid IN(64) AND content_status=1 ORDER BY arc_sort asc,addtime desc LIMIT 0,100 |
