嗨,
谢谢。
该消息呢?
当我尝试显示DJCLASIFIED项目时。
选择a。 username
FROM `#__djcf_items` AS a
LEFT JOIN #__djcf_categories AS c ON a.cat_id = c.id
LEFT JOIN #__users u ON u.id = a.user_id
WHERE a.published=1 AND (a.date_exp= '0000-00-00 00:00:00' OR a.date_exp>= '2017-05-21 14:53:43')