LINQ to SQL: Aggregations on multiple columns without any grouping

I think the title speaks for itself. I want to create a LINQ query with aggregations on multiple columns where no grouping is applied. This is just something that can be done very simple in plain SQL.

1 SELECT 2 MAX(HorsePower), 3 AVG(Weight) 4 FROM 5 Car

But when you want to create a construction that's similar in LINQ you will get an compilation error, because of a wrong syntax.

1 var result = from car in sut.Cars 2 select new 3 { 4 MaxHorsePower = car.Max(p => p.HorsePower), 5 AverageWeight = car.Average(p => p.Weight) 6 };

The trouble is that this doesn't work. You can do an aggregation on an complete set, like the following. This will result in just two queries.

1 var result2 = (from car in sut.Cars select car.HorsePower).Max(); 2 var result3 = (from car in sut.Cars select car.Weight).Average();

You can actually do multiple aggregations at once when using groups. The sad thing is, we don't always have something to group on. But that can be solved.

1 var result = (from car in 2 (from car in sut.Cars 3 select new 4 { 5 car.HorsePower, 6 car.Weight, 7 Dummy = string.Empty 8 }) 9 group car by new {car.Dummy} 10 into dummyGroup 11 select new 12 { 13 MaxHorsePower = dummyGroup.Max(p => p.HorsePower), 14 AverageWeight = dummyGroup.Average(p => p.Weight) 15 }).Single();

This solution adds a dummy column called 'Dummy' with the same value for every record. Because this value is the same for every record we can safely group on it and expect to have only one group. This solution makes sure we have one query for the database, but with the use of a workaround.

I would say yes this works, but for readability I would not suggest the use of this workaround for the trivial problem above. By using two queries we have a very manageable solution that's readable from code. The workaround needs at least some comments before we can totally understand it as someone new to the workaround.

