THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Maria Zakourdaev

Query big data, stored in a csv or parquet files, from any stored procedure

Every cloud provider these days have a serverless interactive query service that uses standard SQL for data analysis.

As for the biggest cloud providers, we have Azure Data Lake analytics, Google BigQuery and Amazon Athena.

Due to the fact that my company is using only Amazon cloud, I have some experience with Athena service and I must say that it is awesome.

I will show you today how you can use Management Studio or any stored procedure to query the data, stored in a csv file, located on S3 storage. I am using CSV file format as an example here, columnar PARQUET gives much better performance.

I am going to:

1. Put a simple CSV file on S3 storage

2. Create External table in Athena service over the data file bucket

        3. Create linked server to Athena inside SQL Server  

        4. Use OPENQUERY to query the data.  

Athena service is built on the top of Presto, distributed SQL engine and also uses Apache Hive to create, alter and drop tables. You can run ANSI SQL statements in the Athena query editor, launching it from the AWS web services UI. You can use complex joins, window functions and many other great SQL language features. Using Athena eliminates need for ETL because it projects your schema on the data files at the time of the query.

Let’s create database in Athena query editor.

image

As a next step I will put this csv file on S3. By the way, Athena supports JSON format, tsv, csv, PARQUET and AVRO formats.

Uploading the below file to S3 bucket (don’t put columns header in file):

image

image

Going back to Athena to create external table over the S3 folder.  You can later add more files to the same folder and your queries will return the new data immidiately.

image

Now I can query the data:

image

image

As a next step I will set up a linked server from my SQL Server instance because I would like to offload the big data querying to Athena. Of course, I am using in this example tiny data file but in real life we are querying sometimes 300GB of data files in the single query and it takes a few seconds.

Athena has ODBC driver, I will install it on SQL Server machine ( AWS EC2 instance for this example).

Here is an installation link: https://s3.amazonaws.com/athena-downloads/drivers/ODBC/Windows/Simba+Athena+1.0+64-bit.msi

Setting up the ODBC connection. Important, click on the Authentication Option and fill in AccessKey and SecretKey that have permissions to access S3 bucket. S3 output location below will hold csv files with results from your queries. Remember to clean the output files from time to time.

image

What is left is to set up Linked Server inside Management Studio using OLEDB provider for ODBC.

EXEC master.dbo.sp_addlinkedserver @server = N'DWH_ATHENA', @srvproduct=N'', @provider=N'MSDASQL', @datasrc=N'DWH_ATHENA'

GO

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DWH_ATHENA',@useself=N'False',@locallogin=NULL,@rmtuser=N'*******',@rmtpassword='*********'

GO

Replace @rmtuser and @rmtpassword with AWS access key and secret key and now we can query the data files from any script or stored procedure.

There is one very important thing that you need to know. Regular SQL Server ODBC destinations querying behavior of is to send “select *” to linked server and do filtering inside SQL Server. This is very bad for us since we wanted to offload all work to Athena and we do not want to receive all data.  The way to overcome this is to use OPENQUERY.

Here is example of the query that is using a linked server. The remote query has omitted all filtering and receiving ALL columns from the remote table and filter is being applied later on, inside the “Filter” step.

image

The same query that is using OPENQUERY instead of linked server:

image

Result.

image

 

Isn’t it wonderful to be able to keep the row data in files and query them with minimal effort from the SQL Server side?

Yours,

Maria

Published Sunday, December 17, 2017 1:28 PM by Maria Zakourdaev

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Stan said:

Very interesting.  I will have to try this

December 17, 2017 1:31 PM
 

Michael Zilberstein said:

Isn't it too costly? You pay for SQL Server license, S3 and also 5$ per TB of scanned data in Athena. I mean, that's a nice capability but do you see any practical use for that?

December 18, 2017 10:07 AM
 

Maria Zakourdaev said:

Michael, if Athena queries will be defined correctly: only fields that are required and not 'select *' and query is SARGable (with proper filtering), Athena is not expensive at all.

Sql Server instance in such case does not need to be very expensive, it does not process the data, only receives the final result set.  

As for practical use, our DWH is on Athena/S3 and some data clients are on SQL Server. We could either build full ETL to load the data into SQL Server or work through OPENQUERY. Which is much more flexible and requires no development efforts.

December 19, 2017 3:46 AM
 

Yeeyzs V2 said:

yeezy v 2の販売,환상 판매,La vendita Yeezy V2,Yeezy V2 de vente,En el mercado yeezy V2.

http://www.yeezysv2.co.uk/ Zebra Yeezys

http://www.yeezysv2.co.uk/ Yeezys Shoes

http://www.yeezysv2.co.uk/ Yeezys For Sale

http://www.yeezysv2.co.uk/ Yeezys Boost 350 V2

http://www.yeezysv2.co.uk/ Yeezys Boost 350

http://www.yeezysv2.co.uk/ Yeezys Adidas

http://www.yeezysv2.co.uk/ Yeezys

http://www.yeezysv2.co.uk/ Yeezy'S

http://www.yeezysv2.co.uk/ Yeezy V2 Boost

http://www.yeezysv2.co.uk/ Yeezy V2

http://www.yeezysv2.co.uk/ Yeezy Sale

http://www.yeezysv2.co.uk/ Yeezy Pirate Black

http://www.yeezysv2.co.uk/ Yeezy For Sale

http://www.yeezysv2.co.uk/ Yeezy Cream

http://www.yeezysv2.co.uk/ Yeezy Boost V2

http://www.yeezysv2.co.uk/ Yeezy Boost 750

http://www.yeezysv2.co.uk/ Yeezy Boost 700

http://www.yeezysv2.co.uk/ Yeezy Boost 350 V2 Zebra

http://www.yeezysv2.co.uk/ Yeezy Boost 350 V2 Kaufen

http://www.yeezysv2.co.uk/ Yeezy Boost 350 V2 Footlocker

http://www.yeezysv2.co.uk/ Yeezy Boost 350 V2 Blue Tint

http://www.yeezysv2.co.uk/ Yeezy Boost 350 V2 Beluga

http://www.yeezysv2.co.uk/ Yeezy Boost 350 V2

http://www.yeezysv2.co.uk/ Yeezy Boost 350 For Sale

http://www.yeezysv2.co.uk/ Yeezy Boost 350 Foot Locker

