MYSQL ERROR
ERROR :: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(_name like '%ศบค%') OR ) AND _status = 'Enable' AND _lang = 'th' UNION SE' at line 49
Query :: SELECT
_id AS s_id,
_mid AS s_mid,
_mkey AS s_mkey,
_subject AS s_subject,
_desc AS s_desc,
_count AS s_count,
_dtmins AS s_dtmins,
null AS s_typenews,
null AS s_link,
null AS s_name,
_tag AS s_tag
FROM cms WHERE 1=1 AND _mid IN(81,80,79,78,77,76,75,83,84,92,91,116,122,115,120,113,119,112,121,118,58,48,47,46,38,146,164,165,163,31,16,1,21,22,87,54,41,40,200,39,43,100,36,44,167,184,35,161,171,180,183,196,34,131,145,170,182,198,88,127,130,168,176,186,97,129,169,55,98,133,175,52,99,162,190,45,90,96,159,189,49,51,95,188,192,50,94,179,191,154,166,197,109,132,153,194,93,147,187,193,195,73,144,143,178,37,142,128,141,33,210,209,208,207,206,205,204,203,202,201,211) AND (_subject = 'คำสั่ง ศบค' OR _desc = 'คำสั่ง ศบค' OR _tag = 'คำสั่ง ศบค') AND _status = 'Enable' AND _lang = 'th' UNION SELECT
_id AS s_id,
_mid AS s_mid,
_mkey AS s_mkey,
_subject AS s_subject,
_desc AS s_desc,
_count AS s_count,
_dtmins AS s_dtmins,
null AS s_typenews,
null AS s_link,
null AS s_name,
_tag AS s_tag
FROM media WHERE 1=1 AND _mid IN(81,80,79,78,77,76,75,83,84,92,91,116,122,115,120,113,119,112,121,118,58,48,47,46,38,146,164,165,163,31,16,1,21,22,87,54,41,40,200,39,43,100,36,44,167,184,35,161,171,180,183,196,34,131,145,170,182,198,88,127,130,168,176,186,97,129,169,55,98,133,175,52,99,162,190,45,90,96,159,189,49,51,95,188,192,50,94,179,191,154,166,197,109,132,153,194,93,147,187,193,195,73,144,143,178,37,142,128,141,33,210,209,208,207,206,205,204,203,202,201,211) AND (_subject = 'คำสั่ง ศบค' OR _desc = 'คำสั่ง ศบค' OR _tag = 'คำสั่ง ศบค') AND _status = 'Enable' AND _lang = 'th' UNION SELECT
_id AS s_id,
_mid AS s_mid,
_mkey AS s_mkey,
_subject AS s_subject,
_desc AS s_desc,
_count AS s_count,
_dtmins AS s_dtmins,
null AS s_typenews,
null AS s_link,
null AS s_name,
null AS s_tag
FROM rss WHERE 1=1 AND _mid IN(81,80,79,78,77,76,75,83,84,92,91,116,122,115,120,113,119,112,121,118,58,48,47,46,38,146,164,165,163,31,16,1,21,22,87,54,41,40,200,39,43,100,36,44,167,184,35,161,171,180,183,196,34,131,145,170,182,198,88,127,130,168,176,186,97,129,169,55,98,133,175,52,99,162,190,45,90,96,159,189,49,51,95,188,192,50,94,179,191,154,166,197,109,132,153,194,93,147,187,193,195,73,144,143,178,37,142,128,141,33,210,209,208,207,206,205,204,203,202,201,211) AND (_subject = 'คำสั่ง ศบค' OR _desc = 'คำสั่ง ศบค') AND _status = 'Enable' AND _lang = 'th' UNION SELECT
_id AS s_id,
_mid AS s_mid,
_mkey AS s_mkey,
_name AS s_subject,
_desc AS s_desc,
_count AS s_count,
_dtmins AS s_dtmins,
null AS s_typenews,
null AS s_link,
_name AS s_name,
null As s_tag
FROM document WHERE 1=1 AND _mid IN(81,80,79,78,77,76,75,83,84,92,91,116,122,115,120,113,119,112,121,118,58,48,47,46,38,146,164,165,163,31,16,1,21,22,87,54,41,40,200,39,43,100,36,44,167,184,35,161,171,180,183,196,34,131,145,170,182,198,88,127,130,168,176,186,97,129,169,55,98,133,175,52,99,162,190,45,90,96,159,189,49,51,95,188,192,50,94,179,191,154,166,197,109,132,153,194,93,147,187,193,195,73,144,143,178,37,142,128,141,33,210,209,208,207,206,205,204,203,202,201,211) AND _did = 0 AND ( (_name like '%คำสั่ง%') (_name like '%ศบค%') OR ) AND _status = 'Enable' AND _lang = 'th' UNION SELECT
page._id AS s_id,
page._mid AS s_mid,
page._mkey AS s_mkey,
sys_menu._name_th AS s_subject,
null AS s_desc,
page._count_th AS s_count,
page._dtmins AS s_dtmins,
null AS s_typenews,
sys_menu._urlname AS s_link,
null AS s_name,
page._tag_th AS s_tag
FROM page INNER JOIN sys_menu ON sys_menu._id = page._mid WHERE 1=1 AND page._mid IN(81,80,79,78,77,76,75,83,84,92,91,116,122,115,120,113,119,112,121,118,58,48,47,46,38,146,164,165,163,31,16,1,21,22,87,54,41,40,200,39,43,100,36,44,167,184,35,161,171,180,183,196,34,131,145,170,182,198,88,127,130,168,176,186,97,129,169,55,98,133,175,52,99,162,190,45,90,96,159,189,49,51,95,188,192,50,94,179,191,154,166,197,109,132,153,194,93,147,187,193,195,73,144,143,178,37,142,128,141,33,210,209,208,207,206,205,204,203,202,201,211) AND (sys_menu._name_th = 'คำสั่ง ศบค' OR sys_menu._desc_th = 'คำสั่ง ศบค' OR page._tag_th = 'คำสั่ง ศบค') AND sys_menu._status = 'Enable' UNION SELECT
_id AS s_id,
_mid AS s_mid,
_mkey AS s_mkey,
_subject AS s_subject,
_desc AS s_desc,
_count AS s_count,
_dtmins AS s_dtmins,
null AS s_typenews,
null AS s_link,
null AS s_name,
_tag As s_tag
FROM album WHERE 1=1 AND _mid IN(81,80,79,78,77,76,75,83,84,92,91,116,122,115,120,113,119,112,121,118,58,48,47,46,38,146,164,165,163,31,16,1,21,22,87,54,41,40,200,39,43,100,36,44,167,184,35,161,171,180,183,196,34,131,145,170,182,198,88,127,130,168,176,186,97,129,169,55,98,133,175,52,99,162,190,45,90,96,159,189,49,51,95,188,192,50,94,179,191,154,166,197,109,132,153,194,93,147,187,193,195,73,144,143,178,37,142,128,141,33,210,209,208,207,206,205,204,203,202,201,211) AND (_subject = 'คำสั่ง ศบค' OR _desc = 'คำสั่ง ศบค' OR _tag = 'คำสั่ง ศบค') AND _status = 'Enable' AND _lang = 'th'ORDER BY s_dtmins DESC