select * from (
	select concat(cat2.pref,'_',UPPER(a2.Search))  as  item_code_crs
			, concat(cat1.pref,'_',UPPER(a1.Search)) as  item_code
			, a1.ID_src as art_id, a2.ID_src as art_id2
	FROM opti_2001.cat_alt_crossing c
	INNER JOIN opti_2001.cat_alt_articles a1 ON c.ID_art = a1.ID_art
	INNER JOIN opti_2001.cat_alt_articles a2 ON c.ID_cross = a2.ID_art
	INNER JOIN opti_2001.cat_alt_suppliers as s1 on a1.ID_sup=s1.ID_sup
	INNER JOIN cat as cat1 ON cat1.id_sup = s1.ID_src
	INNER JOIN opti_2001.cat_alt_suppliers as s2 on a2.ID_sup=s2.ID_sup
	INNER JOIN cat as cat2 ON cat2.id_sup = s2.ID_src
	where 1=1 
	 and a1.Search like '%545156033%' and a1.Search<>'' and cat1.pref='00D'
	 union 
	select concat(cat1.pref,'_',UPPER(a1.Search))  as  item_code_crs
			, concat(cat2.pref,'_',UPPER(a2.Search)) as  item_code
			, a2.ID_src as art_id, a1.ID_src as art_id2
	FROM opti_2001.cat_alt_crossing c
	INNER JOIN opti_2001.cat_alt_articles a1 ON c.ID_art = a1.ID_art
	INNER JOIN opti_2001.cat_alt_articles a2 ON c.ID_cross = a2.ID_art
	INNER JOIN opti_2001.cat_alt_suppliers as s1 on a1.ID_sup=s1.ID_sup
	INNER JOIN cat as cat1 ON cat1.id_sup = s1.ID_src
	INNER JOIN opti_2001.cat_alt_suppliers as s2 on a2.ID_sup=s2.ID_sup
	INNER JOIN cat as cat2 ON cat2.id_sup = s2.ID_src
	where 1=1 
	 and a2.Search like '%545156033%' and a2.Search<>'' and cat2.pref='00D'
	  union 
    select concat(cat1.pref,'_',UPPER(a1.Search)) as  item_code,
	    concat(cat2.pref,'_',UPPER(o.oe_code))  as  item_code_crs
	    , 0 as is_replacement, a1.ID_src as art_id
    FROM opti_2001.cat_alt_original o
    inner join opti_2001.cat_alt_articles a1 on a1.id_art=o.ID_art
	INNER JOIN opti_2001.cat_alt_suppliers as s1 on a1.ID_sup=s1.ID_sup
	INNER JOIN cat as cat1 ON cat1.id_sup = s1.ID_src
	INNER JOIN cat as cat2 ON cat2.id_mfa = o.oe_brand
    where 1=1
     and a1.Search like '%545156033%' and a1.Search<>'' and cat1.pref='00D' 
     union 
    select concat(cat1.pref,'_',UPPER(a1.Search)) as  item_code_crs,
	    concat(cat2.pref,'_',UPPER(o.oe_code))  as  item_code
	    , 0 as is_replacement, a1.ID_src as art_id
    FROM opti_2001.cat_alt_original o
    inner join opti_2001.cat_alt_articles a1 on a1.id_art=o.ID_art
	INNER JOIN opti_2001.cat_alt_suppliers as s1 on a1.ID_sup=s1.ID_sup
	INNER JOIN cat as cat1 ON cat1.id_sup = s1.ID_src
	INNER JOIN cat as cat2 ON cat2.id_mfa = o.oe_brand
    where 1=1
     and o.oe_code in ('545156033')  and cat2.pref='00D'  union
        select concat(cat2.pref,'_',UPPER(a2.Search))  as  item_code_crs
                , concat(cat1.pref,'_',UPPER(a1.Search)) as  item_code
                , a1.ID_src as art_id, a2.ID_src as art_id2
        FROM opti_1603.cat_alt_crossing c
        INNER JOIN opti_1603.cat_alt_articles a1 ON c.ID_art = a1.ID_art
        INNER JOIN opti_1603.cat_alt_articles a2 ON c.ID_cross = a2.ID_art
        INNER JOIN opti_1603.cat_alt_suppliers as s1 on a1.ID_sup=s1.ID_sup
        INNER JOIN cat as cat1 ON cat1.id_tof = s1.ID_src
        INNER JOIN opti_1603.cat_alt_suppliers as s2 on a2.ID_sup=s2.ID_sup
        INNER JOIN cat as cat2 ON cat2.id_tof = s2.ID_src
        where 1=1 
         and a1.Search like '%545156033%' and a1.Search<>'' and cat1.pref='00D'
         union 
        select concat(cat1.pref,'_',UPPER(a1.Search))  as  item_code_crs
                , concat(cat2.pref,'_',UPPER(a2.Search)) as  item_code
                , a2.ID_src as art_id, a1.ID_src as art_id2
        FROM opti_1603.cat_alt_crossing c
        INNER JOIN opti_1603.cat_alt_articles a1 ON c.ID_art = a1.ID_art
        INNER JOIN opti_1603.cat_alt_articles a2 ON c.ID_cross = a2.ID_art
        INNER JOIN opti_1603.cat_alt_suppliers as s1 on a1.ID_sup=s1.ID_sup
        INNER JOIN cat as cat1 ON cat1.id_tof = s1.ID_src
        INNER JOIN opti_1603.cat_alt_suppliers as s2 on a2.ID_sup=s2.ID_sup
        INNER JOIN cat as cat2 ON cat2.id_tof = s2.ID_src
        where 1=1 
         and a2.Search like '%545156033%' and a2.Search<>'' and cat2.pref='00D'union 
	SELECT concat(cc.pref_crs,'_',cc.code_crs) as  item_code_crs
	   ,  concat(cc.pref,'_',cc.code) as item_code 
	   , 0 as art_id, 0 as art_id2
	FROM cat_cross as cc 
	where 1=1 and cc.visible=1
	 and cc.code like '%545156033%'  and cc.pref='00D' ) t 
	LEFT OUTER JOIN cat_cross_stop ccs ON t.item_code=concat(ccs.pref,'_',ccs.code) and t.item_code_crs=concat(ccs.pref_crs,'_',ccs.code_crs)
	WHERE ccs.id IS null