SELECT i.*, u.displayname FROM cms_item i LEFT JOIN cms_users u ON i.item_author = u.id WHERE i.item_type = 'gallery' AND i.item_status = 'public' AND i.item_language = 'bg' ORDER BY i.item_orderby DESC LIMIT 0, 5
Галерия