http://www.yeezysv2.co.uk/ Yeezy Blue Tint

http://www.yeezysv2.co.uk/ Yeezy Blue

http://www.yeezysv2.co.uk/ Yeezy Beluga 2.0

http://www.yeezysv2.co.uk/ Yeezy Beluga

http://www.yeezysv2.co.uk/ Yeezy Adidas

http://www.yeezysv2.co.uk/ Yeezy 750

http://www.yeezysv2.co.uk/ Yeezy 700

http://www.yeezysv2.co.uk/ Yeezy 500

http://www.yeezysv2.co.uk/ Yeezy 350 V2

http://www.yeezysv2.co.uk/ Yeezy 2018

http://www.yeezysv2.co.uk/ Yeezy

http://www.yeezysv2.co.uk/ White Yeezys

http://www.yeezysv2.co.uk/ Where To Buy Yeezys

http://www.yeezysv2.co.uk/ Ultra Boost Adidas

http://www.yeezysv2.co.uk/ Ultra Boost 4.0

http://www.yeezysv2.co.uk/ Ultra Boost

http://www.yeezysv2.co.uk/ Supreme Yeezy

http://www.yeezysv2.co.uk/ Real Yeezys

http://www.yeezysv2.co.uk/ Kanye West Yeezy

http://www.yeezysv2.co.uk/ Kanye West Sneakers

http://www.yeezysv2.co.uk/ Kanye West Shoes

http://www.yeezysv2.co.uk/ Kanye West

http://www.yeezysv2.co.uk/ Kanye

http://www.yeezysv2.co.uk/ Cheap Yeezy

http://www.yeezysv2.co.uk/ Blue Tint Yeezy

http://www.yeezysv2.co.uk/ Black Yeezys

http://www.yeezysv2.co.uk/ Black Yeezy

http://www.yeezysv2.co.uk/ Beluga Yeezy

http://www.yeezysv2.co.uk/ Adidas Yeezys

http://www.yeezysv2.co.uk/ Adidas Yeezy V2

http://www.yeezysv2.co.uk/ Adidas Yeezy Boost 350 V2 Zebra

http://www.yeezysv2.co.uk/ Adidas Yeezy Boost 350 V2

http://www.yeezysv2.co.uk/ Adidas Yeezy Boost 350

http://www.yeezysv2.co.uk/ Adidas Yeezy Boost

http://www.yeezysv2.co.uk/ Adidas Yeezy Blue Tint

http://www.yeezysv2.co.uk/ Adidas Yeezy

http://www.yeezysv2.co.uk/ Adidas V2

http://www.yeezysv2.co.uk/ Adidas UltraBoost

http://www.yeezysv2.co.uk/ Adidas Ultra Boost Men

http://www.yeezysv2.co.uk/ Adidas Ultra Boost

http://www.yeezyv2sales.org/ Yeezys V2 Sale

http://www.yeezyv2sales.org/ Kanye West Yeezy

http://www.yeezyv2sales.org/ Kanye West Sneakers

http://www.yeezyv2sales.org/ Kanye West Shoes

http://www.yeezyv2sales.org/ Kanye West

http://www.yeezyv2sales.org/ Kanye

http://www.yeezyv2sales.org/ Adidas V2

http://www.yeezyv2sales.org/ Adidas UltraBoost

http://www.yeezyv2sales.org/ Adidas Ultra Boost Men

http://www.yeezyv2sales.org/ Adidas Ultra Boost

http://www.yeezyv2sales.org/ Adidas Sale

http://www.yeezyv2sales.org/ Adidas Runtastic Adidas Heater

http://www.yeezyv2sales.org/ Adidas Running

http://www.yeezyv2sales.org/ Adidas Boots

http://www.yeezyv2sales.org/ Adidas Boost

http://www.yeezyv2.top/ Yeezy V2

http://www.yeezyv2.top/ Adidas Yeezy V2

http://www.yeezyv2.top/ Adidas Yeezy Boost 350 V2 Zebra

http://www.yeezyv2.top/ Adidas Yeezy Boost 350 V2

http://www.yeezyv2.top/ Adidas Yeezy Boost 350

http://www.yeezyv2.top/ Adidas Yeezy Boost

http://www.yeezyv2.top/ Adidas Yeezy Blue Tint

http://www.yeezyv2.top/ Adidas Yeezy 350

http://www.yeezyv2.top/ Adidas Yeezy

http://www.yeezyv2.top/ Adidas V2

http://www.yeezyshoes.top/ Ultra Boost Adidas

http://www.yeezyshoes.top/ Ultra Boost 4.0

http://www.yeezyshoes.top/ Ultra Boost

http://www.yeezyshoes.top/ Kanye West Yeezy

http://www.yeezyshoes.top/ Kanye West Sneakers

http://www.yeezyshoes.top/ Kanye West Shoes

http://www.yeezyshoes.top/ Kanye West

http://www.yeezyshoes.top/ Kanye

http://www.yeezyshoes.top/ Adidas V2

http://www.yeezyshoes.top/ Adidas UltraBoost

http://www.yeezyshoes.top/ Adidas Ultra Boost Men

http://www.yeezyshoes.top/ Adidas Ultra Boost

http://www.yeezyboost350v2outlet.com/ Yeezy Boost 350 V2 Outlet

http://www.yeezyboost350v2outlet.com/ Adidas Yeezys

http://www.yeezyboost350v2outlet.com/ Adidas Yeezy V2

http://www.yeezyboost350v2outlet.com/ Adidas Yeezy Shoes

http://www.yeezyboost350v2outlet.com/ Adidas Yeezy Boost 350 V2 Zebra

http://www.yeezyboost350v2outlet.com/ Adidas Yeezy Boost 350 V2

http://www.yeezyboost350v2outlet.com/ Adidas Yeezy Boost 350

http://www.yeezyboost350v2outlet.com/ Adidas Yeezy Boost

http://www.yeezy500.org/ Yeezy Boost 500

http://www.yeezy500.org/ Yeezy 750

http://www.yeezy500.org/ Yeezy 700

http://www.yeezy500.org/ Yeezy 500

http://www.yeezy500.org/ Adidas Yeezy 500

http://www.yeezy500.org/ 500

http://www.newyeezyv2.org/ Yeezy

http://www.newyeezyv2.org/ White Yeezys

