| Query Error:Unknown column 'EndDate' in 'where clause' | | SQL:select `tt_45`.Title, `tt_45`.Hits, `tt_45`.CategoryID, `tt_45`.ID, CONCAT('','45') as TypeID from `tt_45` where (`ExpireDate` > NOW()) and (`EndDate` >= CURRENT_DATE) and Posted=1 and PackageID <> 4 union select `tt_50`.Title, `tt_50`.Hits, `tt_50`.CategoryID, `tt_50`.ID, CONCAT('','50') as TypeID from `tt_50` where (`ExpireDate` > NOW()) and (`EndDate` >= CURRENT_DATE) and Posted=1 and PackageID <> 4 union select `tt_44`.Title, `tt_44`.Hits, `tt_44`.CategoryID, `tt_44`.ID, CONCAT('','44') as TypeID from `tt_44` where (`ExpireDate` > NOW()) and (`EndDate` >= CURRENT_DATE) and Posted=1 and PackageID <> 4 union select `tt_46`.Title, `tt_46`.Hits, `tt_46`.CategoryID, `tt_46`.ID, CONCAT('','46') as TypeID from `tt_46` where (`ExpireDate` > NOW()) and (`EndDate` >= CURRENT_DATE) and Posted=1 and PackageID <> 4 union select `tt_42`.Title, `tt_42`.Hits, `tt_42`.CategoryID, `tt_42`.ID, CONCAT('','42') as TypeID from `tt_42` where (`ExpireDate` > NOW()) and (`EndDate` >= CURRENT_DATE) and Posted=1 and PackageID <> 4 union select `tt_48`.Title, `tt_48`.Hits, `tt_48`.CategoryID, `tt_48`.ID, CONCAT('','48') as TypeID from `tt_48` where (`ExpireDate` > NOW()) and (`EndDate` >= CURRENT_DATE) and Posted=1 and PackageID <> 4 union select `tt_43`.Title, `tt_43`.Hits, `tt_43`.CategoryID, `tt_43`.ID, CONCAT('','43') as TypeID from `tt_43` where (`ExpireDate` > NOW()) and (`EndDate` >= CURRENT_DATE) and Posted=1 and PackageID <> 4 union select `tt_49`.Title, `tt_49`.Hits, `tt_49`.CategoryID, `tt_49`.ID, CONCAT('','49') as TypeID from `tt_49` where (`ExpireDate` > NOW()) and (`EndDate` >= CURRENT_DATE) and Posted=1 and PackageID <> 4 union select `tt_47`.Title, `tt_47`.Hits, `tt_47`.CategoryID, `tt_47`.ID, CONCAT('','47') as TypeID from `tt_47` where (`ExpireDate` > NOW()) and (`EndDate` >= CURRENT_DATE) and Posted=1 and PackageID <> 4 order by Hits desc limit 10 |
|
