Discuz!官方免费开源建站系统

 找回密码
 立即注册
搜索

[疑问] 请问一下 这些语句到底在干什么?????SELECT t.*, f.name FROM cdb_threads

[复制链接]
chnsbs 发表于 2008-5-10 10:38:52 | 显示全部楼层 |阅读模式
# Query_time: 2  Lock_time: 0  Rows_sent: 1646        Rows_examined: 241050

(SELECT t.*, f.name FROM cdb_threads t LEFT JOIN cdb_forums f ON f.fid =
t.fid WHERE t.fid='522' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT
t.*, f.name FROM cdb_threads t LEFT JOIN cdb_forums f ON f.fid = t.fid
WHERE t.fid='305' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*,
f.name FROM cdb_threads t LEFT JOIN cdb_forums f ON f.fid = t.fid WHERE
t.fid='527' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name
FROM cdb_threads t LEFT JOIN cdb_forums f ON f.fid = t.fid WHERE
t.fid='523' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name
FROM cdb_threads t LEFT JOIN cdb_forums f ON f.fid = t.fid WHERE
t.fid='524' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name
FROM cdb_threads t LEFT JOIN cdb_forums f ON f.fid = t.fid WHERE
t.fid='525' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name
FROM cdb_threads t LEFT JOIN cdb_forums f ON f.fid = t.fid WHERE
t.fid='526' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name
FROM cdb_threads t LEFT JOIN cdb_forums f ON f.fid = t.fid WHERE
t.fid='46' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name
FROM cdb_threads t LEFT JOIN cdb_forums f ON f.fid = t.fid WHERE
t.fid='48' ORDER BY t.dateline DESC LIMIT 5) UNION (SELECT t.*, f.name

[ 本帖最后由 chnsbs 于 2008-5-10 10:46 编辑 ]
回复

使用道具 举报

 楼主| chnsbs 发表于 2008-5-10 10:47:00 | 显示全部楼层
谁知道啊 说一下啊 在线等
回复

使用道具 举报

 楼主| chnsbs 发表于 2008-5-10 10:55:53 | 显示全部楼层
有知道的请说一下啊 怎么回事情啊
回复

使用道具 举报

 楼主| chnsbs 发表于 2008-5-10 13:22:11 | 显示全部楼层
有知道的告诉一下啊 急
回复

使用道具 举报

陈云飞 发表于 2008-5-19 04:21:53 | 显示全部楼层
解决了吗?
我的是

Discuz! info: MySQL Query Error

Time: 2008-5-19 4:12am
Script: /bbs/index.php

SQL: SELECT t.*, f.name FROM [Table]threads t, [Table]forums f WHERE t.fid<>'0' AND f.fid=t.fid AND f.fid not in (0,47) AND t.displayorder not in (-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10
Error: Error writing file 'C:\WINDOWS\TEMP\MY12160' (Errcode: 28)
Errno.: 3
回复

使用道具 举报

桃子(小敏) 发表于 2008-5-19 09:20:21 | 显示全部楼层

回复 5# 陈云飞 的帖子

请检查'C:\WINDOWS\TEMP\文件夹是否已满
回复

使用道具 举报

桃子(小敏) 发表于 2008-5-19 09:20:55 | 显示全部楼层

回复 1# chnsbs 的帖子

请贴出完整的错误提示
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2025-9-15 15:32 , Processed in 0.080552 second(s), 14 queries , Gzip On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表