http://www.newyeezyv2.org/ Supreme Yeezy

http://www.newyeezyv2.org/ Real Yeezys

http://www.newyeezyv2.org/ New Yeezys

http://www.newyeezyv2.org/ New Yeezy V2

http://www.newyeezyv2.com/ New Yeezy V2

http://www.newyeezyv2.com/ New Yeezy

http://www.newyeezyv2.com/ Kanye West Yeezy

http://www.newyeezyv2.com/ Cheap Yeezy

http://www.newyeezyv2.com/ Blue Tint Yeezy

http://www.newyeezyv2.com/ Black Yeezy

http://www.newyeezyv2.com/ Beluga Yeezy

http://www.ukmonclercoat.co.uk/ Uk Moncler Coat

http://www.ukmonclercoat.co.uk/ Uk Moncler

http://www.monclerukonline.co.uk/ Moncler Uk Online

http://www.monclerukonline.co.uk/ Moncler Uk

http://www.moncler-ukoutlet.co.uk/ Moncler Uk Outlet

http://www.moncler-ukoutlet.co.uk/ Moncler Uk

http://www.monclerjacketoutlets.co.uk/ Moncler Jacket Outlets

http://www.monclerjacketoutlets.co.uk/ Moncler Jacket

http://www.monclerukjackets.co.uk/ Moncler Uk Jackets

http://www.monclerukjackets.co.uk/ Moncler Jackets

http://www.canadagooseuk.org/ Goose Down Jackets

http://www.canadagooseuk.org/ Canada Goose Uk

http://www.usnfljerseys.us/ Nfl Jerseys

http://www.usnfljerseys.us/ Nfl Jersey Cheap

http://www.usnfljerseys.us/ Nfl Jersey

http://www.usnfljerseys.org/ Nfl Jersey Cheap

http://www.usnfljerseys.org/ Nfl Jersey

http://www.usnfljerseys.org/ Nfl Cheap Jerseys

http://www.uscheapnfljersey.com/ Cheap Nfl Jerseys

http://www.uscheapnfljersey.com/ Cheap Nfl Jersey

http://www.nfljerseyscheapsales.com/ Nhl Jerseys 2018

http://www.nfljerseyscheapsales.com/ Nfl Jerseys For Sale

http://www.nfljerseyscheapsales.com/ Nfl Jerseys Cheap

http://www.cheapnba.top/ Nba Jerseys Cheap

http://www.cheapnba.top/ Nba Jerseys 2018

http://www.cheapnba.top/ Nba Jerseys

http://www.uscheapjerseys.us.com/ Cheap Jerseys

http://www.uscheapjerseys.us.com/ Cheap Jersey 2018 Us

http://www.uscheapjerseys.us.com/ Cheap China Jerseys

http://www.air-max2018.com/ Air Max 2018

http://www.air-max2018.com/ 2018 Nike Air Max

http://www.air-max2018.com/ 2018 Air Max

http://www.nikeairvapormax.top/ Nike Vapormax

http://www.nikeairvapormax.top/ Nike Air Vapor Max

http://www.vapor-max.com/ Vapormax

http://www.vapor-max.com/ Vapor Max Nike

http://www.vapor-max.com/ Vapor Max

http://www.vapormax2018.org Vapormax 2018

http://www.vapormax2018.org Vapormax

http://www.vapormax2018.org Vapor Max Nike

http://www.vapormax2018.org Vapor Max

http://russia2018jersers.com/ 2018

http://russia2018jersers.com/ Worldcup 2018

http://russia2018jersers.com/ World Cup Soccer 2018

http://russia2018jersers.com/ World Cup Russia 2018

http://www.footballjerseycheap.com/ World Cup Russia

http://www.footballjerseycheap.com/ World Cup Football 2018

http://www.footballjerseycheap.com/ World Cup Football

http://www.footballjerseycheap.com/ World Cup 2018

http://www.warriors-gs.com/ Warriors Jersey

http://www.warriors-gs.com/ Nba Warriors

http://www.warriors-gs.com/ Golden State Warriors

http://www.michael-kors-bags.us/ Michael Kors Factory Sale

http://www.michael-kors-bags.us/ Michael Kors bags

http://www.michael-kors-bags.us/ Michael Kors

http://www.jordan-air.us/ Jordan Air

http://www.jordan-air.us/ Cheap Jordan Shoes

http://www.jordan-air.us/ Air Jordan Shoes

http://www.jordan-air.us/ Air Jordan

http://www.asics.us.com/ Asics Shoes

http://www.asics.us.com/ Asics

http://www.clearancefitflop.com/ Cheap Fitflop

http://www.clearancefitflop.com/ Fitflop Clearance

http://www.clearancefitflop.com/ Fitflop Sale Clearance

http://www.clearancefitflop.com/ Discount Fitflop

http://www.clearancefitflop.com/ Fitflop Outlet

http://www.clearancefitflop.com/ Fitflop Clearance Outlet

http://www.clearancefitflop.com/ Clearance Fitflop

http://www.pandorajewellerywholesale.co.uk/ Cheap Pandora Charms

http://www.pandorajewellerywholesale.co.uk/ Pandora Charms Sale Clearance

http://www.pandorajewellerywholesale.co.uk/ Pandora Charms

http://www.pandorajewellerywholesale.co.uk/ Wholesale Pandora Jewellery

http://www.pandorajewellerywholesale.co.uk/ Pandora Wholesale

http://www.pandorajewellerywholesale.co.uk/ Pandora Jewellery Wholesale

http://www.pandorajewellerywholesale.co.uk/ Pandora Jewelry

http://www.pandorajewellerywholesale.co.uk/ Pandora Outlet

http://www.pandorajewellerywholesale.co.uk/ Pandora Charms Outlet

http://www.pandorajewellerywholesale.co.uk/ Pandora Rings

http://www.pandorajewellerywholesale.co.uk/ Pandora Bracelets

http://www.canadagoosejacketuk.co.uk/ Canada Goose

http://www.canadagoosejacketuk.co.uk/ Canada Goose UK

http://www.canadagoosejacketuk.co.uk/ Down Jackets For Women

http://www.canadagoosejacketuk.co.uk/ Canada Goose UK Jacket

http://www.canadagoosejacketuk.co.uk/ Canada Goose Jacket UK

