SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_icl_translations ON wp_posts.ID = wp_icl_translations.element_id WHERE wp_posts.post_type = 'bad' AND wp_posts.post_status = 'publish' AND wp_icl_translations.language_code = 'de' GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC

Array
(
    [0] => 9153
    [1] => 33742
    [2] => 35334
    [3] => 9241
    [4] => 9315
    [5] => 9108
    [6] => 9227
    [7] => 9125
    [8] => 9159
    [9] => 9136
    [10] => 9102
    [11] => 17058
    [12] => 9341
    [13] => 16033
    [14] => 15938
    [15] => 9179
    [16] => 9270
    [17] => 13199
    [18] => 9338
    [19] => 9272
    [20] => 14788
    [21] => 9221
    [22] => 9112
    [23] => 20769
    [24] => 9106
    [25] => 9226
    [26] => 9229
    [27] => 31261
    [28] => 9188
    [29] => 9317
    [30] => 9243
    [31] => 9340
    [32] => 9155
    [33] => 9289
    [34] => 9325
    [35] => 9157
    [36] => 9110
    [37] => 9198
    [38] => 9302
    [39] => 9196
    [40] => 23288
    [41] => 9115
    [42] => 9111
    [43] => 9097
    [44] => 9311
    [45] => 9117
    [46] => 9161
    [47] => 9096
    [48] => 9336
    [49] => 9118
    [50] => 9224
    [51] => 9257
    [52] => 11920
    [53] => 13206
    [54] => 12212
    [55] => 9307
    [56] => 9267
    [57] => 9319
    [58] => 9193
    [59] => 9295
    [60] => 18453
    [61] => 23330
    [62] => 9141
    [63] => 9149
    [64] => 9252
    [65] => 9122
    [66] => 14828
    [67] => 9163
    [68] => 9313
    [69] => 9164
    [70] => 26447
    [71] => 9104
    [72] => 9134
    [73] => 9212
    [74] => 9133
    [75] => 9274
    [76] => 9280
    [77] => 20856
    [78] => 32835
    [79] => 12733
    [80] => 9234
    [81] => 9126
    [82] => 9321
    [83] => 9138
    [84] => 9209
    [85] => 9334
    [86] => 29681
    [87] => 9219
    [88] => 9166
    [89] => 9168
    [90] => 9216
    [91] => 28760
    [92] => 12706
    [93] => 33124
    [94] => 9290
    [95] => 9169
    [96] => 9278
    [97] => 9264
    [98] => 9279
    [99] => 9323
    [100] => 9143
    [101] => 9124
    [102] => 9145
    [103] => 9210
    [104] => 9236
    [105] => 26090
    [106] => 9187
    [107] => 22252
    [108] => 9208
    [109] => 14250
    [110] => 9263
    [111] => 13873
    [112] => 23252
    [113] => 9127
    [114] => 9147
    [115] => 9190
    [116] => 9237
    [117] => 13184
    [118] => 9327
    [119] => 29150
    [120] => 9239
    [121] => 9095
    [122] => 9246
    [123] => 9151
    [124] => 9282
    [125] => 9129
    [126] => 9297
    [127] => 21653
    [128] => 9305
    [129] => 9217
    [130] => 13895
    [131] => 9183
    [132] => 9192
    [133] => 9248
    [134] => 12416
    [135] => 13931
    [136] => 9250
    [137] => 29202
    [138] => 9310
    [139] => 9299
    [140] => 29199
    [141] => 23342
    [142] => 9261
    [143] => 9269
    [144] => 9131
    [145] => 9195
    [146] => 9200
    [147] => 9214
    [148] => 14321
    [149] => 9329
    [150] => 9254
    [151] => 9284
    [152] => 9287
)