select pci.image,c.ShortName,c.Dates,c.venue from editConference c left join past_conf_images pci ON pci.confid = c.id where pci.image <>'' and c.up = '2' group by pci.confid DESC limit 0,20