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] => 9272
[18] => 14788
[19] => 9221
[20] => 9112
[21] => 20769
[22] => 9106
[23] => 9226
[24] => 9229
[25] => 31261
[26] => 9188
[27] => 9317
[28] => 9243
[29] => 9340
[30] => 9155
[31] => 9289
[32] => 9325
[33] => 9157
[34] => 9110
[35] => 9198
[36] => 9302
[37] => 9196
[38] => 23288
[39] => 9115
[40] => 9111
[41] => 9097
[42] => 9311
[43] => 9117
[44] => 9161
[45] => 9096
[46] => 9336
[47] => 9118
[48] => 9224
[49] => 9257
[50] => 11920
[51] => 13206
[52] => 12212
[53] => 9307
[54] => 9267
[55] => 9319
[56] => 9193
[57] => 9295
[58] => 18453
[59] => 23330
[60] => 9141
[61] => 9149
[62] => 9252
[63] => 9122
[64] => 14828
[65] => 9163
[66] => 9313
[67] => 9164
[68] => 26447
[69] => 9104
[70] => 9134
[71] => 9212
[72] => 9133
[73] => 9274
[74] => 9280
[75] => 20856
[76] => 32835
[77] => 12733
[78] => 9234
[79] => 9126
[80] => 9321
[81] => 9138
[82] => 9209
[83] => 9334
[84] => 29681
[85] => 9219
[86] => 9166
[87] => 9168
[88] => 9216
[89] => 28760
[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] => 26090
[103] => 9187
[104] => 22252
[105] => 9208
[106] => 14250
[107] => 9263
[108] => 13873
[109] => 23252
[110] => 9127
[111] => 9147
[112] => 9190
[113] => 9237
[114] => 13184
[115] => 9327
[116] => 29150
[117] => 9239
[118] => 9095
[119] => 9246
[120] => 9151
[121] => 9282
[122] => 9129
[123] => 9297
[124] => 21653
[125] => 9305
[126] => 9217
[127] => 13895
[128] => 9183
[129] => 9192
[130] => 9248
[131] => 12416
[132] => 13931
[133] => 9250
[134] => 29202
[135] => 9310
[136] => 9299
[137] => 29199
[138] => 23342
[139] => 9261
[140] => 9269
[141] => 9131
[142] => 9195
[143] => 9200
[144] => 9214
[145] => 14321
[146] => 9099
[147] => 9329
[148] => 9254
[149] => 9284
[150] => 9287
)