SELECT i.id as id, i.seolink as seolink, ic.ordering as ordering, i.title as title
                FROM cms_shop_items i, cms_shop_items_cats ic
                WHERE ic.item_id = i.id
                  AND ic.category_id = 23
                  AND (ic.ordering = -1 OR ic.ordering = +1)