SELECT idauftragsposition, fk_auftrag, fk_posart, artikelgruppe, apo_position, apo_nummer, apo_name, apo_beschreibung,
IF(fk_posart=2,"",apo_mengeneinheit) AS apo_mengeneinheit,
IF(fk_posart=2,"",apo_menge) AS apo_menge,
IF(fk_posart=2,"",apo_leistungsdatum) AS apo_leistungsdatum,
apo_mitarbeiter,
IF(fk_posart=2,"",concat(format(steuersatz,2,"DE_de"),IF(fk_posart<>2,"%",""))) AS steuersatz,
fk_color, colorn, colorh, colornfont, colorhfont,
IF(fk_posart=2,"",concat(IF(fk_posart=3,"(",""),format(round(apo_menge *(apo_lohn + apo_service + apo_material + apo_geraet + apo_fremdleistung),2),2,"DE_de"),IF(fk_posart=1,"€",""),IF(fk_posart=3,"€)",""))) AS SNetto,
IF(fk_posart=2,"",concat(IF(fk_posart=3,"(",""),format(round(apo_menge *(apo_lohn + apo_service + apo_material + apo_geraet + apo_fremdleistung) * (Steuersatz/100),2),2,"DE_de"),IF(fk_posart=1,"€",""),IF(fk_posart=3,"€)",""))) AS SSteuer,
IF(fk_posart=2,"",concat(IF(fk_posart=3,"(",""),format(round(apo_menge *(apo_lohn +apo_service + apo_material + apo_geraet + apo_fremdleistung) * (1+(Steuersatz/100)),2),2,"DE_de"),IF(fk_posart=1,"€",""),IF(fk_posart=3,"€)",""))) AS SBrutto,
IF(fk_posart=2,"",concat(IF(fk_posart=3,"(",""),format(round(apo_lohn + apo_service + apo_material +apo_geraet + apo_fremdleistung,2),2,"DE_de"),IF(fk_posart=1,"€",""),IF(fk_posart=3,"€)",""))) AS EPNetto
FROM AuftragsPositionen LEFT JOIN Steuersaetze ON fk_steuersatz = idsteuersatz
LEFT JOIN ArtikelGruppen ON fk_artikelgruppe=idartikelgruppe LEFT JOIN Colors ON idcolor = fk_color