SELECT arc.id,addon.aid,arc.title,arc.shorttitle,addon.icon,addon.rank,addon.type,pubdate,newshuxing FROM `#@__archives` arc LEFT JOIN `#@__addondownloaddb` addon ON arc.id=addon.aid WHERE arc.arcrank>-1 and newshuxing=2083 and addon.state=511 and addon.charge=0 and downloadchannel='519' order by pubdate desc