Portfolio

SELECT p.*, pt.portfolio_tag_word, pc.portfolio_category_safe_title FROM portfolio AS p LEFT JOIN portfolio_category AS pc ON pc.portfolio_category_id = p.portfolio_category_id LEFT JOIN portfolio_tag AS pt ON pt.portfolio_id = p.portfolio_id WHERE pc.portfolio_category_safe_title = 'rosewood-avenue' AND pc.portfolio_category_active = 1 AND p.portfolio_active = 1 GROUP BY p.portfolio_id ORDER BY p.portfolio_sort_order ASC, p.portfolio_title LIMIT 0, 9