http://www.canadagoosejacketuk.co.uk/ Canada Goose Jacket

June 24, 2018 3:46 PM
 

dongdong8 said:

http://www.niketn.fr

http://www.newbalancesandals.us.com

http://www.burberryoutletonline.us.org

http://www.kobe11.in.net

http://www.toryburchoutletmall.us.com

http://www.vancleefarpelsjewelry.us.com

http://www.airmaxnl.nl

http://www.nikesshoes.us.com

http://www.coachhandbagsfactoryoutletonline.us.com

http://www.nikepresto.us.com

http://www.weddingshoes.us.com

http://www.longchampsacsoldes.fr

http://www.pradabags.us.com

http://www.jordanxx9.in.net

http://www.adidasultra-boost.us.com

http://www.balenciaga-triples.us.com

http://www.coachoutlet-factory.us.com

http://www.timberlandoutlet.us.org

http://www.longchampoutletcom.us.com

http://www.ralphlaurenoutletofficial.us.com

http://www.katespadehandbagsoutlet.us.org

http://www.burberryoutlet-canada.ca

http://www.nikekyrie3.us.com

http://www.nikeepicreactflyknit.us.com

http://www.katespadeoutletsale.us.com

http://www.oakleysunglassescanada.ca

http://www.vansshoesoutlet.us.com

http://www.jordan4.net

http://www.nikeoff.com

http://www.runningshoes.us.org

http://www.airmax2017.us.com

http://www.airjordanretro.fr

http://www.chaussuresnikeairmax.fr

http://www.huarache.us.com

http://www.camisetasfutbole2018.com

http://www.jordan1.us

http://www.asics.us.org

http://www.adidasjeremyscott.in.net

http://www.raybansunglassesforwomen.us.com

http://www.miumiu.us.com

http://www.redbottoms.us.org

http://www.tods.us.com

http://www.pumaslides.us.com

http://www.ralphlauren-poloshirts.co.uk

http://www.oakleysunglassescheapest.us.com

http://www.salvatoreferragamo.in.net

http://www.jimmychoooutlet.us.com

http://www.nikeblazer.fr

http://www.montblanc.com.co

http://www.air-jordan.us.com

http://www.coachoutlet70off.us.com

http://www.magliacalcioshop.it

http://www.adidasflipflops.us.com

http://www.christianlouboutinoff.us

http://www.nikeshox.in.net

http://www.jordan8.net

http://www.mishka.us.com

http://www.fitflops.us.org

http://www.montblancfountainpens.us.com

http://www.cheapnfljerseysnike.us.com

http://www.ralphlaurens.fr

http://www.cartierjewelry.us.com

http://www.pradahandbagsoutlet.us.com

http://www.fussballtrikotsshop.de

http://www.longchamphandbagstotes.us.com

http://www.adidasyeezy350boost.us.com

http://www.nikejordans.co.uk

http://www.stansmithadidas.org.uk

http://www.stephen-curryshoes.us.com

http://www.oakleysunglasses.us

http://www.christianlouboutinoutletuk.org.uk

http://www.adidaswings.name

http://www.airforce1.in.net

http://www.outletmichaelkorsoutletonline.us.com

http://www.ferragamooutlet.us.com

http://www.air-jordanpascher.fr

http://www.maillotdefootcenter.fr

http://www.airmax95.us.org

http://www.superdry.me.uk

http://www.barcelonajersey.us.com

http://www.poloralphlaurens.us.com

http://www.coachcom.us.com

http://www.oakley-sunglassesonsale.us.com

http://www.nhlhockey-jerseys.us.com

http://www.hardenvol2.us.com

http://www.canadagooses.us.com

http://www.shoecarnival.us.com

http://www.michael-korstaschen.ch

http://www.jordan12.org

http://www.kevindurantshoes.us.com

http://www.cheapnhljerseysshop.us.com

http://www.michael-korsoutletstores.us.org

http://www.jordanfemmepascher.fr

http://www.raybansunglassescheapest.us.com

http://www.supremeparis.fr

http://www.michaelkorsoutlet.us

http://www.birkenstockoutlet.us.org

http://www.adidasnmdforsale.us.com

http://www.jordans-fusion.com

http://www.coachfactoryoutlet-online.eu.com

http://www.coachonline.us.org

http://www.sunglassesoakleycheap.us.com

http://www.jordan3.net

http://www.footballsoccershirts.me.uk

http://www.valentino.us.org

http://www.mkpurse.us.com

http://www.jordans.us.org

http://www.nikefree-run.fr

http://www.maillotdefootfrance.fr

http://www.ray-banssunglasses.org.uk

http://www.longchampoutlet-store.us.com

http://www.nikefree.net

http://www.guccislides.us.com

http://www.michaelkorsshandbags.us.com

http://www.adidasyeezy350.us.com

http://www.ralplaurenuk.org.uk

http://www.birkenstocksandalsonsale.us.com

http://www.nikeoutletus.us.com

http://www.fitflopssale.org.uk

http://www.katespadestoreoutlet.us.com

http://www.wholesaleoakleysunglasses.us.org

http://www.jordan6.net

http://www.fitflopss.us.com

http://www.suprashoesclearance.us.com

http://www.longchamp-outletstore.us.com

http://www.ferragamoshoesoutlet.us.com

http://www.pandora-jewelry.name

http://www.nikefactory.us

http://www.manoloblahnik.us

http://www.nikerevolution.us

http://www.airjordan11.us

http://www.yeezydesertrat500.us.com

http://www.asics.org.uk

http://www.redbottomsshoes.me.uk

http://www.michael-kors-uk.me.uk

http://www.hardenvol1.us.com

http://www.beatsheadphones.us.com

http://www.giuseppe-zanotti.us.com

http://www.hermesbirkinbags.us.com

http://www.y3shoes.us.com

http://www.katespadehandbagssale.us.org

http://www.givenchyhandbags.us.com

http://www.coachoutlet-online.eu.com

http://www.nikesb.in.net

http://www.poloralphlaurensoutlet.us.com

http://www.fila.us.com

http://www.ralphlauren.in.net

http://www.alexandermcqueen.us.com

http://www.christiandiorhandbags.us.com

http://www.michaelkorshandbagsmacys.us.com

http://www.coachsoutletstoreonline.us.com

http://www.mizuno.us.org

http://www.jerseys.us.org

