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