CREATE TABLE `tbl_calendar` (
  `date` date NOT NULL,
  PRIMARY KEY (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `tbl_values` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) NOT NULL DEFAULT '0',
  `date` date DEFAULT '0000-00-00',
  `value` double(15,2) DEFAULT '0.00',
   PRIMARY KEY (`value_id`),
   KEY `` (`type_id`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

SELECT
    c.date,

    o1.value_id AS "o1.value_id",
    o2.value_id AS "o2.value_id",
    o3.value_id AS "o3.value_id",

    o1.type_id AS "o1.type_id",
    o2.type_id AS "o1.type_id",
    o3.type_id AS "o1.type_id",

    o1.date AS "o1.date",
    o2.date AS "o2.date",
    o3.date AS "o3.date"

FROM
   tbl_calendar c

   LEFT JOIN tbl_demo_values o1 ON (
           o1.demo_date = f.calendar_date
       AND o1.ship_type_id = 100
   )

   LEFT JOIN tbl_demo_values o2 ON (
           o2.ship_type_id = 100
       AND f.calendar_date > o2.demo_date
   )

   INNER JOIN tbl_demo_values o3 ON (
           o3.ship_type_id = 100
       AND o3.demo_date < o2.demo_date
   )