Database Error; SQL: SELECT
DISTINCT
`t`.*
FROM `trw_posts` AS `t`
LEFT JOIN `trw_term_relationships` AS `rel_category` ON
`rel_category`.`object_id` = `t`.`ID`
LEFT JOIN `trw_term_taxonomy` AS `rel_tt_category` ON
`rel_tt_category`.`taxonomy` = 'category'
AND `rel_tt_category`.`term_taxonomy_id` = `rel_category`.`term_taxonomy_id`
LEFT JOIN `trw_terms` AS `category` ON
`category`.`term_id` = `rel_tt_category`.`term_id`
LEFT JOIN `trw_postmeta` AS `date1` ON
`date1`.`meta_key` = 'date1'
AND `date1`.`post_id` = `t`.`ID`
LEFT JOIN `trw_postmeta` AS `date2` ON
`date2`.`meta_key` = 'date2'
AND `date2`.`post_id` = `t`.`ID`
LEFT JOIN `trw_postmeta` AS `date3` ON
`date3`.`meta_key` = 'date3'
AND `date3`.`post_id` = `t`.`ID`
LEFT JOIN `trw_postmeta` AS `date4` ON
`date4`.`meta_key` = 'date4'
AND `date4`.`post_id` = `t`.`ID`
LEFT JOIN `trw_postmeta` AS `date5` ON
`date5`.`meta_key` = 'date5'
AND `date5`.`post_id` = `t`.`ID`
LEFT JOIN `trw_postmeta` AS `date6` ON
`date6`.`meta_key` = 'date6'
AND `date6`.`post_id` = `t`.`ID`
LEFT JOIN `trw_postmeta` AS `date7` ON
`date7`.`meta_key` = 'date7'
AND `date7`.`post_id` = `t`.`ID`
LEFT JOIN `trw_postmeta` AS `date8` ON
`date8`.`meta_key` = 'date8'
AND `date8`.`post_id` = `t`.`ID`
LEFT JOIN `trw_postmeta` AS `date9` ON
`date9`.`meta_key` = 'date9'
AND `date9`.`post_id` = `t`.`ID`
LEFT JOIN `trw_postmeta` AS `date10` ON
`date10`.`meta_key` = 'date10'
AND `date10`.`post_id` = `t`.`ID`
WHERE ( ( `category`.`name` = "Employment" AND (`date1`.`meta_value` > DATE_SUB(NOW(), INTERVAL 22 HOUR) OR `date2`.`meta_value` > DATE_SUB(NOW(), INTERVAL 22 HOUR) OR `date3`.`meta_value` > DATE_SUB(NOW(), INTERVAL 22 HOUR) OR `date4`.`meta_value` > DATE_SUB(NOW(), INTERVAL 22 HOUR) OR `date5`.`meta_value` > DATE_SUB(NOW(), INTERVAL 22 HOUR) OR `date6`.`meta_value` > DATE_SUB(NOW(), INTERVAL 22 HOUR) OR `date7`.`meta_value` > DATE_SUB(NOW(), INTERVAL 22 HOUR) OR `date8`.`meta_value` > DATE_SUB(NOW(), INTERVAL 22 HOUR) OR `date9`.`meta_value` > DATE_SUB(NOW(), INTERVAL 22 HOUR) OR `date10`.`meta_value` > DATE_SUB(NOW(), INTERVAL 22 HOUR)) ) AND ( `t`.`post_type` = 'workshops_and_class' ) AND ( `t`.`post_status` IN ( 'publish' ) ) )
ORDER BY date1 ASC, `t`.`menu_order`, `t`.`post_title`, `t`.`post_date`; Response: Unknown column 'date1' in 'order clause'
