http://vigner.org - сайт ориентирован на загрузки. Пока не много всего, но все свое и качествение, никаких грабов)
07 Окт 2010, 18:06razdel android
SELECT SQL_CALC_FOUND_ROWS
dd.directory_id AS file_id,
dd.name,
'directory' AS type,
'directory' AS file_ext,
COUNT(CASE WHEN status = 'active' THEN 1 END) AS count_files,
COUNT(CASE WHEN time > UNIX_TIMESTAMP() - 24 * 3600 THEN 1 END) AS new_day,
0 AS real_name,
0 AS filesize,
0 AS time,
0 AS path_to_file,
0 AS downloads,
0 AS screen1,
0 AS about,
0 AS previews,
dd.position
FROM a_downloads_directories AS dd
LEFT JOIN a_downloads_files AS df
ON df.path_to_file LIKE CONCAT('%/', dd.directory_id, '/%')
AND df.status != 'moderate'
AND real_name != ''
WHERE dd.parent_id = '61'
GROUP BY dd.directory_id
UNION ALL
SELECT file_id, name, (SELECT 'file') AS type, file_ext,
(SELECT 0) AS count_files,
(SELECT 0) AS new_day,
real_name,
filesize,
time,
path_to_file,
downloads,
screen1,
about,
previews,
(SELECT 0) AS position
FROM a_downloads_files
WHERE
directory_id = '61' AND
status = 'active' AND
real_name != ''
ORDER BY type ASC, position ASC LIMIT 0, 50
Can't create/write to file '/tmp/#sql_6598_0.MYI' (Errcode: 28)
Джон?
07 Окт 2010, 20:02pulsar, Спс) Обезательно)
Потом еще один банер уберу, ща просто для роскрутки надо...
Да MobileCMS)