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