$winners = array();
$query = db_select('neo_mini_participations', 'p');
$query->join('neo_users', 'n', 'n.CSUserID = p.user_id');
$query->join('neo_mini_iw_dates', 'd', 'd.id = p.iw_id');
$query->fields('p', array('timestamp', 'code'));
$query->fields('d', array('gift_code'));
$query->fields('n', array('ID', 'Title', 'FirstName', 'LastName', 'Email', 'Phone', 'Street', 'Zip', 'City', 'Country'));
$query->isNotNull('p.iw_id');
$logs = $query->execute()->fetchAll();
foreach( $logs as $index =>$log ) {
  $winners[$index]['instant_game_time'] = date('Ymd H:i:s', $log->timestamp);
  $winners[$index]['earning'] = isset($log->gift_code) ? $log->gift_code : '';
  $winners[$index]['winning_code'] = $log->code;
  $winners[$index]['ID'] = $log->ID;
  $winners[$index]['Title'] = $log->Title;
  $winners[$index]['FirstName'] = $log->FirstName;
  $winners[$index]['LastName'] = $log->LastName;
  $winners[$index]['Email'] = $log->Email;
  $winners[$index]['Phone'] = $log->Phone;
  $winners[$index]['Street'] = $log->Street;
  $winners[$index]['Zip'] = $log->Zip;
  $winners[$index]['City'] = $log->City;
  $winners[$index]['Country'] = $log->Country;
}
dsm($winners);