MySQL gods... Purple Dreamer caches.

Discussion about the Geocaching Australia web site
Post Reply
covert
150 or more caches found
150 or more caches found
Posts: 476
Joined: 30 July 08 11:47 am
Location: VIC

MySQL gods... Purple Dreamer caches.

Post by covert » 12 October 12 9:46 am

Could I request a GC code list off all the geocachers ever owned by Purple Dreamer ? A majority of them have be adopted out now and making a list is a little tricky. If you have an easy way to query that a list would be greatly appreciated.

User avatar
caughtatwork
Posts: 17015
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Re: MySQL gods... Purple Dreamer caches.

Post by caughtatwork » 12 October 12 9:48 am

If they've been formally transferred there isn't anything we can do to identify what used to be. We don't keep history, just the latest data.

covert
150 or more caches found
150 or more caches found
Posts: 476
Joined: 30 July 08 11:47 am
Location: VIC

Re: MySQL gods... Purple Dreamer caches.

Post by covert » 12 October 12 9:57 am

Thanks anyway.

covert
150 or more caches found
150 or more caches found
Posts: 476
Joined: 30 July 08 11:47 am
Location: VIC

Re: MySQL gods... Purple Dreamer caches.

Post by covert » 12 October 12 10:02 am

How about a search by the name in the open text owner field ? I see it has either been left intact or appended to like "purpledreamer (adopted by XXXX)"

A list of GC codes of all ones matching "%purpledreamer%" in the open text owner field will do. I will then sort the rest..

covert
150 or more caches found
150 or more caches found
Posts: 476
Joined: 30 July 08 11:47 am
Location: VIC

Re: MySQL gods... Purple Dreamer caches.

Post by covert » 12 October 12 10:13 am

I did some work at my end and got 99. I don't know if this is them all.

http://www.geocaching.com/bookmarks/vie ... 086ab9b147

User avatar
gmj3191
7500 or more caches found
7500 or more caches found
Posts: 1316
Joined: 22 April 03 12:37 am
Location: Sandringham, Vic Garmin Oregon 650

Re: MySQL gods... Purple Dreamer caches.

Post by gmj3191 » 12 October 12 11:04 am

There are at least 2 more as in this one she says it's her 101st hide.
http://coord.info/GC3GRZG

User avatar
caughtatwork
Posts: 17015
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Re: MySQL gods... Purple Dreamer caches.

Post by caughtatwork » 12 October 12 11:12 am

Where is the "placed_by" (count of 102)
"GC2FB21"
"GC20864"
"GC209PD"
"GC209QY"
"GC20D6W"
"GC27E4Z"
"GC2C5BW"
"GC2CJX7"
"GC2CZRZ"
"GC2D1QH"
"GC2DZHH"
"GC2EDKF"
"GC2EDKX"
"GC2GQD6"
"GC2GQDH"
"GC2GQDV"
"GC2GQDY"
"GC2NTMG"
"GC2NTMT"
"GC2NTNG"
"GC2PJMT"
"GC2QHKB"
"GC2QHKE"
"GC2RH44"
"GC2XTD7"
"GC2XTDD"
"GC2XTDK"
"GC2XTE4"
"GC2XTEK"
"GC2XTET"
"GC2XTF8"
"GC2Z4VG"
"GC31FCN"
"GC335VK"
"GC335W9"
"GC335WR"
"GC335XE"
"GC335XY"
"GC335YW"
"GC33WA5"
"GC33WAY"
"GC33WB7"
"GC33WBT"
"GC34JER"
"GC34M43"
"GC34M49"
"GC39CFA"
"GC3CVX7"
"GC3D48Y"
"GC3EJZZ"
"GC3ETEK"
"GC3ETGT"
"GC3GRWV"
"GC3GRX1"
"GC3GRX5"
"GC3GRXA"
"GC3GRXE"
"GC3GRXK"
"GC3GRXV"
"GC3GRY2"
"GC3GRY6"
"GC3GRYG"
"GC3GRYV"
"GC3GRZ2"
"GC3GRZ7"
"GC3GRZ8"
"GC3GRZG"
"GC2QXVR"
"GC2QDWY"
"GC2QDXA"
"GC2QDY4"
"GC2QDYD"
"GC2QE1D"
"GC2QR6P"
"GC2QR72"
"GC2QR7E"
"GC2QR8V"
"GC2QR94"
"GC2QXRT"
"GC2QXW9"
"GC2QXWK"
"GC2QXWW"
"GC2R01R"
"GC2R01X"
"GC2R09B"
"GC2C11A"
"GC2C11V"
"GC2T079"
"GC33WAB"
"GC35CQE"
"GC3KWVG"
"GC2JPGE"
"GC2XTDY"
"GC2XTG6"
"GC26YF1"
"GC2DXW5"
"GC2GRK5"
"GC2H1TC"
"GC2H206"
"GC2H3ND"
"GC2RR0F"
"GC2RWQR"

User avatar
gmj3191
7500 or more caches found
7500 or more caches found
Posts: 1316
Joined: 22 April 03 12:37 am
Location: Sandringham, Vic Garmin Oregon 650

Re: MySQL gods... Purple Dreamer caches.

Post by gmj3191 » 12 October 12 11:22 am

This is the last one I can find in my GSAK database, and it says it's her 102nd

http://coord.info/GC3KWVG

covert
150 or more caches found
150 or more caches found
Posts: 476
Joined: 30 July 08 11:47 am
Location: VIC

Re: MySQL gods... Purple Dreamer caches.

Post by covert » 12 October 12 11:28 am

Thanks. Bookmark updated with all 102 now.

Post Reply