-- Заррос без фильтра
SELECT p.id, p.text, p.author_watch, p.status,
            p.adult, p.category, c.title AS category_string,
            p.owner_id, p.type, p.photo
            FROM `posts` AS p
            LEFT JOIN category AS c ON(c.id=p.category)
            WHERE category=:cat $order LIMIT :offset, :limit