SQL Formatter

SELECT c.name, count(p.id) AS product_count, avg(p.price) avg_price
FROM categories c
LEFT
JOIN (
  SELECT p. *, pc.category_id
  FROM products p
  INNER
  JOIN product_categories pc
  ON pc.product_id = p.id
  WHERE p.active = 1
) p
ON p.category_id = c.id
WHERE c.parent_id is NULL
GROUP BY c.id, c.name
HAVING count(p.id) >0
ORDER BY product_count DESC, c.name ASC
LIMIT 10
OFFSET 5