Alliance Holistic Care Center

SQL Error:

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 ') AND av_tp IN ( 3 )' at line 1

SELECT COUNT(1) AS RecCT
FROM article_video INNER JOIN article_video_desc ON av_id = avd_av_id AND av_lang = avd_lang
WHERE av_lang = 'en' AND av_show = 'Y' AND avd_ava_id IN ( ) AND av_tp IN ( 3 )

SQL Error:

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 ') AND av_tp IN ( 3 ) ORDER BY av_sort_id , av_crt_dt DESC , avd_sort_id , avd_' at line 1

SELECT *
FROM article_video INNER JOIN article_video_desc ON av_id = avd_av_id AND av_lang = avd_lang
LEFT JOIN article_video_topic ON avd_avt_id = avt_id AND avd_lang = avt_lang
LEFT OUTER JOIN article_video_author ON ava_id = avd_ava_id AND ava_lang = avd_lang
WHERE av_lang = 'en' AND av_show = 'Y' AND avd_ava_id IN ( ) AND av_tp IN ( 3 )
ORDER BY av_sort_id , av_crt_dt DESC , avd_sort_id , avd_crt_dt DESC
LIMIT 0 , 5