The most traded LDs

nextwednesday · Posted: 22 Apr 2014, 14:35

Hello

I was wondering what LDs were the most traded on LDDB.

By looking at individual examples, one can see the sales history, which is very interesting. For instance:

Is there a way of querying the database for the most-traded LDs, by number of trades or by total price without looking at individual titles?

Otherwise, what are people's discoveries for the most traded discs? I don't think exceptional prices for rare discs are that interesting, so let's say minimum of 5 trades.

admin · Posted: 07 May 2014, 08:37

nextwednesday wrote:

I was wondering what LDs were the most traded on LDDB.

Nothing available directly to users but I ran a quick SQL query:

Code: Select all

+--------------+--------------+------------------------------------------+
| Transactions | Reference    | Title                                    |
+--------------+--------------+------------------------------------------+
|           35 | PILF-2830    | Star Wars: The Phantom Menace            |
|           32 | 17665        | Matrix, The                              |
|           21 | ID5477LI     | Rush Hour                                |
|           20 | LV 1376-WS   | Indiana Jones: Raiders of the Lost Ark   |
|           20 | 0693-84      | Star Wars Trilogy: Definitive Collection |
|           19 | 12000 A/B    | Batman                                   |
|           18 | LV 33118-2WS | Braveheart                               |
|           18 | 82406        | Fifth Element, The                       |
|           18 | 8764-85      | Star Wars: The Empire Strikes Back       |
|           18 | 0411885      | Independence Day: ID4                    |
|           18 | 4102985      | Star Wars Trilogy: Special Edition       |
+--------------+--------------+------------------------------------------+

Julien

nextwednesday · Posted: 07 May 2014, 13:51

Ah, that's great. Thanks, Julien.

I'm glad I found 3 of the top 5 by guesswork but I was stymied by the maximum of 25 trades shown on the past sales page.

Any chance of adding the summed value of the trades too?

This one got $3165-worth of trades, I notice: Cell, The (2000) (Uncut) [PILF-2868]
And this one got $3720! U-571 (2000) [PILF-2862]

How do we know whether individual trades like U571 for $2000 actually happened?

I hope other people find this interesting too.

admin · Posted: 08 May 2014, 06:18

Quick rounded approximation:

Code: Select all

+--------------+-----------+-------------------------------------+
| Transactions | Reference | Title                               |
+--------------+-----------+-------------------------------------+
|       $4,590 | PILF-2842 | World is not Enough, The            |
|       $4,051 | PILF-2865 | Mission: Impossible 2               |
|       $3,720 | PILF-2862 | U-571                               |
|       $3,228 | 17665     | Matrix, The                         |
|       $3,165 | PILF-2868 | Cell, The                           |
|       $2,545 | PILF-7405 | Sixth Sense, The: Collector Edition |
|       $2,280 | PILA-3043 | Titan A.E.                          |
|       $2,127 | PILF-1096 | Song of the South                   |
|       $2,050 | PILF-2867 | Sixth Day, The                      |
|       $2,007 | PILF-2857 | Stigmata                            |
+--------------+-----------+-------------------------------------+

Julien

edwin240170 · Posted: 08 May 2014, 16:28

All,

please take care only looking at the number of totals, see the picture of number of sales and average,
very nice to see is 2 titles have been sold on the same day for the same price of 2000 mmmmm can not believe it honestly :evil:

laserdisc_fan · Posted: 08 May 2014, 20:24

edwin240170 wrote:

All,

please take care only looking at the number of totals, see the picture of number of sales and average,
very nice to see is 2 titles have been sold on the same day for the same price of 2000 mmmmm can not believe it honestly :evil:

Very interesting and confirms it was the same buyer who overpaid on both.

kris · Posted: 08 May 2014, 20:35

I don't buy it... :shh:

Titles fetching that kind of money :think:

If they did... :clap:

to the seller :thumbup:

substance · Posted: 09 May 2014, 05:18

When you buy the cell for $5700 from ugu, will he fly over and hand deliver the ld?

laserdisc_fan · Posted: 09 May 2014, 06:04

substance wrote:

When you buy the cell for $5700 from ugu, will he fly over and hand deliver the ld?

Probably would be economic to include plane flight & stay in 5 star hotel for buyer!

admin · Posted: 09 May 2014, 06:55

edwin240170 wrote:

very nice to see is 2 titles have been sold on the same day for the same price of 2000 mmmmm can not believe it honestly :evil:

He did buy them and received them. Visitor with no objection to money who wanted to quickly build a nice collection.

That only happened twice in LDDb history.

Julien

nextwednesday · Posted: 09 May 2014, 10:19

laserdisc_fan wrote:

substance wrote:

When you buy the cell for $5700 from ugu, will he fly over and hand deliver the ld?

Probably would be economic to include plane flight & stay in 5 star hotel for buyer!

Imagine the service you'd get from Paradigm if you bought Tokyo Raiders for £7777 then!

Still, as Julien has confirmed, these occurrences are not impossible.

substance · Posted: 09 May 2014, 11:23

He should sit down and translate it

The most traded LDs

Who is online