MySQL gods... Purple Dreamer caches.
MySQL gods... Purple Dreamer caches.
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.
- caughtatwork
- Posts: 17017
- Joined: 17 May 04 12:11 pm
- Location: Melbourne
- Contact:
Re: MySQL gods... Purple Dreamer caches.
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.
Re: MySQL gods... Purple Dreamer caches.
Thanks anyway.
Re: MySQL gods... Purple Dreamer caches.
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..
A list of GC codes of all ones matching "%purpledreamer%" in the open text owner field will do. I will then sort the rest..
Re: MySQL gods... Purple Dreamer caches.
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
http://www.geocaching.com/bookmarks/vie ... 086ab9b147
- gmj3191
- 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.
There are at least 2 more as in this one she says it's her 101st hide.
http://coord.info/GC3GRZG
http://coord.info/GC3GRZG
- caughtatwork
- Posts: 17017
- Joined: 17 May 04 12:11 pm
- Location: Melbourne
- Contact:
Re: MySQL gods... Purple Dreamer caches.
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"
"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"
- gmj3191
- 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.
This is the last one I can find in my GSAK database, and it says it's her 102nd
http://coord.info/GC3KWVG
http://coord.info/GC3KWVG
Re: MySQL gods... Purple Dreamer caches.
Thanks. Bookmark updated with all 102 now.