SELECT p.id as ID, p.n_code as Code, p.s_description as Description, p.s_icon as Icon, p.s_compatibility as Compatibility, 0 as Price FROM t_product as p INNER JOIN t_product_category pc ON pc.id = p.n_category INNER JOIN t_product_brand pb ON pb.id = p.n_brand WHERE p.n_category = #category# AND p.n_brand = #brand# AND p.b_publish IS TRUE ORDER BY pc.s_description, p.s_description SELECT DISTINCT pc.id as ID, pc.s_description as Category FROM t_product_category as pc INNER JOIN t_product as p ON pc.id = p.n_category INNER JOIN t_product_brand pb ON pb.id = p.n_brand WHERE p.b_publish IS TRUE ORDER BY pc.s_description SELECT DISTINCT pb.id as ID, pc.id as CategoryID, p.n_category as Category, pb.s_description as Brand FROM t_product as p INNER JOIN t_product_category pc ON pc.id = p.n_category INNER JOIN t_product_brand pb ON pb.id = p.n_brand WHERE p.b_publish IS TRUE