http://www.coachoutletstoreonlineclearances.us.org

http://www.louboutins.us.com

http://www.coachwallets.us.com

http://www.korsmichaelkors.org.uk

http://www.cheapmlbjersey.us.com

http://www.adidasstoreuk.me.uk

http://www.kobe12shoes.us.com

http://www.rayban.net.co

http://www.timberlandpro.us.com

http://www.nikeairforce1.net

http://www.cheapraybansunglasses.net.co

http://www.marcjacobs.me.uk

http://www.timberland.us.org

http://www.bottega.in.net

http://www.nikelunarglide.us

http://www.wholesale-jerseysnfl.us.com

http://www.pandoraukcharms.co.uk

http://www.cheapjerseys.in.net

http://www.niketrainers.org.uk

http://www.balenciagashop.us.com

http://www.truereligionjeans-outlet.us.com

http://www.katespade-outlet.us.com

http://www.louboutinchristian.us.com

http://www.michaelkorss--outlet.us.com

http://www.manchesterunitedjersey.us.com

http://www.undefeated.us.com

http://www.nfl-jersey.in.net

http://www.truereligion-jeans.me.uk

http://www.coach-bags.us.org

http://www.breitling.us.com

http://www.nikefree.me.uk

http://www.louboutinoutlets.us.com

http://www.katespade-outlet.in.net

http://www.oakleysunglasses-vault.us.com

http://www.truereligionsale.com.co

http://www.ralph-laurenpolouk.org.uk

http://www.cheapnfljerseysfree.us.com

http://www.underarmouroutletclearance.com

http://www.christian-louboutins.fr

http://www.cheap-jordans.us.com

http://www.belstaffoutlet.us.com

http://www.basketballshoesstore.us.com

http://www.ray-bansunglassesoutlet.com.co

http://www.longchampoutlet-online.com

http://www.poloralphlaurenoutlet.org.uk

http://www.coachoutletonline-sale.us.com

http://www.niketennis.us.com

http://www.airjordan.me.uk

http://www.michaelkorsoff.us.com

http://www.adidasslides.us.com

http://www.supremeclothing.us.com

http://www.airmax97.org

http://www.hervelegerdresses.us.com

http://www.fingerlingsmonkey.org

http://www.newbalance-shoes.us.com

http://www.toryburchoff.us.com

http://www.hermesbeltoutlet.com

http://www.pandoracharmjewelry.us.com

http://www.cheapraybansunglass.co.uk

http://www.nikeroshe.us.com

http://www.calciomaglie.it

http://www.converseshoes.us.org

http://www.coach-factoryonline.us.org

http://www.pumafentysandals.us.com

http://www.audemarspiguet.us.com

http://www.dolceandgabbana.us.com

http://www.airmax2018.in.net

http://www.newbalance.me.uk

http://www.hermesbags.me.uk

http://www.pandorajewelry.us.org

http://www.off-white.us.com

http://www.rolexwatches.us.com

http://www.mcmbackpack.us.com

http://www.converseshoesoutlet.us.com

http://www.hermesoutlets.us.com

http://www.coachoutletonlinestore.ca

http://www.nikeoutletstoreonline.us.com

http://www.flipflops.me.uk

http://www.jordanshoes.us.org

http://www.suicoke.us.com

http://www.michaelkorsoutletcheapest.us.com

http://www.truereligion-jeans.us

http://www.dansko.us.com

http://www.hollisteroutlet.us.org

http://www.bvlgari.us.com

http://www.michaelkorshandbagssales.us.com

http://www.truereligionoutletjeans.us

http://www.adidasoriginalsstansmith.us.com

http://www.columbia-sportswear.us.com

http://www.coachoutletstoreonlineofficial.us.com

http://www.stuartweitzmanshoes.us.com

http://www.louboutins.me.uk

http://www.michaelkorsonline.ca

http://www.rayban.in.net

http://www.off-whiteclothing.us.com

http://www.malonesouliers.us.com

http://www.timberlandoutletuk.org.uk

http://www.poloshirtsoutlet.us.com

http://www.nikedunks.us

http://www.ralphlaurenpolo.in.net

http://www.nikeairmax90.com.de

http://www.nikeflipflops.org

http://www.nikeairmax90.us.org

http://www.ralph-laurens.co.uk

http://www.adidasoutletadidas.us.com

http://www.christianlouboutinshoessale.org.uk

http://www.airmax1.us

http://www.pandorajewelry-canada.ca

http://www.cheapjordansshoes.in.net

http://www.coachoutletonline70off.us.com

http://www.nikefreeruns.us.com

http://www.vibram-fivefingers.us.com

http://www.burberrysale.us.org

http://www.adidassuperstarshoes.us.com

http://www.linksoflondonuk.me.uk

http://www.outlet-celine.com

http://www.fitflopsoutlet.us.com

http://www.airhuarache.fr

http://www.redbottomshoes.org.uk

http://www.adidasoutletstores.net

http://www.snapbacks-wholesale.us.com

http://www.balenciagasandals.us.com

http://www.trikotsgünstig.de

http://www.ralphlaurenpolos.fr

http://www.adidasfootballboots.org.uk

http://www.michaelkorsoutletsoff.us.com

http://www.coachfactory--outlet.us.com

http://www.stussy.us.com

http://www.authenticmlbjerseyscheap.us.com

http://www.swarovskijewelry.co.uk

http://www.nikeblazers.us

http://www.rosherun.org

http://www.poloralph.us.com

http://www.swarovskijewelryoutlet.us.com

http://www.adidasnmdoutlet.us.com

http://www.lightup-shoes.us.com

http://www.baseballbats.us.com

http://www.toryburchbags.us.com

http://www.soccerjersey.us.com

http://www.cheapbestnbajerseys.us.com

http://www.nikemercurial.us

http://www.cheapmlbjerseysshop.us.com

http://www.montblancpen.in.net

http://www.supreme-newyork.com

http://www.oakleysunglassescom.us.com

http://www.nikeshoesnike.us.com

http://www.coachoutletfactoryofficial.us.com

http://www.fitflopssaleclearance.us.org

http://www.newcoachoutlet.us.com

http://www.coachoutletstore.eu.com

http://www.rayban-sunglassesonsale.us.com

http://www.nfljerseyshop.us.com

