SELECT p.id
  , p.name
  , p.surname
  , p.email
  , c.start AS beginning
  , c.END AS finnish
  , c.name AS title
  , c.event AS description
  , c.id AS eventid
FROM calendar c
INNER JOIN attendance a ON a.event = c.id
INNER JOIN players p ON p.id = a.player
WHERE  (
c.added >= '1141740333'
AND c.added <= '1141826733'
)
ORDER BY p.id ASC
  , c.start ASC
LIMIT 0, 30

-- 
-- Table structure for table `attendance`
-- 
 
CREATE TABLE `attendance` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `event` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `player` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `present` ENUM('yes','no') NOT NULL DEFAULT 'no',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=2 ;
 
-- 
-- Dumping data for table `attendance`
-- 
 
INSERT INTO `attendance` VALUES (1, 1, 2, 'yes');
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `calendar`
-- 
 
CREATE TABLE `calendar` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(128) NOT NULL DEFAULT '',
  `author` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `event` TEXT NOT NULL,
  `start` INT(16) NOT NULL DEFAULT '0',
  `END` INT(16) NOT NULL DEFAULT '0',
  `added` INT(16) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=1 AUTO_INCREMENT=2 ;
 
-- 
-- Dumping data for table `calendar`
-- 
 
INSERT INTO `calendar` VALUES (1, 'Birthday', 1, 'It''s my birthday!', 1141999200, 1142006400, 1141826592);
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `players`
-- 
 
CREATE TABLE `players` (
  `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(128) NOT NULL DEFAULT '',
  `surname` VARCHAR(128) NOT NULL DEFAULT '',
  `email` VARCHAR(128) NOT NULL DEFAULT '',
  `password` VARCHAR(128) NOT NULL DEFAULT '',
  `homephone` VARCHAR(128) NOT NULL DEFAULT '',
  `mobile` VARCHAR(128) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=1 AUTO_INCREMENT=3 ;
 
-- 
-- Dumping data for table `players`
-- 
 
INSERT INTO `players` VALUES (1, 'John', 'Doe', 'john@doe.com', 'md5password', '123456789', '8768686865');
INSERT INTO `players` VALUES (2, 'Bob', 'the Builder', 'bob@builder.com', 'thisismypassword', '987654321', '989797976');