SELECT i.*, ic.* FROM bn_galleries_images i LEFT JOIN bn_galleries_images_captions ic ON ic.ImageID = i.ID WHERE i.GalleryID=11 ORDER BY ic.publishTime DESC LIMIT 100