这个句子还能再优化一下吗？

复制内容到剪贴板

代码:

$sql  =  "SELECT sp.*,tbo.id as ttid,tbo.item_title,tbo.pic_url,ts.goodid FROM table1 sp left join table2 ts on ts.id=sp.sid left join table3 tbo on tbo.num_iid=ts.goodid group by sp.pid ORDER BY sp.dateline DESC";