SELECT
    `q`.*,
    DATE_FORMAT(start_date, '%d.%m.%Y %H:%i:%s') AS `startdate_formated_to_title`,
    DATE_FORMAT(end_date, '%d.%m.%Y %H:%i:%s') AS `enddate_formated_to_title`,
    TIMESTAMPDIFF(DAY, DATE(`start_date`),DATE(NOW())) AS `days_diff`,
    TIMESTAMPDIFF(DAY, DATE(`start_date`),DATE(`f_date`)) AS `flag_diff`,
    `qa`.`qa_id`,
    `qa`.`qa_content`,
    `qa`.`qa_date`,
    `f`.`id` AS `f_id`,
    `f`.`f_date`
FROM `questions_template` AS `q`
LEFT JOIN (
    SELECT
        DISTINCT(`id`) AS `qa_id`,
        `question_id` AS `question_id`,
        `content` AS `qa_content`,
        DATE_FORMAT(date, '%d-%m-%Y') AS `qa_date`
    FROM `questions_template_answers`
    WHERE
        `user_id` = '1'
        AND DATE( `date` ) <= DATE(NOW())
    GROUP BY `question_id`
) AS `qa` ON q.id = qa.question_id
LEFT JOIN (
    SELECT
        DISTINCT(`id`),
        `question_id`,
        `date` AS `f_date`
    FROM `questions_template_flags`
    WHERE `user_id` = '1'
    GROUP BY `question_id`
) AS `f` ON q.id = f.question_id
WHERE
    (q.status ='1')
    AND (
        (
            DATE(q.start_date) = '2010-04-03'
            AND q.special = '0'
        )
        OR (
            q.special = '1'
            AND DATE(q.end_date) >= '2010-04-03'
            AND DATE(q.start_date) <= '2010-04-03'
        )
    )
ORDER BY `q`.`special` ASC