Skip to content

Instantly share code, notes, and snippets.

@averylizette

averylizette/Core Query Results Cassandra and Postgres

Last active November 7, 2019 00:49
Show Gist options
  • Save averylizette/612b332b7471f2e90901ca5c097f50fa to your computer and use it in GitHub Desktop.
Save averylizette/612b332b7471f2e90901ca5c097f50fa to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Core Query Results Cassandra and Postgres
\\\\\\\\\\\\\\\\\\\\\\
\\\\POSTGRES \\\\\\\\\
\\\\\\\\\\\\\\\\\\\\\\
GET THE INFORMATION FOR A LISTING INCLUDING ALL OF ITS PHOTOS:
First, parition for the location and price of a given id:
select * from geninfo where listingid = 9999999;
listingid | location | price | reviewcount | rating | title
-----------+------------+-------+-------------+--------+----------------------------
9999999 | Terre Hill | 581 | 179 | 4.66 | id corporis exercitationem
(1 row)
Time: 2.699 ms
Then parition for similar listings given that information:
Spostgres=# SELECT * FROM (SELECT * FROM geninfo WHERE location='York' AND price BETWEEN 200 AND 300 LIMIT 12) genInfo, LATERAL (SELECT * FROM photos WHERE photos.listingid = geninfo.listingid) photos;
listingid | location | price | reviewcount | rating | title | listingid | image | id
-----------+----------+-------+-------------+--------+--------------------------+-----------+-------------------------------+-----------
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 19165760
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 20948427
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 22216274
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 22760224
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 25241176
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 25691395
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 28049821
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 28980642
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 29627678
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 29860956
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 43481897
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 50972757
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 51064135
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 53143166
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 55144502
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 55850203
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 56623868
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 56793252
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 57380077
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 57526695
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 66679826
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 70456476
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 70939932
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 75220725
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 81241978
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 83257415
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 83550308
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 84082078
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 84412836
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 86713717
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 87913391
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 88249878
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 88382863
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 89021154
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 89569972
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 90659463
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 92190984
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 93731300
49150 | York | 241 | 183 | 3.6 | dolorum corrupti aut | 49150 | http://lorempixel.com/640/480 | 108725873
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 2792971
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 2892688
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 10194877
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 13695862
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 14346201
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 17317417
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 20806822
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 20970262
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 21748919
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 22324488
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 22642876
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 25815167
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 27144831
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 27888604
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 28035763
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 29122446
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 37734529
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 47718855
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 48192151
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 50499546
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 50864068
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 51077303
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 53179199
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 54550771
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 54962752
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 55801903
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 55836498
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 55946560
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 55948265
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 61214724
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 64782532
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 71765890
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 83864726
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 86580724
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 87548547
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 89185909
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 90421212
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 91402384
50162 | York | 284 | 187 | 4.94 | iste aut error | 50162 | http://lorempixel.com/640/480 | 106498211
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 15824251
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 18566958
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 19894718
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 20704373
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 25133438
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 25464700
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 25671999
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 28394286
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 28618874
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 28624541
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 28691903
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 29341788
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 45775422
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 49339510
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 50554797
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 52349743
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 52820732
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 56008517
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 57924706
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 58358149
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 59815935
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 83422715
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 83574865
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 83982101
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 84242360
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 84451684
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 85485368
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 85942742
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 89028777
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 91759289
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 93524575
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 96172589
103110 | York | 267 | 210 | 4.17 | aut quisquam perferendis | 103110 | http://lorempixel.com/640/480 | 110986574
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 18353030
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 20249289
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 20455773
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 20680032
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 23491450
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 25180142
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 26256689
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 27112640
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 27771002
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 28263134
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 28820929
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 32213744
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 36448305
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 42272941
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 49398562
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 50115940
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 51748012
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 52050013
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 53469903
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 54398199
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 54828425
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 55043864
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 55453156
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 57966087
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 63106055
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 74999598
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 80454082
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 80480298
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 81359484
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 82158985
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 82441993
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 82462725
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 83858082
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 84258617
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 84509325
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 84701757
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 84746836
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 85390160
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 85943957
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 86247805
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 86667510
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 88993662
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 89270803
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 89835099
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 100893566
122525 | York | 217 | 41 | 3.89 | est voluptatem dolor | 122525 | http://lorempixel.com/640/480 | 101913951
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 19255014
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 19940965
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 23035162
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 23759904
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 24270546
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 25215134
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 25964058
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 26357201
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 26434398
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 28694175
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 29316943
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 39699443
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 41583048
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 51555173
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 52122411
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 53294995
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 57718175
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 59280810
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 61042416
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 81337638
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 82196294
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 85084708
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 86661716
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 86877968
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 86925222
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 87229145
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 87891764
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 88327327
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 89110186
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 93153526
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 102020319
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 105126650
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 112074649
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 112791386
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 115294899
223406 | York | 246 | 188 | 4.38 | voluptatibus odit et | 223406 | http://lorempixel.com/640/480 | 118987693
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 2369222
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 4030339
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 11488133
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 20410960
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 20816194
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 21421848
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 21468279
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 23008173
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 24541014
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 24695068
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 26083602
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 26280230
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 27010736
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 31292408
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 41338879
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 44421597
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 50609083
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 50788624
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 50827956
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 50911512
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 51738251
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 51964456
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 52113419
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 53790678
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 55022515
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 55156441
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 55209007
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 55576304
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 55728797
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 55795119
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 57041786
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 57925529
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 58726591
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 59314497
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 67064688
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 70361226
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 73651482
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 80491977
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 80666902
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 81127711
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 81567688
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 82411721
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 82797716
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 83692171
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 83711355
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 84502978
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 84634653
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 84694998
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 85736083
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 86230185
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 89284262
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 89714863
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 92632243
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 97916276
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 100899611
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 103281504
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 105449414
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 115736235
419040 | York | 281 | 132 | 4.2 | eligendi dolores enim | 419040 | http://lorempixel.com/640/480 | 116573405
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 6139328
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 12882875
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 20318773
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 20346371
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 21890510
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 22900419
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 24589228
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 25478095
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 27129802
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 28765934
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 34361356
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 36037427
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 44526558
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 46088300
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 46577494
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 49648708
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 52003135
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 52398947
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 53041662
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 56417516
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 56507956
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 58116508
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 59415427
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 60778477
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 68681056
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 82768027
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 82770798
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 83575301
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 83590823
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 83684501
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 84367958
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 85857150
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 87341880
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 87545304
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 87648005
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 87797943
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 88081092
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 88503894
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 98135379
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 98523193
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 100141317
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 100258834
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 102199016
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 103840728
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 104019508
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 118178606
561703 | York | 273 | 131 | 4.99 | libero qui ad | 561703 | http://lorempixel.com/640/480 | 119855492
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 176985
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 9472191
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 15641113
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 19591751
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 19650276
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 20162330
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 20698458
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 20973479
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 21253890
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 21259912
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 21544606
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 21869550
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 22631085
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 25085234
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 25510989
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 26922594
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 27349976
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 27784637
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 29039412
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 41822144
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 43166100
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 45763972
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 45868833
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 50156355
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 53001621
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 53029073
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 53216270
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 55782366
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 57301704
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 57622779
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 57784173
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 58602944
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 59793480
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 62444034
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 67802438
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 81104238
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 82273419
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 83232438
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 83376951
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 85078999
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 85590455
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 87103506
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 88040626
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 93332102
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 95017719
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 96152224
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 104604610
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 108000922
598650 | York | 234 | 215 | 4.3 | dolor est eligendi | 598650 | http://lorempixel.com/640/480 | 113261622
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 3168949
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 13087697
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 18175019
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 20952841
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 22737454
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 25840841
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 26421503
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 27244343
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 28272889
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 28941519
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 39722883
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 41246973
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 45519112
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 46023109
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 46386570
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 49690070
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 51204606
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 51227682
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 51302935
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 53452729
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 55860756
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 57958769
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 58378031
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 58860638
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 59442381
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 59456394
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 72522382
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 74691914
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 79989433
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 81746656
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 82172386
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 83884918
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 84108483
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 84354982
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 84395386
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 85018095
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 85498980
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 87009533
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 89075266
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 89845470
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 89891836
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 91184346
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 95035746
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 98842439
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 105309919
638274 | York | 240 | 155 | 3.85 | unde adipisci in | 638274 | http://lorempixel.com/640/480 | 114466209
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 11667881
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 15794332
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 15880347
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 40174429
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 49807976
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 79421828
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 91087195
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 103431304
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 104328287
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 106561965
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 110023877
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 111473500
1253665 | York | 273 | 21 | 3.83 | ea eum voluptatem | 1253665 | http://lorempixel.com/640/480 | 113271756
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 252869
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 14822143
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 14927032
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 37106542
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 41220616
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 45220866
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 46743122
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 48033845
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 75701895
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 94310858
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 95222138
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 103387379
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 105658724
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 107320051
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 111675637
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 112616260
1305500 | York | 224 | 213 | 4.69 | similique aut et | 1305500 | http://lorempixel.com/640/480 | 113587855
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 10737188
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 15328314
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 32461771
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 32554739
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 34835131
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 76585163
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 95983705
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 98868681
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 99751928
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 103039960
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 103082222
1327071 | York | 300 | 267 | 3.21 | aut harum veniam | 1327071 | http://lorempixel.com/640/480 | 104797774
(436 rows)
Time: 346.826 ms
\\\\\\\\\\\\\\\\\
\\\\CASSANDRA\\\\\
\\\\\\\\\\\\\\\\\\\
GIVE ME ALL FROM LISTING TABLE (parition 1), THEN with that information I will parition the db for 12 similar listings (parition2)
select * from lookup where listingid=9999999;
listingid | location | price
-----------+------------------+-------
9999999 | West Long Branch | 122
(1 rows)
Tracing session: 95973be0-00f7-11ea-8041-1bcc6023f22e
activity | timestamp | source | source_elapsed | client
-----------------------------------------------------------------------------------------+----------------------------+-----------+----------------+-----------
Execute CQL3 query | 2019-11-06 16:43:15.494000 | 127.0.0.1 | 0 | 127.0.0.1
Parsing select * from lookup where listingid=9999999; [Native-Transport-Requests-1] | 2019-11-06 16:43:15.499000 | 127.0.0.1 | 10463 | 127.0.0.1
Preparing statement [Native-Transport-Requests-1] | 2019-11-06 16:43:15.508000 | 127.0.0.1 | 19785 | 127.0.0.1
Executing single-partition query on lookup [ReadStage-2] | 2019-11-06 16:43:15.521000 | 127.0.0.1 | 32866 | 127.0.0.1
Acquiring sstable references [ReadStage-2] | 2019-11-06 16:43:15.522000 | 127.0.0.1 | 32960 | 127.0.0.1
Skipped 0/3 non-slice-intersecting sstables, included 0 due to tombstones [ReadStage-2] | 2019-11-06 16:43:15.523000 | 127.0.0.1 | 34001 | 127.0.0.1
Bloom filter allows skipping sstable 54 [ReadStage-2] | 2019-11-06 16:43:15.531000 | 127.0.0.1 | 42477 | 127.0.0.1
Key cache hit for sstable 55 [ReadStage-2] | 2019-11-06 16:43:15.532000 | 127.0.0.1 | 43671 | 127.0.0.1
Bloom filter allows skipping sstable 53 [ReadStage-2] | 2019-11-06 16:43:15.538000 | 127.0.0.1 | 49312 | 127.0.0.1
Merged data from memtables and 1 sstables [ReadStage-2] | 2019-11-06 16:43:15.542000 | 127.0.0.1 | 53137 | 127.0.0.1
Read 1 live rows and 0 tombstone cells [ReadStage-2] | 2019-11-06 16:43:15.544000 | 127.0.0.1 | 55493 | 127.0.0.1
Request complete | 2019-11-06 16:43:15.554786 | 127.0.0.1 | 60786 | 127.0.0.1
GIVEN THE LOCATION and PRICE FROM PARTITION 1 GIVE ME 12 SIMILAR LISTINGS
cqlsh:recommendations> select * from geninfo where location='York' AND price > 200 AND price < 300 limit 12 allow filtering;
price | location | rating | reviewcount | title
-------+----------+--------+-------------+----------------------------------
214 | York | 4.14 | 174 | pariatur consequatur perferendis
219 | York | 4.2 | 246 | autem voluptatem aut
274 | York | 3.21 | 56 | et aperiam dignissimos
277 | York | 4.11 | 225 | dicta neque sit
248 | York | 4.07 | 5 | laboriosam blanditiis voluptates
264 | York | 4.26 | 234 | amet repudiandae facere
245 | York | 4.86 | 66 | provident harum assumenda
241 | York | 5 | 173 | consequuntur et aut
286 | York | 4.53 | 119 | quis unde doloremque
261 | York | 3.14 | 151 | perferendis repellendus beatae
201 | York | 4.68 | 8 | ut voluptas expedita
210 | York | 4.81 | 169 | deleniti laudantium possimus
(12 rows)
Tracing session: cf530cb0-00f7-11ea-8041-1bcc6023f22e
activity | timestamp | source | source_elapsed |client
---------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+-----------+----------------+-----------
Execute CQL3 query | 2019-11-06 16:44:52.349000 | 127.0.0.1 | 0 |127.0.0.1
Parsing select * from geninfo where location='York' AND price > 200 AND price < 300 limit 12 allow filtering; [Native-Transport-Requests-1] | 2019-11-06 16:44:52.354000 | 127.0.0.1 | 5608 |127.0.0.1
Preparing statement [Native-Transport-Requests-1] | 2019-11-06 16:44:52.434000 | 127.0.0.1 | 85735 |127.0.0.1
Computing ranges to query [Native-Transport-Requests-1] | 2019-11-06 16:44:52.448000 | 127.0.0.1 | 99479 |127.0.0.1
Submitting range requests on 257 ranges with a concurrency of 1 (11389.2 rows per range expected) [Native-Transport-Requests-1] | 2019-11-06 16:44:52.482000 | 127.0.0.1 | 133379 |127.0.0.1
Submitted 1 concurrent range requests [Native-Transport-Requests-1] | 2019-11-06 16:44:52.508000 | 127.0.0.1 | 159262 |127.0.0.1
Executing seq scan across 3 sstables for (min(-9223372036854775808), min(-9223372036854775808)] [ReadStage-2] | 2019-11-06 16:44:52.508000 | 127.0.0.1 | 159733 |127.0.0.1
Read 153 live rows and 0 tombstone cells [ReadStage-2] | 2019-11-06 16:44:52.902000 | 127.0.0.1 | 553028 |127.0.0.1
Request complete | 2019-11-06 16:44:52.904812 | 127.0.0.1 | 555812 |127.0.0.1st complete | 2019-11-05 20:57:54.044135 | 127.0.0.1 | 775135 | 127.0.0.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment