SQLESTATE CODE:42000
Error Code:1064
Error Msg:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') h on h.lid=lf.hindi_id where lf.status='Active' and lt.status='Active' and l' at line 5
select lt.link_name,lt.link_bdesc,lt.details ,lt.title,date_format(lf.publish_date,'%d %M %Y') as publish_date, lf.hindi_id as lid,case when lt.type_id!=3 then '' else '' end as l_target , lt.lang_id,ls.position,case when ls.pos_id=3 then 33 else pos_id end as pos, case when lt.type_id!=3 then 'target="_blank"' else '' end as l_target,case when ls.link_level is null then '0' else ls.link_level end as link_level,case when lt.type_id=1 then 'showfile.php' when lt.type_id=2 then 'showlink.php' else '' end as lfile,lf.lid,ls.ls_id,ls.parent_ls_id,lt.file_name,ls.status,case when lt.type_id=1 then SUBSTRING_INDEX(lt.file_name,'.',-1) when lt.type_id=2 then 'url' else '' end as fext from web_links_final lf INNER JOIN web_link_temp lt on lt.link_temp_id=lf.link_temp_id INNER JOIN web_links_structure ls on ls.lid=lf.lid LEFT JOIN (select t1.link_name,t1.link_bdesc,t1.details,t1.title,t1.type_id,f1.publish_date,f1.expiry_date, f1.lid from web_links_final f1 INNER JOIN web_link_temp t1 on t1.link_temp_id=f1.link_temp_id and t1.lang_id= ) h on h.lid=lf.hindi_id where lf.status='Active' and lt.status='Active' and ls.status='Active' and ls.link_level is null and (ISNULL(lf.expiry_date) || lf.expiry_date>current_date()) and lt.lang_id=1 order by pos,positionFailed: SQLESTATEMENT ERROR