SELECT     a.sys_pk AS sys_pk,
                               m.sys_pk AS mat,
                               p.sys_pk AS pr,
                               pg.sys_pk AS pg_sys_pk,
                               s.sys_pk AS sys,
                               c.sys_pk AS ca,
                               sca.sys_pk as sca_sys_pk,
                               ssp.sys_pk as ssp_sys_pk,
                               sse.sys_pk as sse_sys_pk,
                               a.asset_original AS asset_original,
                               ml.sys_pk AS ml_sys_pk,
                               pl.sys_pk AS pl_sys_pk,
                               sl.sys_pk AS sl_sys_pk,
                               wpi.sys_pk AS wpi_sys_pk,
                               sb.sys_pk AS sb_sys_pk,
                               off.sys_pk AS off_sys_pk,
                               pb.sys_pk AS pb_sys_pk,
                               pgb.sys_pk AS pgb_sys_pk

                    FROM       t_adb_assets AS a

                    LEFT JOIN  t_pdb_material AS m
                    ON         m.fk_adb_asset = a.sys_pk

                    LEFT JOIN  t_pdb_produkt AS p
                    ON         p.fk_adb_asset = a.sys_pk

                    LEFT JOIN  t_pdb_produkt_gruppen AS pg
                    ON		   pg.fk_adb_asset = a.sys_pk	

                    LEFT JOIN  t_pdb_systeme AS s
                    ON         s.fk_adb_asset = a.sys_pk

                    LEFT JOIN  t_countries AS c
                    ON         c.flag_picture = a.sys_pk

                    LEFT JOIN  t_sem_companies AS sca
                    ON 	       sca.fk_adb_asset = a.sys_pk

                    LEFT JOIN  t_sem_sparten AS ssp
                    ON 	       ssp.fk_adb_asset = a.sys_pk

                    LEFT JOIN  t_sem_seminare AS sse
                    ON 	       sse.fk_adb_asset_logo = a.sys_pk

                    LEFT JOIN  t_pdb_material_live AS ml
                    ON         ml.fk_adb_asset = a.sys_pk

                    LEFT JOIN  t_pdb_produkt_live AS pl
                    ON         pl.fk_adb_asset = a.sys_pk

                    LEFT JOIN  t_pdb_systeme_live AS sl
                    ON         sl.fk_adb_asset = a.sys_pk

                    LEFT JOIN  t_ww_picture AS wpi
                    ON         wpi.fk_adb_asset = a.sys_pk

                    LEFT JOIN  tr_pdb_systeme_bausteine AS sb
                    ON         sb.fk_adb_asset = a.sys_pk

                    LEFT JOIN  t_offices AS off
                    ON         off.fk_adb_logo = a.sys_pk

                    LEFT JOIN  t_pdb_produkt_bilder AS pb
                    ON         pb.fk_adb_asset = a.sys_pk

                    LEFT JOIN  t_pdb_produkt_gruppen_bilder AS pgb
                    ON         pgb.fk_adb_asset = a.sys_pk

                    WHERE      a.sys_pk = 1023678 
                    LIMIT 0,1;
Asset 1023678 kann nicht gedownloaded werden