http://www.kanyeyeezyshoes.us.com

http://www.michaelkorsoutlet70off.us.com

http://www.jordanretro.us

http://www.fansoccerjerseys.com

http://www.airmax270.org

http://www.lebron15.in.net

http://www.nikeukstores.me.uk

http://www.taghuer.us.com

http://www.cheapmichaelkorshandbags.us.org

http://www.beatsbydrdresolo.us

http://www.birkenstockshoes.org.uk

http://www.timberlandoutletonline.us.com

http://www.pandorajewelrycanada.ca

http://www.adidasshoess.us.com

http://www.supremeuk.co.uk

http://www.cheapraybans.ca

http://www.brequet.us.com

http://www.nikecortez.net

http://www.coachfactoryoutlet-onlinestore.us.com

http://www.nikeairmaxschweiz.ch

http://www.cheapreplicawatches.us.com

http://www.mulberryukhandbags.org.uk

http://www.juicycoutureoutlet.us.com

http://www.bcbg.us.com

http://www.mbtscarpe.it

http://www.converse.me.uk

http://www.tory-burch.org.uk

http://www.jordans.in.net

http://www.airjordan-14.us

http://www.christianlouboutinoutletus.us.com

http://www.flops.us.com

http://www.pandorajewelrysoutlet.us.com

http://www.pradaoutletonlinestore.us.com

http://www.baseballjersey.us.com

http://www.coachoutlet-handbags.us.com

http://www.camisetasdefutbolbaratases.es

http://www.outletralph-lauren.us.com

http://www.airmax.us.org

http://www.michael--kors.me.uk

http://www.raybansunglassesoutlet.net.co

http://www.maccosmeticsofficial.us.com

http://www.oakleysunglassesparts.us.com

http://www.vansshoes.us.org

http://www.burberry-outlet-stores.us.com

http://www.prada.us.org

http://www.polooutletinc.us.com

http://www.mbt.us.com

http://www.hermeskellybag.us.com

http://www.adidasoutletstores.com

http://www.airmaxplus.org

http://www.jerseys.eu

http://www.jordan5.us

http://www.coachoutletonsale.us.com

20186.30wengdongdong

June 29, 2018 3:30 AM
 

dongdong8 said:

http://www.ray-bansunglassesoutlet.com.co

http://www.michael--kors.me.uk

http://www.raybanwayfarer.us.org

http://www.coachfactoryoutlet-online.eu.com

http://www.cheapmlbjerseysshop.us.com

http://www.longchampoutlet-online.com

http://www.persolsunglasses.us.com

http://www.tiffanyrings.us.com

http://www.longchampoutletcom.us.com

http://www.belstaffoutlet.us.com

http://www.ralphs-laurenoutlet.co.uk

http://www.nikerevolution.us

http://www.nikemercurial.us

http://www.nikeairtrainers.me.uk

http://www.ralplaurenuk.org.uk

http://www.nikeshopjapan.com

http://www.burberry-outlet-stores.us.com

http://www.nikeoutletstoreonline.us.com

http://www.michaelkorsoutletsoff.us.com

http://www.coachoutletonline70off.us.com

http://www.lebronambassador10.us.com

http://www.airmax2017.us.com

http://www.authenticmlbjerseyscheap.us.com

http://www.cartierjewelry.us.com

http://www.pradabags.us.com

http://www.stephen-curryshoes.us.com

http://www.michaelkorsoutletonsale.us.com

http://www.birkenstockshoes.org.uk

http://www.coachonline.us.org

http://www.taghuer.us.com

http://www.cheapreplicawatches.us.com

http://www.airmax2018.in.net

http://www.nikeshoesnike.us.com

http://www.suicoke.us.com

http://www.coachfactoryoutletonline.us.org

http://www.airjordan-14.us

http://www.jordanretro.us

http://www.policesunglasses.us

http://www.thenorthfacejackets.us.org

http://www.paulgeorge.us.com

http://www.ralphlaurenpolo.in.net

http://www.toryburchoutletmall.us.com

http://www.ferragamooutlet.us.com

http://www.ysl.us.com

http://www.kevindurantshoes.us.com

http://www.vansstore.us.com

http://www.mcm-outlets.us.com

http://www.mulberryhandbags.us.com

http://www.rayban.nom.co

http://www.fila.us.com

http://www.coachhandbagsfactoryoutletonline.us.com

http://www.tombradyjerseys.us.com

http://www.newcoachoutlet.us.com

http://www.katespadeoutletsale.us.com

http://www.niketrainers.org.uk

http://oakley.sunglassesoutlet.us

http://www.hollisteroutlet.us.org

http://www.oakleysunglassescom.us.com

http://www.ralphlaurenfactorystore.us.com

http://www.coachoutletonsale.us.com

http://www.coach-factoryonline.us.org

http://www.camisetasfutbole2018.com

http://www.rayban-sunglassesonsale.us.com

http://www.maillotdefootfrance.fr

http://www.converseshoes.us.org

http://www.tiffanyjewelry.in.net

http://www.truereligion-jeans.me.uk

http://www.linksoflondonuk.me.uk

http://www.pandora-jewelry.name

http://www.longchamp-outletstore.us.com

http://www.nikeoutletus.us.com

http://www.poloralphlaurenoutlet.org.uk

http://www.adidasshoess.us.com

http://www.audemarspiguet.us.com

http://www.northface--outlet.in.net

http://www.cheapjordansshoes.in.net

http://www.poloralphlaurens.us.com

http://www.adidasoutletstores.net

http://www.louboutins.us.com

http://www.nikeshox.in.net

http://www.truereligionoutletjeans.us

http://www.coach-bags.us.org

http://www.baseballbats.us.com

http://www.michaelkorsoutletcheapest.us.com

http://www.oakleysunglassesparts.us.com

http://www.ray-ban.me.uk

http://www.nikekyrie3.us.com

http://www.adidasoutletadidas.us.com

http://www.redbottoms.us.org

http://www.cheapraybansunglasses.net.co

http://www.supremeuk.co.uk

http://www.newbalancestore.us.com

http://www.airjordanretro.fr

http://www.nikejordans.co.uk

http://www.toryburchbags.us.com

http://www.raybansunglassescheapest.us.com

http://www.yslmakeup.us

http://www.airmax97.org

http://www.coachoutletstoreonlineofficial.us.com

