Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement