Hey everyone!! The long awaited Pinmapple Thousand Contest results are out!!! It's taken us such a long time to make the announcement as we had over 90 awesome entries to the two writing contests and nearly 1900 entries to the Raffle draw. The quality of the entries were extremely high and it was very difficult to nail down the winners. We wish we could award more winners but we got there in the end.
Before we announce the winners, we'd like to thank our sponsors for their generosity and supporting the Hive travel community. They are @ausbitbank, @c0ff33a, @crimsonclad, @eturnerx, @martibis and @roelandp
And now without further ado, here are the winners........
The winner is 
In second place is 
In third place is 
We have five honourable mentions who's entries were also of very high quality, a couple of them just missed the top 3 position by a little bit. These five winners each win 50 Hive. Congratulations to....
It was very interesting to read people's experience with Pinmapple and haveyoubeenhere and learn how the project has been part of your Hive journey. Quite a few of you have been here since we first started out over three year ago, so thanks for sticking with us. The judges favourite entries, in no particular order, are
Congratulation guys and gal, you have each won 100 Hive.
We recognised that not everyone creates travel content, but supports Pinmapple and haveyoubeenhere, therefore we created a raffle draw so everyone could enter. In total we had nearly 1900 valid raffle entries and we drew ten lucky winners. Here's an explanation from 
For the techies under us, I wanted to explain how the raffle draws happened. Each completed action has been stored in a MySQL database, with the amount of awarded entries for that action (which could be between 0 - 6 depending on the base entries you get and the multiplier for being featured in one of the digests). So I created a UNION ALL query adding all entries, which I then ordered randomly and limited to 10 winners.
SELECT iduser FROM (SELECT * FROM contestentries WHERE entries > 0 UNION ALL SELECT * FROM contestentries WHERE entries > 1 UNION ALL SELECT * FROM contestentries WHERE entries > 2 UNION ALL SELECT * FROM contestentries WHERE entries > 3 UNION ALL SELECT * FROM contestentries WHERE entries > 4 UNION ALL SELECT * FROM contestentries WHERE entries > 5) as allentries ORDER by RAND() LIMIT 10;
All entries were verified as well to make sure there was no cheating going on.
Congratulations to the following ten lucky winners who has each won 100 Hive:
 |  |
 |  |
 |  |
|  |
 |  |
The team would like to thank everyone who took part in the Pinmapple Thousand contest and for everyone else who's been supporting us all along! We hope we can count on your continued support towards the Pinmapple 2000. Cheers!!