КОЛКО Е ЧАСЪТ?... ЕДИН МНООГО СТАР ВИЦ! :) 2010-08-05 15:42:33
SELECT i.*, ic.* FROM bn_galleries_images i LEFT JOIN bn_galleries_images_captions ic ON ic.ImageID = i.ID WHERE ic.language_id = 1 AND ic.active = 1 AND i.enabled = 1 AND ic.publishTime <= NOW() AND i.GalleryID = 5 ORDER BY ic.publishTime DESC LIMIT 1