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