SELECT a.*,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email FROM `#__weblinks` AS a LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__users AS uam ON uam.id = a.modified_by WHERE a.access IN (1,1,5) AND a.catid = 851 AND c.access IN (1,1,5) AND a.state = 1 AND a.state != -2 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-08 16:36:46') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-08 16:36:46') ORDER BY ordering ASC