SELECT (UNIX_TIMESTAMP(begin) - UNIX_TIMESTAMP("2013-11-22 05:50:12")) AS timediff_begin, ( UNIX_TIMESTAMP("2013-11-22 09:50:12") - UNIX_TIMESTAMP(end) ) AS timediff_end