SELECT *, A.`online_click` sco_click, B.`smCompname_en` smCompname, A.`s_name_en` s_name, A.`s_summary_en` s_summary FROM sco_solution2020 A INNER JOIN match_supplier2025 B ON A.`smId` = B.`smId` WHERE A.`s_pic`<>'' AND A.`is_open` = 'Y' AND A.`s_status` = '2' AND B.smUse='Y' AND B.expire_date>'2025-04-04' AND B.`smId`='' ORDER BY sco_click DESC