http://www.longchampoutlet-store.us.com

http://www.raybansunglassesoutlet.net.co

http://www.michaelkorshandbagssales.us.com

http://www.newbalance-shoes.us.com

http://www.ralphlaurenoutletofficial.us.com

http://www.baseballjersey.us.com

http://www.flipflops.me.uk

http://www.cheapraybans.ca

http://www.magliacalcioshop.it

http://www.jordanxx9.in.net

http://www.asics.us.org

http://www.cheapnfljerseysnike.us.com

http://www.nikedunksb.us

http://www.bcbg.us.com

http://www.nikestores.us

http://www.louboutinchristian.us.com

http://www.fussballtrikotsshop.de

http://www.outletralph-lauren.us.com

http://www.adidasnmdoutlet.us.com

http://www.coachoutlet-handbags.us.com

http://www.suprashoesclearance.us.com

http://www.stephcurryjerseys.com

http://www.air-jordan.us.com

http://www.ferragamoshoesoutlet.us.com

http://www.christianlouboutinoutletuk.org.uk

http://www.tiffanyco.org

http://www.hardenvol2.us.com

http://www.manchesterunitedjersey.us.com

http://www.miumiu.us.com

http://www.lebronsoldier10.com

http://www.cheapuggsoutlet.us

http://www.supra.us.org

http://www.miumiusunglasses.com

http://www.coachoutletstore.eu.com

http://www.canadagooses.us.com

http://www.juicycoutureoutlet.us.com

http://www.ninewest.us.com

http://www.spaldingbasketball.us

http://www.nikekd8.com

http://www.michaelkors.org.uk

http://www.mooseknucklesjackets.us.com

http://www.airmax270.org

http://www.levisjeans.us.com

http://www.nikefree-run.fr

http://www.truereligionsale.com.co

http://www.balenciagashop.us.com

http://www.dolceandgabbana.us.com

http://www.pumafentysandals.us.com

http://www.jordans-fusion.com

http://www.footballsoccershirts.me.uk

http://www.fingerlingsmonkey.org

http://www.rosherun.org

http://www.michael-korstaschen.ch

http://www.jordan12.org

http://www.vans.us.org

http://www.nikeairmax90.us.org

http://www.tory-burchshoes.us.com

http://www.swarovskijewelry.co.uk

http://www.runningshoes.us.org

http://www.pandorajewelrysoutlet.us.com

http://www.ralphlaurenpolos.fr

http://www.bvlgari.us.com

http://www.snapbacks-wholesale.us.com

http://www.poloshirtsoutlet.us.com

http://www.nfl-jersey.in.net

http://www.adidaswings.name

http://www.air-jordanpascher.fr

http://www.poloralph.us.com

http://www.ralphlaurenjeans.us

http://www.mikimotojewelry.com

http://www.dansko.us.com

http://www.nikedunks.us

http://www.ralphlauren-poloshirts.me.uk

http://www.michaelkorsukstore.co.uk

http://www.louboutinoutlets.us.com

http://www.nikefree.me.uk

http://www.ralph-laurenpolouk.org.uk

http://www.basketballshoesstore.us.com

http://www.coachoutletonlinestore.ca

http://www.jordan4.net

http://www.airmaxplus.org

http://www.burberrysale.us.org

http://www.sophiawebstershoes.us

http://www.adidasoriginalsstansmith.us.com

http://www.outletcanadagoosesale.us.com

http://www.ralphlaurens.fr

http://www.weddingshoes.us.com

http://www.tiffanyandcojewelry.us.com

http://www.pandoracharmjewelry.us.com

http://www.giuseppe-zanotti.us.com

http://www.redbottomsshoes.me.uk

http://www.soccerjersey.us.com

http://www.mkpurse.us.com

http://www.coachoutletstoreonlineclearances.us.org

http://www.tommyhilfigerpoloshirts.us.com

http://www.outletmichaelkorsoutletonline.us.com

http://www.jordans.in.net

http://www.converseshoesoutlet.us.com

http://www.nikeairforce1.net

http://www.prada.us.org

http://www.nikeoff.com

http://www.hardenvol1.us.com

http://www.tomfordsunglasses.us.com

http://www.rayban.net.co

http://www.raybansunglassesoutlet.co.uk

http://www.manoloblahnik.us

http://www.vetementsclothing.com

http://www.michaelkorshandbagsmacys.us.com

http://www.newbalancesandals.us.com

http://www.rolexwatches.us.com

http://www.adidasslides.us.com

http://www.jordan1.us

http://www.nikefactory.us

http://www.yeezydesertrat500.us.com

http://www.nikehyperdunks.com

http://www.yoga-pants.us.com

http://www.michaelkorsoutlet70off.us.com

http://www.timberlandpro.us.com

http://www.yvessaintlaurentsunglasses.com

http://www.jerseys.eu

http://www.airhuarache.fr

http://www.soldier11.com

http://www.adidasjeremyscott.in.net

http://www.airmax95.us.org

http://www.maxairnike.us.com

http://www.longchampsacsoldes.fr

http://www.pelikanpens.us.com

http://www.breitling.us.com

http://www.balenciaga-triples.us.com

http://www.maccosmetics.org.uk

http://www.northfaceoutlet.in.net

http://www.calciomaglie.it

http://www.thehundredsclothing.com

http://www.superdry.me.uk

http://www.timberlandoutlet.us.org

http://www.ralphlaurensale.org.uk

http://www.timberlandboots-uk.org.uk

http://www.montblancpen.in.net

http://www.nhlhockey-jerseys.us.com

http://www.hermesbirkinbags.us.com

http://www.vansshoesoutlet.us.com

http://www.jimmychoooutlet.us.com

http://www.jordan6.net

http://www.maillotdefootcenter.fr

http://www.cheapraybansunglass.co.uk

http://www.outlet-celine.com

http://www.oakleysunglassescanada.ca

http://www.fitflopssaleclearance.us.org

http://www.cheapnfljerseysfree.us.com

http://www.chaussuresnikeairmax.fr

http://www.christianlouboutinshoessale.org.uk

http://www.hermeskellybag.us.com

http://www.flops.us.com

http://www.nikelunarglide.us

http://www.pandoracharmss.org.uk

http://www.toryburchsandals.us.com

http://www.mbt.us.com

http://www.longchamphandbagstotes.us.com

