DB function failed with error number 1021
Disk full (/tmp/#sql_6670c_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT jos_item.*
FROM jos_item INNER JOIN jos_number ON jos_item.numberID=jos_number.id
WHERE 1=1
AND (jos_item.imgMini<>'')
AND jos_item.type='P'
AND jos_item.numberID= (
SELECT jos_number.id
FROM jos_number
WHERE jos_number.journalID IN (8)
and jos_item.fid=202
and jos_number.id in (select distinct jos_number.id from jos_number join jos_item on jos_item.numberid=jos_number.id where jos_item.type='P')
ORDER BY (CONVERT(SUBSTRING(issue,1,2),SIGNED) + (CONVERT(SUBSTRING(issue,3,2),SIGNED)*100)) DESC
LIMIT 0,1
)
AND (jos_number.channelID=294780885 OR jos_number.channelID=0)
ORDER BY RAND() DESC LIMIT 3
- Webinars
- Language:
