Erro: 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 P.prd_stt > 0 AND PxC.ctg_id = 8 ORDER BY PxC.prd_ndx' at line 13
------------------------------------
SELECT P.prd_id, P.prd_tit, P.prd_dsc, P.prd_hash, P.prd_vlr, P.prd_stt FROM lms_ecm_prd P INNER JOIN lms_ecm_prd_ctg PxC ON P.prd_id = PxC.prd_id LEFT OUTER JOIN lms_crs CRS ON P.prd_crs_id = CRS.crs_id WHERE P.prd_org_id = AND P.prd_stt > 0 AND PxC.ctg_id = 8 ORDER BY PxC.prd_ndx;