Select CT.CTNAME, CTSG.CTNO, SG.SALEGDNO, SG.GDNO, SG.GNAME, SG.GTYPE, SG.POST_Y, SG.GOODSQNA_Y, SG.AFTERPAY_Y, SG.SALECNT_Y, SG.SALECNT, SG.UNITSALE, SG.PRICE_P, Format( SG.PRICE_P, 0 ) AS PRICE_P_F, SG.PRICE_R, Format( SG.PRICE_R, 0 ) AS PRICE_R_F, SG.RATE_DCNT, SG.RATE_TRANS, SG.RATE_MILE, SG.RATE_POINT, SG.ATTRI, SG.REGDATE AS SREGDATE, SG.GREGDATE, SG.REGDTIME, SG.PICS_NAME, SG.PICS_WIDTH, SG.PICS_HEIGHT, SG.SPEC, SG.KEYWORD, SG.TITLE, SG.ORIGIN, SG.BRAND, SG.MAKER, SG.PGSYS, NOW() < Date_add( SG.REGDTIME, interval 720 Hour ) AS ICON_NEW, 1000 <= SG.VIEWCNT AS ICON_COOL, 1000 <= SG.SALEDCNT AS ICON_HOT From ta_salegoods AS SG LEFT JOIN ta_cate_salegoods AS CTSG ON SG.SALEGDNO = CTSG.SALEGDNO LEFT JOIN ta_cate AS CT ON CTSG.CTNO = CT.CTNO Where SG.GOODS_HIDDEN<>'Y' AND SG.SALEGDNO BETWEEN '' AND '' AND CT.CTPOSE LIKE 'AAI%' AND CTSG.GTBL_Y = 'Y' Group By SG.SALEGDNO Order by SG.SALEGDNO DESC Limit 2
Can't create/write to file '/backup/tmp/#sql45aa_2427c_1.MYI' (Errcode: 13)