SELECT 		efd.cnpj cnpj_emp, efd.data_fim apur, efd_notas.nome_part, efd_notas.cnpj_part, efd_notas.cod_mun cod_mun_part,
			efd_notas.cidade cid_part, efd_notas.estado est_part, efd_notas.dt_e_s, efd_items.cod_ncm, efd_items.vl_item,
            efd_items.cfop cfop_item, efd_notas_analiticos.vl_opr, efd_notas_analiticos.cfop cfop_opr

FROM		efd
LEFT JOIN	efd_notas				ON	efd.id			=	efd_notas.id_efd
LEFT JOIN	efd_items				ON	efd_notas.id	=	efd_items.nota_id
LEFT JOIN	efd_notas_analiticos	ON	efd_notas.id	=	efd_notas_analiticos.nota_id

where	efd_items.cfop 				in	(	1101,2101,3101,1102,2102,3102,1111,2111,1113,2113,1116,2116,1117,2117,1118,1120,2120,1121,2121,1122,
											2122,1124,2124,1125,2125,1126,2126,3126,1128,2128,3128,1251,2251,3251,1252,2252,1253,2253,1254,2254,
                                            1255,2255,1256,2256,1257,2257,1301,2301,3301,1302,2302,1303,2303,1304,2304,1305,2305,1306,2306,1351,
                                            2351,3351,1352,2352,3352,1353,2353,3353,1354,2354,3354,1355,2355,3355,1356,2356,3356,1360,1401,2401,
                                            1403,2403,1406,2406,1407,2407,1501,2501,1551,2551,3551,1556,2556,3556,1651,2651,3651,1652,2652,3652,
                                            1653,2653,3653,3127)
or		efd_notas_analiticos.cfop	in	(	1101,2101,3101,1102,2102,3102,1111,2111,1113,2113,1116,2116,1117,2117,1118,1120,2120,1121,2121,1122,
											2122,1124,2124,1125,2125,1126,2126,3126,1128,2128,3128,1251,2251,3251,1252,2252,1253,2253,1254,2254,
                                            1255,2255,1256,2256,1257,2257,1301,2301,3301,1302,2302,1303,2303,1304,2304,1305,2305,1306,2306,1351,
                                            2351,3351,1352,2352,3352,1353,2353,3353,1354,2354,3354,1355,2355,3355,1356,2356,3356,1360,1401,2401,
                                            1403,2403,1406,2406,1407,2407,1501,2501,1551,2551,3551,1556,2556,3556,1651,2651,3651,1652,2652,3652,
                                            1653,2653,3653,3127)
and		concat(efd_notas_analiticos.cst_icms, efd_notas_analiticos.cfop) = concat(efd_items.cst_icms, efd_items.cfop)
or		concat(efd_items.cst_icms, efd_items.cfop) is null