http://www.coachcom.us.com

http://www.salvatoreferragamo.in.net

http://www.nikefree.net

http://www.nfljerseyshop.us.com

http://www.airmax1.us

http://www.swarovskijewelryoutlet.us.com

http://www.oakleysunglasses.us

http://www.columbia-sportswear.us.com

http://www.off-whiteclothing.us.com

http://www.soccerjersey.us.org

http://www.ray-banssunglasses.org.uk

http://www.timberlandboots.us

http://www.underarmouroutletclearance.com

http://www.mizuno.us.org

http://www.fitflopsoutlet.us.com

http://www.adidasnmdforsale.us.com

http://www.leejeans.us.com

http://www.truereligion-jeans.us

http://www.katespade-outlet.in.net

http://www.barcelonajersey.us.com

http://www.shopbasketballshoes.us.com

http://www.rayban.in.net

http://www.bottega.in.net

http://www.fitflopssale.org.uk

http://www.alexandermcqueen.us.com

http://www.monsterheadphones.us.com

http://www.pasottiombrelli.us

http://www.nikeflipflops.org

http://www.shopbrandbelts.com

http://www.versacebags.us.com

http://www.airjordan.me.uk

http://www.undefeated.us.com

http://www.sauconyshoes.us.com

http://www.birkenstockoutlet.us.org

http://www.coachoutletonline-sale.us.com

http://www.russellwestbrook.us.com

http://www.christianlouboutinoff.us

http://www.marcjacobs.me.uk

http://www.katespadehandbagssale.us.org

http://www.tods.us.com

http://www.nikekd10.us.com

http://www.sunglassesoakleycheap.us.com

http://www.lululemon.in.net

http://www.coachoutlet-online.eu.com

http://www.y3shoes.us.com

http://www.birkenstocksandalsonsale.us.com

http://www.marceloburlon.us.com

http://www.adidasflipflops.us.com

http://www.nikefreeruns.us.com

http://www.stansmithadidas.org.uk

http://www.cheapmichaelkorshandbags.us.org

http://www.beatsbydrdresolo.us

http://www.coachwallets.us.com

http://www.oakleysunglasses.ru

http://www.shoecarnival.us.com

http://www.michael-korsoutletstores.us.org

http://www.kanyeyeezyshoes.us.com

http://www.oakleysunglasses-vault.us.com

http://www.adidasyeezy350.us.com

http://www.vibram-fivefingers.us.com

http://www.marcjacobsbags.us.com

http://www.nikesshoes.us.com

http://www.nikeairmax90.com.de

http://www.hermesoutlets.us.com

http://www.replicawatches.in.net

http://www.brequet.us.com

http://www.beatsheadphones.us.com

http://www.nikecortez.net

http://www.tevasandals.us.com

http://www.mauijimsunglasses.us.com

http://www.supreme-newyork.com

http://www.adidassuperstarshoes.us.com

http://www.christianlouboutinoutletus.us.com

http://www.huarache.us.com

http://www.pandorajewelry.us.org

http://www.lululemonsale.us.com

http://www.nicholaskirkwood.us.com

http://www.pandoraukcharms.co.uk

http://www.stuartweitzmanshoes.us.com

http://www.supremeclothing.us.com

http://www.lightup-shoes.us.com

http://www.off-white.us.com

http://www.versaceclothing.com

http://www.katespadestoreoutlet.us.com

http://rayban.sunglassesoutlet.us

http://www.coachoutlet-factory.us.com

http://www.hermesbags.me.uk

http://www.reebokclassicshoes.us.com

http://www.nikepresto.us.com

http://www.airforce1.in.net

http://www.lebron15.name

http://www.nikeairmax.us.org

http://www.fitflops.us.org

http://www.givenchyhandbags.us.com

http://www.wholesaleoakleysunglasses.us.org

http://www.supremeparis.fr

http://www.michaelkorsshandbags.us.com

http://www.fitflopss.us.com

http://www.truereligionjeans-outlet.us.com

http://www.underarmourshoes.in.net

http://www.katespadehandbagsoutlet.us.org

http://www.louboutins.me.uk

http://www.airmax.us.org

http://www.nikeblazers.us

http://www.burberryoutlet-canada.ca

http://www.macmakeup.org.uk

http://www.lebronsoldier9.org

http://www.cheapnhljerseysshop.us.com

http://www.skecherssandals.us.com

http://www.trikotsgünstig.de

http://www.lebron15.in.net

http://www.vansshoes.us.org

http://www.pradaoutletonlinestore.us.com

http://www.kobe12shoes.us.com

http://www.jordanshoes.us.org

http://www.adidasstoreuk.me.uk

http://www.victoriassecret.us.com

http://www.nobisjackets.us.com

http://www.oakley-sunglassesonsale.us.com

http://www.maccosmeticsofficial.us.com

http://www.pumasoutlet.us.com

http://www.canadagoose-sale.ca

http://www.woolrichjackets.us.com

http://www.pandorajewelrys.ca

http://www.columbiaoutlet.us.org

http://www.mishka.us.com

http://www.cheapjerseys.in.net

http://www.philipppleinoutlets.us.com

http://www.lindafarrowsunglasses.com

http://www.nikeukstores.me.uk

http://www.manoloblahnik.name

http://www.omegawatches.us.org

http://www.michaelkorsoff.us.com

http://www.pradahandbagsoutlet.us.com

http://www.jordans.us.org

http://www.michael-kors-canada.ca

http://www.converse.me.uk

http://www.poloralphlaurensoutlet.us.com

http://www.redbottomshoes.org.uk

http://www.montblanc.com.co

http://www.pradasunglass.us.com

http://www.timberlandoutletonline.us.com

http://www.christianoronaldojersey.com

http://www.the--northface.co.uk

http://www.coachoutletfactoryofficial.us.com

http://www.jordan5.us

http://www.russellwestbrookjerseys.us

http://www.lebron14.org

http://www.balenciagasandals.us.com

http://www.lebron13.org

http://www.jerseys.us.org

20187.24wengdongdong

July 23, 2018 11:44 PM

Leave a Comment

(required) 
(required) 
Submit

About Maria Zakourdaev

The shortest word in the English language that contains the letters: abcdef is… feedback! Let me know if I have touched something that is alive in the cosmos.
Privacy Statement