You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND product_pricecode_status = 'active'
	GROUP BY product_pricecode_id ORDER BY ' at line 5SELECT * FROM tbl_product_product_pricecode 
	INNER JOIN tbl_product_pricecode ON ( tbl_product_product_pricecode.ppp_product_pricecode_id = tbl_product_pricecode.product_pricecode_id )
	INNER JOIN tbl_product_sub_category ON ( tbl_product_pricecode.product_pricecode_product_sub_category_id = tbl_product_sub_category.product_sub_category_id )
	INNER JOIN tbl_product_size ON ( tbl_product_product_pricecode.ppp_product_size_id = tbl_product_size.product_size_id )
	WHERE ppp_product_id =  AND product_pricecode_status = 'active'
	GROUP BY product_pricecode_id ORDER BY product_sub_category_order, product_pricecode_title ASC