But it in the end we can also say, we now know how we can fake the grouping. Use it with care, as I mentioned because of the manageability of your code.

  • Gravatar nuove timberland July 28th, 2014 at 02:49
    But lots of people buy lovely shoes, wear them twice and decide it's not happening for whatever reason. Two months or twenty years later they are dumped at thrift shops, where horse traders like me buy them and sell them to you for a very reasonable price, etc.
  • Gravatar ray ban 4075 August 10th, 2014 at 08:39
    Gains around two thousand electors with the transfer of Southern Mallee District Council and the balance of Karoonda East Murray District Council from Hammond. For the decade prior to 1973, Chaffey had been a marginal seat. When the seat was won by Labor's Arthur Curran in 1962, it deprived Premier Tom Playford of the opportunity for one last redistribution, leading directly to the election of the first Labor government in more than four decades at the 1965 election. Three year's later, Curran's defeat deprived the first Dunstan government of its majority, but he won the seat back on new boundaries in 1970 before losing for the last time in 1973. With the end of rural malapportionment, Chaffey gained more rural areas, and with the anti Labor mood created by the Whitlam era, along with Labor being less reliant on winning rural seats, Chaffey slipped permanently into the non Labor fold. It was held by the Liberal 's Peter Arnold from 1973 until his retirement in 1993, when it was won narrowly by his successor Kent Andrews, holding off a strong challenge from the National and an independent. With a higher profile National candidate in Karlene Maywald in 1997, Andrews was defeated, a critical loss as it deprived the Olsen government of a clear majority in Parliament. Maywald increased her majority in 2002, polling 49.2% of the first preference vote and achieving an 11.5% swing after preferences. She voted in favour of the Liberal 's nominee for Speaker after the 2002 election and sat on the cross benches after the formation of the Rann government. Ahead of the 2004 Federal election, there was talk that Maywald would resign to contest the Federal seat of Barker. Had she made the move, Chaffey would have returned to the Liberal fold, weakening the position of the Rann government in the House of Assembly. Instead, Maywald was offered a seat in Cabinet, including portfolio responsibility for the biggest issue in her electorate, the state of the Murray River. The Cabinet deal saw Maywald stay on as a Minister after the Rann government's landslide re election in 2006. Maywald increased her vote further at the 2006 election, but with the Rann government's popularity declining at the 2010 election, Maywald found herself the focus for criticism of the government and lost Chaffey to the Liberal 's Tim Whetstone.Past ResultsThe graph of past results clearly shows that Chaffey is around 20 percentage points stronger for the Liberal than South Australia as a whole. However, as the Green line shows, Chaffey could still leave the Liberal fold, with the National 's Karlene Maywald easily winning the seat in 1997, 2002 and 2006.2014 Ballot Paper (4 Candidates)The GreensAustralian Labor Family First Liberal Liberal Whetstone started his work life as a fitter and turner, working his way up to be a Project Manager in the Moomba gas fields. He also worked on developing his own business building and restoring muscle cars and boats. He moved to the Riverland in 1989 where he started his citrus and wine grape business. Whetstone runs a farm at Renmark and is also Chairman of the South Australian Murray Irrigators. He won this seat at the 2010 election by defeating National incumbent Karlene Maywald.ABC Radio National Australian Broadcasting Corporation
  • Gravatar 2080 August 23rd, 2014 at 03:22
    Voir en ligne : cheap new era caps
  • Gravatar domain August 30th, 2014 at 08:07
    Wonderful goods from you, man. I have understand your stuff previous to and you are just extremely excellent.
    I actually like what you've acquired here, certainly
    like what you're stating and the way in which you say it.
    You make it enjoyable and you still take care of to keep it wise.
    I can't wait to read far more from you. This is actually a tremendous web
    site.
  • Gravatar basement diy white mold removal September 19th, 2014 at 13:11
    Hi there Deaг, are you genuinely viisiting this web page dailу, if so afterward уou will
    without doubt obtain pleɑsant knowledge.
  • Gravatar Jonnie A. Corujo September 26th, 2014 at 23:09
    hi!,I like your writing very so much! proportion we keep
    in touch more approximately your article on AOL? I require a
    specialist on this area to unravel my problem. Maybe that's you!

    Looking forward to look you.
  • Gravatar Sandy V. Dwelley September 30th, 2014 at 06:46
    First off I would like to say fantastic blog! I had a quick question which I'd like to ask if you do
    not mind. I was interested to find out how you center yourself and clear your head prior to writing.

    I've had trouble clearing my mind in getting my thoughts out.
    I do enjoy writing but it just seems like the first 10 to
    15 minutes are lost simply just trying to figure
    out how to begin. Any suggestions or tips? Thanks!
  • Gravatar inch snowflake mirage October 26th, 2014 at 22:50
    I blog quite often and I really appreciate your information. Your article has truly peaked my interest.
    I will book mark your blog and keep checking for new details about once a week.
    I opted in for your Feed as well.
  • Gravatar see more June 8th, 2015 at 09:42
    Because of this, you want to attain as much gold as possible as quickly as you can. Once you know what
    is for sale pay attention to how long it has been up for sale, and pay
    particular attention to what is selling fast. Using Google on research about
    where to buy cheap wow gold, below is an overview of the top 5 results of sites offering Wo - W gold services from the search where to buy
    cheap Wo - W gold:.
  • Gravatar hdv 7 farming February 22nd, 2016 at 15:45
    For anyone interested: Anti-Vaxers largley came to exist as a movement during the 18th centuries when the smallpox
    vaccine was developed.
  • Gravatar linyuan March 14th, 2016 at 07:28
    linyuan0314
    http://www.policesunglasses.us.com
    http://www.cartieroutlet.us.com
    http://www.cazal.us.com
    http://www.chromehearts-outlet.comg drtg
    http://www.chanelsunglasses.in.net
    http://www.burberrysunglasses.us.com
    http://www.versacesunglasses.us.com
    http://www.cartierwatches.us.com
    http://www.chromeheartsoutlet.in.net
    http://www.pradasunglasses.us.com
    http://www.dior.us.com
    http://www.cartier.us.com
    http://www.guccisunglasses.us.com
    http://www.louisvuittonsunglasses.us.com
  • Gravatar Thomasfut April 9th, 2016 at 02:30
    http://venusianarts.com.php53-5.ord1-1.websitetestlink.com/define-an-essay Define an essay http://www.finalsalary.co.uk/anti-essay-customer-service Anti essay customer service http://www.finalsalary.co.uk/thesis-stament Thesis stament http://mgconsulting.cl/career-goal-essay Career goal essay http://urbanfoodexperience.com/purchase-thesis Purchase thesis http://www.crewslasercenter.com/essay-writing-for-highschool-students Essay writing for highschool students http://mgconsulting.cl/networking-research-papers Networking research papers http://www.finalsalary.co.uk/why-mba-essay Why mba essay http://texaslre.org/?p=what-is-the-best-essay-writing-services What is the best essay writing services http://www.crewslasercenter.com/essay-academic-writing Essay academic writing http://www.finalsalary.co.uk/requirements-for-nyu-admission Requirements for nyu admission http://texaslre.org/?p=how-to-buy-a-phd How to buy a phd http://www.crewslasercenter.com/after-your-introduction-each-paragraph-of-your-essay-should After your introduction each paragraph of your essay should http://mgconsulting.cl/wirte-my-papw Wirte my papw http://www.crewslasercenter.com/good-sentence-starters-for-essays Good sentence starters for essays http://urbanfoodexperience.com/rabbit-proof-fence-essay Rabbit proof fence essay http://urbanfoodexperience.com/essay-on-money-isnt-everything-in-life Essay on money isnt everything in life http://venusianarts.com.php53-5.ord1-1.websitetestlink.com/why-i-must-do-my-homework Why i must do my homework http://www.crewslasercenter.com/annie-dillard-essay Annie dillard essay http://texaslre.org/?p=personal-statement-essay Personal statement essay http://texaslre.org/?p=writing-cause-and-effect-essay Writing cause and effect essay http://www.finalsalary.co.uk/hku-personal-statement Hku personal statement http://venusianarts.com.php53-5.ord1-1.websitetestlink.com/geography-writing-help Geography writing help http://venusianarts.com.php53-5.ord1-1.websitetestlink.com/essay-writing-experts Essay writing experts http://mgconsulting.cl/write-my-term-paper Write my term paper http://www.crewslasercenter.com/do-the-right-thing-essay Do the right thing essay http://mgconsulting.cl/writing-a-reference-letter-for-a-student Writing a reference letter for a student http://www.finalsalary.co.uk/university-assignment-help-australia University assignment help australia http://urbanfoodexperience.com/buy-history-eassy Buy history eassy http://mgconsulting.cl/first-impressions-essay First impressions essay http://urbanfoodexperience.com/college-level-research-paper College level research paper http://venusianarts.com.php53-5.ord1-1.websitetestlink.com/cheap-essey-writing Cheap essey writing http://www.finalsalary.co.uk/purchase-cheap-argumentative-essays-online Purchase cheap argumentative essays online http://urbanfoodexperience.com/what-is-the-best-custom-essay-accept-visa What is the best custom essay accept visa http://www.finalsalary.co.uk/science-help.com Science help.com
  • Many thanks Lindsay. Though it looks like along way I remember the night. Hoping you and your Mummy properly.
    Watch Toto en zijne zuster te Brussel ( 2000 ) Online HD 1080p http://maiksmovie.com/toto-en-zijne-zuster-te-brussel- (-2000-)_279527/
  • Gravatar betamp3skull.com June 1st, 2016 at 09:37
    Yes! Finally someone writes about neewcastle under lyme
    teeth whitening.
  • Gravatar videoraq.com June 1st, 2016 at 12:35
    Hi there, i read your blog fom tike to time and i oown a similar one and i was just curious if you get a lot of spam feedback?
    If so howw do you protect against it, any plugin or
    anything you can suggest? I get so much lately it's driving me insane
    so any support is very much appreciated.
  • Gravatar teeth whitening June 1st, 2016 at 20:52
    If you are going for finest contents like I do, just go to
    see this web site daily as it ofdfers feature contents, thanks
  • Heyy there, You've dopne an incredible job. I will certainly digg
    it and personally recommend to my friends. I am sure they will be benefited froim this web site.
  • Gravatar cosmetic dentist June 2nd, 2016 at 03:34
    Howdy I amm so delighted I found your website,
    I really found you by mistake, while I was researching on Google
    for something else, Anyhow I am here noww and would just lime to say thanks for
    a maarvelous post andd a alll round thrilling blog (I
    also love the theme/design), I don't have time to rewad through it all at the moment buut I have book-marked it and also added your
    RSS feeds, so when I have time I will be back to read much
    more, Please do keep up the superb work.
  • Gravatar peterskap June 5th, 2016 at 21:20
    Google chrome logo 666
    <a href= http://de-edapotheke.com/blog/wp-content/uploads/2016/05/google666.jpg>
    <IMG> http://de-edapotheke.com/blog/wp-content/uploads/2016/05/google666.jpg</IMG>
    </a>
  • Gravatar peterskap June 5th, 2016 at 21:24
    Google chrome logo 666
    <a href= http://de-edapotheke.com/blog/wp-content/uploads/2016/05/google666.jpg>
    <IMG> http://de-edapotheke.com/blog/wp-content/uploads/2016/05/google666.jpg</IMG>
    </a>
  • Gravatar clay tempered sword June 6th, 2016 at 04:15
    Adorable! Thx
  • Gravatar real samurai swords June 6th, 2016 at 04:15
    Great communication with seller.
  • Gravatar katana blade June 29th, 2016 at 01:17
    Fast shipping...recommend... item as promised
  • Gravatar samurai swords June 29th, 2016 at 01:17
    Super fast shipping. Excellent product.
  • Gravatar samurai swords June 29th, 2016 at 06:18
    Great communication with seller.
  • Gravatar katana swords June 29th, 2016 at 23:23
    Thanks!!! Super Fast!!! Great seller!!!
  • Gravatar handmade swords June 30th, 2016 at 03:13
    Item exactly as decribed...Fast shipping. Will repeat business
  • Gravatar handmade japanese swords June 30th, 2016 at 07:36
    Article juste comme décrit , est arrivé rapidement et en toute sécurité . Merci
  • Gravatar katana samurai sword June 30th, 2016 at 13:27
    Fast Shipping. Item as described.
  • Gravatar verhuisbedrijven in de regio July 23rd, 2016 at 04:08
    Verhuizen

    Mocht jij gaan verhuizen is 't van belang dat dit zorgvuldig geschied,
    ten slotte draait dit omwille jouw bruikbare rommel. Wij raden daarom ook aan om een onderneming
    te vinden die zorgvuldig gecertificeerd zijn.
    Één dergelijke onderneming kun jij evenzo identificeren met
    hun referenties. Wellicht heb je deze certificaten wel is eerder voorbij zien komen, toch vaak zie je deze op
    verhuiswagens bij desbetreffende verhuisfirma's.
    Kwaliteit is vaak ook te onderscheiden aan de certificaten, jij weet bij 't selecteren van zo één onderneming dat ze het waar hebben kunnen maken. We raden aan dan evenzo ten alle
    tijden te kijken voor organisaties die een keurmerk dragen.
  • Gravatar samurai swords July 28th, 2016 at 10:45
    just what I wanted
  • Gravatar battle ready swords July 29th, 2016 at 04:22
    Merci !
  • Gravatar japanese samurai July 29th, 2016 at 04:22
    Merci pour la livraison rapide .
  • Gravatar Samurai Katana July 30th, 2016 at 12:07
    Great little shoe charm, fast shipping, thanks!!
  • Gravatar Katana swords July 30th, 2016 at 12:07
    very nice item, good communication, fast shipping
  • Gravatar japanese katana swords July 30th, 2016 at 15:46
    Merci pour ce super livraison rapide !
  • Gravatar handmade wakizashi swords July 31st, 2016 at 07:32
    Just what I wanted &amp;amp; super fast shipping! Thank-you!
  • Gravatar caly tempered katana July 31st, 2016 at 07:32
    Just as described and promt delivery. Thanks!
  • Gravatar Buy Saya August 1st, 2016 at 16:19
    magnifique ! je vous remercie!
  • Gravatar Buy Tanto August 1st, 2016 at 16:19
    Merci pour une grande transaction ...
  • Gravatar japanese katana August 2nd, 2016 at 05:04
    fast shipment - no problems
  • Gravatar Buy Tsukas August 2nd, 2016 at 07:52
    expédition rapide! Produit était parfait. Amazing seller !
  • Gravatar Chinese Swords August 2nd, 2016 at 14:08
    Very fast shipping, great item.
  • Gravatar katana Sword August 3rd, 2016 at 02:46
    livraison rapide! génial!
  • Gravatar katana Swords August 3rd, 2016 at 02:46
    Awesome! Livraison rapide . A + + + + +
  • Gravatar katana Sword August 3rd, 2016 at 05:33
    Great item, great experience. Really quick shipping.
  • Gravatar caly tempered katana August 3rd, 2016 at 05:33
    GREAT SERVICE!!!
  • Gravatar Samurai Sword August 3rd, 2016 at 06:11
    Thanks for fast shipping &amp;amp; delivery; recommend seller! Cute switch shoe!
  • Gravatar tanto samurai swords August 3rd, 2016 at 06:11
    Very nice Seller, very happy with item, super-fast shipping, thank you!!!
  • Gravatar caly tempered katana August 3rd, 2016 at 07:01
    beaucoup. merci beaucoup!
  • Gravatar japanese samurai August 3rd, 2016 at 10:23
    Great Seller~quickly shipped and beautiful item. Thanks.
  • Gravatar katana swords August 3rd, 2016 at 10:23
    Exactly as described THANK YOU!!!
  • Gravatar japanese samurai katana August 3rd, 2016 at 19:13
    Aimez la chaussure! Livraison rapide! Tr猫s bon 茅tat !
  • Gravatar japanese samurai katana August 4th, 2016 at 10:16
    Excellent transaction ! Exp茅dition rapide , article comme promis. Merci ! ! ! !
  • Gravatar Folded Steel Japanese Sword August 4th, 2016 at 16:12
    Exp茅dition rapide superbe ! Grande marchandises comme promis ! A + + + +
  • Gravatar clay tempered sword August 4th, 2016 at 19:26
    Grande expérience . Livraison rapide et produit exactement comme promis.
  • Gravatar Samurai Sword August 5th, 2016 at 10:10
    Great service!
  • Gravatar samurai katana August 6th, 2016 at 08:45
    Article comme décrit , merci! Great seller!
  • Gravatar katana swords August 7th, 2016 at 02:53
    Excellent Service!! Fast Shipping!!!!!!!!!! A+++++++
  • Gravatar katana Sword August 7th, 2016 at 06:57
    A + + + + + + + + +
  • Gravatar clay tempered katana August 7th, 2016 at 09:11
    C'est vraiment un film tr猫s dr么le, mais vieux !
  • Gravatar samurai swords August 7th, 2016 at 13:36
    Great transaction and seller - fast delivery! Handshoe is beautiful! Thank you!
  • Gravatar Swords Bag August 7th, 2016 at 19:54
    Highly recommend ~ Fast shipping ~ Item as described. A ++
  • Gravatar Wakizashi Swords August 8th, 2016 at 02:28
    thanks so much!
  • Gravatar Naginata August 9th, 2016 at 10:05
    thank you
  • Gravatar real ninja swords August 9th, 2016 at 17:02
    fast shipping and an awesome purse! Thanks
  • Gravatar Naginata Swords August 10th, 2016 at 09:08
    Parfait, merci beaucoup !
  • Gravatar Samurai Sword August 10th, 2016 at 09:09
    Wonderful seller ~ New tel que décrit , expédition rapide Merci ! A + +
  • Gravatar samurai sword August 10th, 2016 at 09:44
    comme d茅crit , merci
  • Gravatar japanese katana swords August 10th, 2016 at 09:44
    Vendeur tr猫s gentil , tr猫s heureux avec l'article, exp茅dition ultra - rapide, merci !
  • Gravatar katana SAKABATO August 10th, 2016 at 14:41
    Ligtning expédition rapide , exactement comme vous avez décrit , merci!
  • Gravatar Naginata Sword August 10th, 2016 at 15:03
    GREAT SERVICE !
  • Gravatar Tanto knife August 10th, 2016 at 15:04
    Aimez la chaussure! Livraison rapide! Tr猫s bon 茅tat !
  • Gravatar samurai katana August 10th, 2016 at 19:44
    ne m'y attendais pas si vite ! merci beaucoup! grand article
  • Gravatar japanese samurai August 10th, 2016 at 20:33
    Excellent transaction. Fast shipping and great pricing. Will deal with again.
  • Gravatar tachi swords August 11th, 2016 at 11:44
    Super Fast Shipping! Great Merchandise Just As Promised! A++++
  • Gravatar katana Sword August 11th, 2016 at 19:19
    Escargots Happy 5 étoiles ! Merci ...
  • Gravatar Samurai Sword August 11th, 2016 at 19:50
    Aimez la bourse. Les couleurs sont très bien. Délai de livraison raisonnable
  • Gravatar samurai katana sword August 11th, 2016 at 19:51
    J'adore cette article, expédition rapide , est arrivé parfaitement
  • Gravatar tactical wakizhasi August 11th, 2016 at 22:45
    Excellent Seller! ! Great Service, objet , et l'exp茅dition. A + + + + + +
  • Gravatar the samurai August 12th, 2016 at 05:42
    Great transaction. Je vous remercie .
  • Gravatar tempered blade japanese samurai katana August 12th, 2016 at 11:07
    My shoe arrived in mint condition. Love this shoe. Thank you. A+++++++++++
  • Gravatar samurai swords August 12th, 2016 at 11:57
    GREAT SERVICE!!!
  • Gravatar japanese tachi August 12th, 2016 at 11:57
    Thank you! I love it!
  • Gravatar japanese samurai August 12th, 2016 at 13:38
    This was a gift for my daughter's b-day, she absolutely loves it!!
  • Gravatar handmade swords August 12th, 2016 at 19:15
    Article exactement comme d脙 漏 crit ... Envoi rapide et soign茅 . R茅p茅tera entreprise
  • Gravatar samurai swords August 12th, 2016 at 19:15
    Excellent transaction . Exp茅dition rapide et grand prix. Traitera de nouveau.
  • Gravatar japan sword August 13th, 2016 at 00:08
    Absolument le vendeur le plus impressionnant ! Merci pour l' exp茅dition rapide superbe !
  • Gravatar samurai swords katana wakizashi August 13th, 2016 at 04:20
    IMPRESSIONNANT !
  • Gravatar katana Sword August 13th, 2016 at 10:25
    Great transaction. Super fast shipping and great packing. Thanks!
  • Gravatar katana sword making August 13th, 2016 at 10:26
    Great communication with seller.
  • Gravatar Buy Tsuba August 14th, 2016 at 11:40
    Merci beaucoup , a + + + + + + + + + + + + + + a + + + + + + + + + + + + + + +
  • Gravatar katana Swords August 15th, 2016 at 12:59
    A+++ seller with fast shipping! Very pleased!
  • Gravatar samurai swords August 16th, 2016 at 00:45
    merci bon vendeur
  • Gravatar best katana sword August 16th, 2016 at 22:34
    Point Pristine ! Merci tellement, ne peuvent pas attendre pour l'utiliser ! !
  • Gravatar Katana swords August 21st, 2016 at 06:48
    Smooth transaction , merci.
  • Gravatar Wakizashi Sword August 21st, 2016 at 07:46
    thanks fast shipping
  • Gravatar clay tempered katana August 21st, 2016 at 18:05
    AAA + + + Seller
  • Gravatar katana samurai sword September 2nd, 2016 at 20:38
    Great item, fast shipping
  • Gravatar working katana September 4th, 2016 at 06:49
    Nice item. Great value. Prompt delivery. A++ Recommended seller!
  • Gravatar samurai swords September 7th, 2016 at 04:21
    Fast payment! Recommended seller! Thanks!
  • Gravatar japanese samurai September 7th, 2016 at 04:21
    Fast delivery, perfect!
  • Gravatar katana swords September 7th, 2016 at 11:06
    Great transaction. Super fast shipping and great packing. Thanks!
  • Gravatar japanese samurai September 7th, 2016 at 11:07
    Very satisfied
  • Gravatar sakabato Swords September 7th, 2016 at 11:40
    Excellent seller! Super Quick Shipment! Thank you!
  • Gravatar katana Sword September 7th, 2016 at 11:41
    BEAUTIFUL!!! Perfect
  • Gravatar katana Sword September 7th, 2016 at 12:04
    Belle chaussure , comme décrit
  • Gravatar Samurai Swords September 7th, 2016 at 12:05
    Merci, vendeur merveilleux ! !
  • Gravatar Wakizashi Swords September 8th, 2016 at 03:04
    Beautiful product. Exactly as described. Perfect transaction.
  • Gravatar kd shoes September 8th, 2016 at 03:28
    Is our most recent project of the new column, we hope you like to drink instant coffee, can in a very short time to know some new tide.
  • Gravatar curry shoes September 8th, 2016 at 03:28
    hi!it's everything extraordinary, and it is assisting our son and the family reckon that the content is excellent.
  • Gravatar stephen curry shoes September 8th, 2016 at 03:29
    Now NIKE designers in the play the role of team of engineers, for the super racing - kobe Bryant, according to the changing of the game, to choose the corresponding shoe.The Zoom Kobe 2 three versions of the design.
  • Gravatar adidas nmd shoes September 8th, 2016 at 03:29
    So have the layout of the differentiation, let the Nike + community platform "products and services access" positioning.Nike has on performance.
  • Gravatar kyrie irving shoes September 8th, 2016 at 03:29
    Is our most recent project of the new column, we hope you like to drink instant coffee, can in a very short time to know some new tide.
  • Gravatar adidas yeezy September 8th, 2016 at 03:29
    As a result of looking throughout the search engines and coming across ways which were not powerful, I believed my life was over.
  • Gravatar stephen curry shoes September 8th, 2016 at 03:29
    As a result of looking throughout the search engines and coming across ways which were not powerful, I believed my life was over.
  • Gravatar official kd shoes September 8th, 2016 at 03:29
    As a result of looking throughout the search engines and coming across ways which were not powerful, I believed my life was over.
  • Gravatar new balance shoes September 8th, 2016 at 03:29
    Take advantage of the remaining portion of the year. You have been performing a dazzling job.
  • Gravatar kd shoes September 8th, 2016 at 03:29
    Is our most recent project of the new column, we hope you like to drink instant coffee, can in a very short time to know some new tide.
  • Gravatar ua shoes September 8th, 2016 at 03:29
    Nike, as always, committed to provide the basketball fans with the high quality innovation service and professional equipment, lebron on the basketball trip, will also share their championship war boots Nike as 10.
  • Gravatar yeezy 350 September 8th, 2016 at 03:29
    The layout of the Nike in the Nike + community platform, it is one of the examples of this role.In recent years, sports supplies company is generally accelerated the speed change.
  • Gravatar stan smith shoes September 8th, 2016 at 03:29
    Nice!Bring to our surprise, sure, bring good hope.
  • Gravatar japanese samurai September 9th, 2016 at 05:26
    A + + + seller avec l'exp茅dition rapide ! Tr猫s heureux !
  • Gravatar handmade swords September 9th, 2016 at 05:26
    A + Belle Great Seller juste comme d茅crit . Je reviendrai sans h茅siter ce vendeur .
  • Gravatar Nodachi weapons September 25th, 2016 at 12:58
    Merci - I love it !
  • Gravatar ninja weapons September 27th, 2016 at 15:55
    merci bon vendeur
  • Gravatar cool swords September 29th, 2016 at 18:33
    Article exactement comme d脙 漏 crit ... Envoi rapide et soign茅 . R茅p茅tera entreprise
  • Gravatar sakabato weapon September 30th, 2016 at 04:33
    recommend seller! Thanks for fast shipping &amp;amp; delivery!
  • Gravatar Naginata Sword September 30th, 2016 at 06:07
    Love it ! Expédition rapide superbe ! A + + +
  • Gravatar Real Tachi Sword October 8th, 2016 at 07:08
    Merci pour la livraison rapide .
  • Gravatar Wakizashi Weapons October 8th, 2016 at 07:09
    RE脟U TRES VITE et comme d茅crit MERCI !
  • Gravatar katana sword October 8th, 2016 at 09:14
    Juste comme d茅crit . Exp茅dition super rapide et bien emball茅 . Merci
  • Gravatar best sword October 8th, 2016 at 09:15
    A + + + + + envoi tr猫s rapide ! Vendeur honn锚te !
  • Gravatar Chinese Sword October 8th, 2016 at 12:21
    merci - transaction parfaite
  • Gravatar Naginata October 8th, 2016 at 12:21
    Très agréable avec l'expédition rapide !
  • Gravatar Tanto Sword October 9th, 2016 at 12:08
    Grand article , une grande exp茅rience . Livraison tr猫s rapide .
  • Gravatar samurai swords October 13th, 2016 at 06:16
    The blade wobble a bit when holding it sideways, but you get what you paid for. It's mostly supposed to be a decorative piece, so i honestly didn't expect it to be able to be used
  • Gravatar Ninja Katana Sword October 13th, 2016 at 10:13
    i just got this sword today the shipping was early by a day and the boxing was good and it came with a stand and belt. the craftsmanship of the blade was great and it feels like it could put some real damage out. its worth the money in my opinion. the tsuka was fit for either one or two hand wielding and the blade was almost razor sharp.
  • Gravatar Wakizashi October 13th, 2016 at 10:13
    This bokken hurts! Definitely worth every penny and is extremely durable and worthy of this review. Great build quality.
  • Gravatar Japanese Samurai Katana October 13th, 2016 at 15:36
    First off, I want to say Fast shipping! I ordered from Germany and I got the item fast!!! Thanks.
  • Gravatar japanese sword October 23rd, 2016 at 19:41
    For anyone looking for an authentic cutting sword, this is a great choice. This is the more refined version of the Hanwei Practical Katana Sword. I did some research and this rated well in many sword enthsiast forums. It comes with a tag from Hanwei that provides a serial number to document that this is a Hanwei sword. The workmanship is so beautiful for a sword of this price that I have not had the heart to cut with it yet. I may just buy another one and keep one for decoration and dedicate the other for cutting practice.
  • Gravatar samurai sword October 23rd, 2016 at 19:41
    Would I buy another? Yes!
  • Gravatar Nodachi October 23rd, 2016 at 20:34
    I haven't tested this sword yet, but it seem like the craftsmanship is very nice and durable for intermediate price tag. Im satisfied with this purchased and I'm happy that I have a decent katana sword for my first time collection..I would recommend this to anyone interested for 1st time sword buyer who can't afford the handmade Japanese sword.
  • Gravatar Best Sword October 23rd, 2016 at 20:35
    The sword is everything I expected it to be. It came sharp but I sharpened it to what it should be and just tapping the blade causes a good gash. I dropped a steak on it and it cut right through it like a knife through butter after I sharpened it. But just using it out of the box I was able to cut through a rolled up carpet. So all in all it is an excellent blade.
  • Gravatar Japanese Samurai Katana October 23rd, 2016 at 22:37
    This sword is really cool! It is a really strong sort of plastic material. It is strong, and doesn't seem like it will break for a long time. It also came in like 3 days...with standard shipping! Would definitely buy again.
  • Gravatar Japanese Samurai Katana October 23rd, 2016 at 22:37
    I was worried about the authenticity of the product as it is far cheaper than on the official musashi website and that in the pictures there is no "musashi" inscription on the gold colored metal piece above the guard. I got the free two day shipping and it promptly arrived. I was more than pleased when I took it out of the box. It was far more sturdy than i had expected and looked far better than in any picture. It did in fact come with a certificate of authenticity. I am very very satisfied with the purchase. criticisms - the piece that is supposed to have the musashi stamp does in fact have the stamp but doesn't fit, it wobbles around all the time. I'm unsure about the small oil colored lines that run throughout the blade, can't seem to wash them off but polishing may take care of that, however it may be just what the steel is supposed to look like (never owned this type of steel blade). It wasn't really that sharp at all, couldn't even cut into paper. Had to sharpen it myself and since i'm inexperienced I left some pretty gnarly scratches. It scratches extremely easily but i guess thats inevitable with something that is being used to cut things. If you want it for a display piece don't use it
  • Gravatar katana swords October 25th, 2016 at 05:44
    Perfect for training.
  • Gravatar best katana October 25th, 2016 at 05:44
    Cannot beat the quality for the price. Would recommend this katana whether wealthy or on a budget. Love it and the cleaning kit that come with it.
  • Gravatar Best Sword October 28th, 2016 at 20:09
    Beautiful Blade!i like it!!!
  • Gravatar Japanese Katana October 31st, 2016 at 19:34
    LOVE this sword. very sharp looking, and to the touch
  • Gravatar Japanese White Katana October 31st, 2016 at 19:34
    This item really lives up to it's video hype. It has so far, cut everything I have swung it at with little to no problem. I would definitely recommend this Battle ready Katana to anyone who needs a Zombie Apocalypse weapon!
  • Gravatar katana Swords November 1st, 2016 at 03:28
    This a nice piece and durable without the high price. Worth the money.
  • Gravatar Samurai swords November 1st, 2016 at 03:29
    Traditional katana collectors may be put off by the lack of a hamon. But don't be fooled. A hamon is not necessary with the purity and heat treatment of the modern steel. It will resist chipping better than a traditional katana as well as take more abuse from flexing pressure. Hamons have disadvantages as well and should not be there if the the reasons for having them are non-existent.
  • Gravatar 日本自卫队 November 25th, 2016 at 17:11
    感觉阿婆主你的语速过快,有时候适中而沉稳的语速表达效果会更好
  • Gravatar 五毛 November 28th, 2016 at 06:43
    我总想吐槽UP主的普通话
  • Gravatar facebook hacking services December 26th, 2016 at 04:56
    Hey there I am so delighted I found your web site, I really found you by mistake, while I was browsing
    on Digg for something else, Nonetheless I
    am here now and would just like to say thanks a lot for a tremendous post
    and a all round enjoyable blog (I also love the theme/design), I don't have time to go through it all at the minute but I have saved it and also
    added your RSS feeds, so when I have time I will be back
    to read much more, Please do keep up the fantastic job.
Gravatar