mysql> select reviews.id, items.name as item, author.name as reviewer, rating, body, posted_at from deleted_reviews reviews inner join items on item_id=items.id inner join authors author on author.user_id=reviews.user_id; +-----+----------------------------------------+------------+--------+-----------------------------------------------------------------------------+---------------------+ | id | item | reviewer | rating | body | posted_at | +-----+----------------------------------------+------------+--------+-----------------------------------------------------------------------------+---------------------+ | 298 | Aztechno Dance Party | Killery | 3 | this map is avarage, but why not compelted head map? | 2009-10-01 00:20:35 | | 299 | Balin's Bar Dorf Riot | Killery | 1 | make own map dude. and I dont like dorf riot | 2009-10-01 00:21:24 | | 300 | Chaos v1.0 | Killery | 3 | this is not bad. put over head map on preview plz. | 2009-10-01 00:22:12 | | 301 | Chivitos Parade | Killery | 1 | this is a shit map. dont down load this shit. | 2009-10-01 00:22:48 | | 302 | Cryptic Wightings | Killery | 2 | this map is gothic. and some terrianmap got hacked worse. and no preview. | 2009-10-01 00:24:41 | | 303 | Crypt of the Taken | Killery | 3 | this is not bad. but put overhead map on preview. | 2009-10-01 00:26:10 | | 304 | Flood on the Plains | Killery | 2 | dude. use terrian tools. plains are hooked. | 2009-10-01 00:27:10 | | 305 | For Frostbite Apply Within | Killery | 3 | omfg badland make own maps. I dont like carnage | 2009-10-01 00:28:01 | | 306 | I'll Gimble on your Grave | Killery | 2 | this is grey map why? I dont prefer. | 2009-10-01 00:29:01 | | 307 | Green Paradise 1.1 | Killery | 4 | gj. this is better map dude. well worked. | 2009-10-01 00:29:41 | | 308 | Hills of the Slug | Killery | 2 | terrien map sucks. but color map is not bad. fix it. | 2009-10-01 00:30:19 | | 309 | Jungles of the Ermine | Killery | 4 | gj. this is a nice map. | 2009-10-01 00:30:52 | | 310 | Kings Garden | Killery | 4 | good job duke. I wanna play on this map. | 2009-10-01 00:31:33 | | 311 | Leagues of Suffering | Killery | 3 | lol. make own map plz. and I dont like wwii. so 3. | 2009-10-01 00:32:17 | | 312 | Magmaphobia | Killery | 1 | acking noise map. I will discard this plug. | 2009-10-01 00:32:51 | | 313 | Oxbow II | Killery | 1 | rofl this color map is worse. | 2009-10-01 00:33:35 | | 314 | Picket Fences | Killery | 4 | gj vista. if you didnt add bald headed pewview, I vote it as 5. | 2009-10-01 00:34:23 | | 315 | The River Rhum | Killery | 2 | construction is nice. but some noises are horrible. | 2009-10-01 00:36:30 | | 316 | The Stench of Death | Killery | 1 | rofl wtf. make it better. | 2009-10-01 00:37:12 | | 317 | Titus Groan | Killery | 5 | this is awesome map. | 2009-10-01 00:37:43 | | 318 | Grilling Grounds | Killery | 4 | this is nice map GJ | 2009-10-01 00:48:11 | | 319 | A Very Idiot Halloween | Killery | 3 | hahaha nice one. | 2009-10-01 00:49:03 | | 320 | Till the River Runs Dry | Killery | 4 | this map is kewl | 2009-10-01 00:49:31 | | 321 | Heart of Darkness | Killery | 3 | this is not so good on vista's work. | 2009-10-01 00:51:24 | | 322 | Gimble Head to Head Edition | Killery | 2 | rofl gimbler and URzooked | 2009-10-01 00:52:20 | | 323 | Wanderlust | Killery | 5 | awesome | 2009-10-01 00:52:41 | | 324 | Red Cross | Killery | 2 | this is not good. | 2009-10-01 00:54:27 | | 325 | BarbarianValley Tourney | Killery | 5 | great map | 2009-10-01 00:54:51 | | 326 | Barbarian Valley | Killery | 1 | bug. dl v2 | 2009-10-01 00:55:25 | | 327 | Grim Dawning | Killery | 5 | this map is kewl | 2009-10-01 00:56:15 | | 328 | Hvergelmir | Killery | 5 | nice gj! | 2009-10-01 00:56:37 | | 329 | If I Had a Trow... (Classic) | Killery | 3 | avarage. not worth to dl | 2009-10-01 00:57:07 | | 330 | Knuckle of the Oasis | Killery | 4 | heh nice | 2009-10-01 00:58:26 | | 331 | Keep Across the River | Killery | 3 | hmm. avarage | 2009-10-01 00:59:23 | | 332 | Red Sands | Killery | 3 | not so good on badland maps. | 2009-10-01 00:59:51 | | 333 | Garden of Segesta | Killery | 4 | this map is nice! | 2009-10-01 01:00:17 | | 334 | Polycon-Starships | Killery | 2 | lol | 2009-10-01 01:00:36 | | 335 | Axis vs Allies Megapack | Killery | 4 | nice | 2009-10-01 01:02:44 | | 336 | Killing Grounds 2000 | Killery | 2 | bah | 2009-10-01 01:03:36 | | 337 | Hills of the Crow | Killery | 5 | such a great map. | 2009-10-01 01:04:14 | | 338 | The Ritual Site | Killery | 4 | nice one. | 2009-10-01 01:04:32 | | 339 | Dun Caric | Killery | 5 | fantastic | 2009-10-01 01:06:02 | | 340 | Acts of Piety | Killery | 4 | gj | 2009-10-01 01:07:29 | | 341 | If I had a Yeti... | Killery | 3 | rofl badland | 2009-10-01 01:08:40 | | 342 | The Borogove | Killery | 4 | this is okay map | 2009-10-01 01:10:32 | | 343 | Shuffle off this Mortal Coil | Killery | 4 | great map | 2009-10-01 01:10:51 | | 344 | Mjila | Killery | 5 | awesome map ever. | 2009-10-01 01:11:13 | | 345 | The Barrens | Killery | 5 | gj nice map | 2009-10-01 01:12:28 | | 346 | The Great Divide | Killery | 4 | I dunt like constructions but color map is good | 2009-10-01 01:13:45 | | 347 | Belly of the Beast | Killery | 5 | this is great! | 2009-10-01 01:14:26 | | 348 | Tamaerlin | Killery | 5 | great map | 2009-10-01 01:16:01 | | 349 | Ultimate Team Battles | Killery | 4 | some map is not nice | 2009-10-01 01:17:11 | | 350 | Like Blood Through A Sieve | Killery | 3 | color map is little urgy but nice map | 2009-10-01 01:17:53 | | 351 | Creep on the Borderlands | Killery | 5 | owns | 2009-10-01 01:18:14 | | 352 | Twister 1.3 | Killery | 4 | nice map | 2009-10-01 01:18:37 | | 353 | Whirlwind | Killery | 5 | nice map gj dude | 2009-10-04 07:53:42 | | 354 | Water, Water, Everywhere! | Killery | 1 | stupid shit map. | 2009-10-01 08:25:42 | | 355 | Vamance | Killery | 2 | trees are good. color map sucks | 2009-10-01 08:27:16 | | 356 | The Ultimate Fury | Killery | 1 | worst map ever | 2009-10-01 08:28:20 | | 357 | Triskelion | Killery | 2 | rofl gothic | 2009-10-01 08:28:50 | | 358 | Stone Heart | Killery | 3 | not just bad map | 2009-10-01 08:29:32 | | 359 | StoneHeart RDF | Killery | 1 | five is over rated. just 3 for this | 2009-10-01 08:30:10 | | 360 | Spiral Into The Island | Killery | 4 | nice map dude. | 2009-10-01 08:30:37 | | 361 | Snowhere | Killery | 1 | silly map. cant see head map | 2009-10-01 08:31:15 | | 362 | SIEGE | Killery | 2 | uh. | 2009-10-01 09:05:04 | | 363 | Shattered Earth T.E. | Killery | 5 | this map is really cool. gj. | 2009-10-01 08:34:51 | | 364 | Plains of Muirthemne | Killery | 3 | not just bad. but this river sucks. | 2009-10-01 08:35:35 | | 365 | Motte and Bailey | Killery | 1 | this is damn map. | 2009-10-01 08:37:00 | | 366 | Slay it isn't So! | Killery | 4 | nice. fetch princess is really kewl. | 2009-10-01 08:37:57 | | 367 | In the Crypt of Arianna | Killery | 1 | I dont like this shit map | 2009-10-01 08:40:56 | | 368 | I'll Freeze On Your Grave | Killery | 3 | not very nice. but playable | 2009-10-01 08:41:41 | | 369 | Hills Trodden Black | Killery | 3 | not bad map | 2009-10-01 09:02:43 | | 370 | Piled Higher & Deeper | Killery | 4 | good map | 2009-10-01 08:43:03 | | 371 | Glaciers Retreat | Killery | 1 | shit map | 2009-10-01 08:44:16 | | 372 | Drearr's Glade | Killery | 4 | nice one | 2009-10-01 08:44:59 | | 373 | Defend or Battle | Killery | 5 | souly youre cleaver and such a great map | 2009-10-01 08:46:59 | | 374 | The Cursed Land | Killery | 1 | yeah this shit map is actually cursed by you. | 2009-10-01 08:47:40 | | 375 | Culloden Hill | Killery | 3 | not bad map tho | 2009-10-01 08:48:22 | | 376 | Colosseum of Games | Killery | 1 | lol wtf | 2009-10-01 08:48:48 | | 377 | Clash `n Da Grass | Killery | 2 | hmm. this mesh is sort of... | 2009-10-01 08:49:22 | | 378 | The Chill of Winter | Killery | 1 | man wth. worthless to dl | 2009-10-01 08:50:02 | | 379 | The Chalk Hills: Redux | Killery | 4 | oh man this is nice map | 2009-10-01 08:50:46 | | 380 | Castle Defence | Killery | 1 | not acutual castal and worse mesh | 2009-10-01 08:51:23 | | 381 | Calieach'Val | Killery | 1 | acking noisy shit map | 2009-10-01 08:52:34 | | 382 | Blood on the Dance Floor | Killery | 2 | well. make it better | 2009-10-01 08:53:06 | | 383 | Animal Farm | Killery | 1 | rofl. not good. | 2009-10-01 08:55:07 | | 384 | A Deal with the Darkness | Killery | 1 | wth. into the | 2009-10-01 08:56:45 | | 385 | Temple of the Damned | Killery | 4 | this is not bad map. gj | 2009-10-04 07:50:21 | | 386 | Wasteland Arena | Killery | 4 | nice sort of | 2009-10-04 07:50:54 | | 387 | Green Acres | Killery | 5 | great nj | 2009-10-04 07:55:56 | | 388 | TheQuad | Killery | 3 | I like this map | 2009-10-04 07:56:32 | | 389 | Eyrie | Killery | 5 | cool nice work | 2009-10-04 07:58:01 | | 390 | Rank and Defiled | Killery | 4 | nice map | 2009-10-04 07:58:24 | | 391 | To Kill a Mockingbird | Killery | 4 | gud thin | 2009-10-04 07:59:47 | | 392 | 19th Hole | Killery | 1 | wtf | 2009-10-04 09:03:13 | | 393 | A Borderland Odyssey | Killery | 2 | :( | 2009-10-04 09:03:54 | | 394 | A Calling Ktulu | Killery | 4 | nice map dude! | 2009-10-04 09:06:44 | | 395 | A Poison Holiday Tournament Edition | Killery | 5 | great map man! | 2009-10-04 09:07:17 | | 396 | Battle of the Alamo | Killery | 1 | venice :( | 2009-10-04 09:09:22 | | 397 | All Headed For Rune United | Killery | 2 | many noises | 2009-10-04 09:09:52 | | 398 | Arena Quatro | Killery | 2 | not so good | 2009-10-04 09:11:11 | | 399 | Around the Bend | Killery | 3 | not bad | 2009-10-04 09:13:24 | | 400 | Azkruic Epoch | Killery | 2 | nothing special | 2009-10-04 09:14:57 | | 401 | Backstreet Brawl | Killery | 1 | gay map | 2009-10-04 09:15:29 | | 402 | Bald Hill | Killery | 3 | playable | 2009-10-04 09:17:18 | | 403 | Blood Dunes | Killery | 1 | crappass | 2009-10-04 09:18:36 | | 404 | Distant Sands | Killery | 3 | not just bad | 2009-10-04 09:20:12 | | 405 | Four Seasons 2 | Killery | 1 | stupid noise | 2009-10-04 09:21:36 | | 406 | Gardens of Aja | Killery | 4 | nice one | 2009-10-04 09:23:12 | | 407 | Helm's Deep | Killery | 1 | there is no good | 2009-10-04 09:25:46 | | 408 | High Plains Havoc | Killery | 1 | noob map | 2009-10-04 09:26:26 | | 409 | Ice in the Veins | Killery | 1 | I wanna vote it as 3 but currently 4 so voted 1 | 2009-10-04 09:28:02 | | 410 | In the Machine | Killery | 2 | good effort but no fun | 2009-10-04 09:31:10 | | 411 | Lost on Ice | Killery | 3 | not bad tho mountains suck | 2009-10-04 09:32:37 | | 412 | OdM ThrallanD | Killery | 3 | water is very noisy except that 4 rating | 2009-10-04 09:36:29 | | 413 | Out of Kilter | Killery | 1 | very noisy map 1.5 rate | 2009-10-04 09:37:48 | | 414 | Serpent Downs | Killery | 1 | wtf wtf shit | 2009-10-04 09:38:52 | | 415 | Sounds of the Night | Killery | 1 | this aint good | 2009-10-04 09:40:24 | | 416 | Spectres in the Crypt | Killery | 3 | this isnt bad but too simple | 2009-10-04 09:42:14 | | 417 | Still Life With Warrior | Killery | 1 | wth damnit | 2009-10-04 09:42:50 | | 418 | Taliesin Downs | Killery | 4 | nice map and units gj | 2009-10-04 09:44:27 | | 419 | Talus | Killery | 4 | this is an interesting map | 2009-10-04 09:46:34 | | 420 | The Bar Room Brawl | Killery | 3 | this is not bad but too small map | 2009-10-04 09:48:06 | | 421 | The Four Leaved Fen | Killery | 4 | this is a playable map | 2009-10-04 09:49:28 | | 422 | The Rock | Killery | 2 | hmm the map rasing is wrong | 2009-10-04 09:50:50 | | 423 | Walls of War | Killery | 2 | overhead map is kewl mesh is horrible | 2009-10-04 09:52:16 | | 424 | Winter of Your Discontent | Killery | 2 | not bad tho I wont play this | 2009-10-04 09:53:48 | | 624 | Majestic Falls | Juliocpaes | 1 | Kryptos, Good "color map", you do not have a version in "single-player"? | 2012-05-20 20:27:58 | | 628 | Majestic Falls | Zaknafein | 1 | This should really have a solo. | 2012-05-27 20:42:57 | | 629 | Diablo - Tristram Town - Version Myth. | Zaknafein | 5 | amazing plugin | 2012-05-28 16:48:28 | | 630 | Raisin BarnII 1.2 for MWC 2012 | Zaknafein | 5 | | 2012-05-28 17:28:07 | | 631 | If I Had Lederhosen | Zaknafein | 5 | | 2012-05-28 17:28:13 | | 632 | Pleasant Valley Sunday | Zaknafein | 5 | | 2012-05-28 17:28:21 | | 633 | Under Muirthemne | Zaknafein | 5 | | 2012-05-28 16:49:59 | | 634 | Valley Of Rivers | Zaknafein | 5 | | 2012-05-28 16:50:10 | | 635 | Temple Of Doom | Zaknafein | 5 | | 2012-05-28 16:50:20 | | 636 | Sedimental Flora | Zaknafein | 5 | | 2012-05-28 16:50:31 | | 637 | Brave the Ghenjiwash | Zaknafein | 5 | | 2012-05-28 16:50:41 | | 638 | The Ledges Between Us | Zaknafein | 5 | | 2012-05-28 16:50:50 | | 639 | Baron's Backyard | Zaknafein | 5 | | 2012-05-28 16:50:58 | | 640 | The Pit of Fiends | Zaknafein | 5 | | 2012-05-28 16:51:10 | | 641 | Green Berets Jungle Factions | Zaknafein | 5 | | 2012-05-28 16:51:20 | | 642 | Strange Shallows | Zaknafein | 5 | | 2012-05-28 17:29:24 | +-----+----------------------------------------+------------+--------+-----------------------------------------------------------------------------+---------------------+ 143 rows in set (0.00 sec)