Select T0.ItemCode, T2.CardCode, " +
                                              "ISNULL((SELECT Price FROM ITM1 WHERE ItemCode = '" + ItemCode + "' AND PriceList = '2'),0)," +
                                              "ISNULL((SELECT X.Price FROM ITM1 X WHERE PriceList = T2.ListNum AND X.ItemCode = '301'),0)," +
                                              "T2.U_UmbracoID " +
                                       "FROM OITM T0 LEFT JOIN OINS T1 ON T0.ItemCode = T1.itemCode " +
                                                    "LEFT JOIN OCRD T2 ON T1.customer = T2.CardCode " +
                                       "WHERE T0.U_FachGroesse = (SELECT T11.U_FachGroesse FROM OITM T11 WHERE T11.ItemCode = '" + ItemCode + "') AND " +
                                             "T0.ItemCode <> '" + ItemCode + "' " +
                                       "GROUP BY T2.CardCode, T0.ItemCode, T2.U_UmbracoID, T2.ListNum