This code,in mysql5.x is normal,trades on mysql4.x,appears wrong,is what reason?

This code,in mysql5.x is normal,trades on mysql4.x,appears wrong,is what reason?

<?phpif (user_access('access content')) { $result = db_query("SELECT d.tid, d.name, MAX(n.created) AS updated,COUNT(*) AS count FROM {term_data} d INNER JOIN {term_node} USING (tid) INNER JOIN {node} n USING (nid) WHERE n.status = 1 and d.vid=1 or vid=2 or vid=3 or vid=4 or vid=5 or vid=6 or vid=7 or vid=8 or vid=9 or vid=10 or vid=11 or vid=12 or vid=13 or vid=14 or vid=15 GROUP BY d.tid,d.name ORDER BY updated DESC, d.name");//读取分类关键词，最新文章创建的时间，降序排列//d.vid=1是因为我按照kzeng的freetag的解决方法建了两种分类，其中第二种分类是用来做freetag的，//如果你只有一个分类，可以省掉这一句；如果你也有多个分类，应该按照你数据库里面的实际值来输入 $items = array(); while ($category = db_fetch_object($result)) {   $items[] = l($category->name .' ('. $category->count .')','taxonomy/term/'. $category->tid);   //按照以前的格式显示分类区块，包括最后一片帖子的发布时间。   //.'<br/>'. t('%time ago', array('%time' => format_interval(time() - $category->updated)))); } return theme('item_list', $items);}?>