$result = dbquery("SELECT news_cat_id, news_cat_name, news_cat_parent, news_cat_image, news_cat_visibility FROM ".DB_NEWS_CATS." ".(multilang_table("NS") ? "WHERE ".in_group('news_cat_language', LANGUAGE)." AND " : "WHERE ")." news_cat_draft=0 ORDER BY news_cat_sticky DESC, news_cat_id ASC");

 $result = dbquery( "SELECT news_cat_id, news_cat_name, news_cat_parent, news_cat_image, news_cat_visibility

 FROM " . DB_NEWS_CATS . "

 WHERE " . ( multilang_table( "NS" ) ? in_group( 'news_cat_language', LANGUAGE )."AND " : "" ) . "

 news_cat_draft = 0 AND " . groupaccess( "news_cat_visibility" ) . "

 ORDER BY news_cat_sticky DESC, news_cat_id ASC

 " );

 $result = dbquery("SELECT

 ns.news_id AS id,

 ns.news_subject AS title,

 ns.news_news AS content,

 ns.news_reads AS views_count,

 ns.news_datestamp AS datestamp,

 nc.news_cat_id AS cat_id,

 nc.news_cat_name AS cat_name,

 ni.news_image AS image_main,

 ni.news_image_t1 AS image_thumb,

 ni.news_image_t2 AS image_thumb2,

 nc.news_cat_image AS cat_image,

 ".(!empty($comments_query) ? $comments_query : '')."

 ".(!empty($ratings_query) ? $ratings_query : '')."

 u.user_id, u.user_name, u.user_status

 FROM ".DB_NEWS." AS ns

 LEFT JOIN ".DB_NEWS_IMAGES." AS ni > ns.news_start OR ns.news_start = 0)

 AND ns.news_draft = 0

 AND (".time()." < ns.news_end OR ns.news_end = 0)

 AND ".groupaccess('ns.news_visibility')." AND ".groupaccess("nc.news_cat_visibility")." ".(multilang_table("NS") ? "AND ".in_group('news_language', LANGUAGE) : "")."

 GROUP BY ns.news_id

 ORDER BY ns.news_datestamp DESC LIMIT ".$limit

 );

 $result = dbquery("SELECT

 ns.news_id AS id,

 ns.news_subject AS title,

 ns.news_news AS content,

 ns.news_reads AS views_count,

 ns.news_datestamp AS datestamp,

 nc.news_cat_id AS cat_id,

 nc.news_cat_name AS cat_name,

 ni.news_image AS image_main,

 ni.news_image_t1 AS image_thumb,

 ni.news_image_t2 AS image_thumb2,

 nc.news_cat_image AS cat_image,

 ".(!empty($comments_query) ? $comments_query : '')."

 ".(!empty($ratings_query) ? $ratings_query : '')."

 u.user_id, u.user_name, u.user_status

 FROM ".DB_NEWS." AS ns

 LEFT JOIN ".DB_NEWS_IMAGES." AS ni ON ni.news_id=ns.news_id

 LEFT JOIN ".DB_NEWS_CATS." AS nc ON nc.news_cat_id = ns.news_cat

 LEFT JOIN ".DB_USERS." AS u ON ns.news_name = u.user_id

 WHERE (".time()." > ns.news_start OR ns.news_start = 0)

 AND ns.news_draft = 0

 AND (".time()." < ns.news_end OR ns.news_end = 0)

 AND ".groupaccess('ns.news_visibility')." ".(multilang_table("NS") ? "AND ".in_group('news_language', LANGUAGE) : "")."

 GROUP BY ns.news_id

 ORDER BY ns.news_datestamp DESC LIMIT ".$limit

 );

 protected static function getNewsQuery(array $filters = []) {

 $news_settings = self::getNewsSettings();

 $cat_filter = self::checkNewsFilter();

 $pattern = "SELECT %s(nr.rating_vote) FROM ".DB_RATINGS." AS nr WHERE nr.rating_item_id = n.news_id AND nr.rating_type = 'N'";

 $sql_count = sprintf($pattern, 'COUNT');

 $sql_sum = sprintf($pattern, 'SUM');

 return "SELECT n.*, nc.*, nu.user_id, nu.user_name, nu.user_status, nu.user_avatar , nu.user_level, nu.user_joined,

 ($sql_sum) AS news_sum_rating,

 ($sql_count) AS news_count_votes,

 (SELECT COUNT(ncc.comment_id) FROM ".DB_COMMENTS." AS ncc WHERE ncc.comment_item_id = n.news_id AND ncc.comment_type = 'N') AS comments_count,

 ni.news_image, ni.news_image_t1, ni.news_image_t2

 FROM ".DB_NEWS." AS n

 LEFT JOIN ".DB_NEWS_IMAGES." AS ni >='".time()."') AND news_draft='0'

 ".(!empty($filters['condition']) ? "AND ".$filters['condition'] : '')."

 GROUP BY ".(!empty($filters['group_by']) ? $filters['group_by'] : 'news_id')."

 ORDER BY ".(!empty($filters['order']) ? $filters['order'].',' : '')." news_sticky DESC, ".$cat_filter['order']."

 LIMIT ".(!empty($filters['limit']) ? $filters['limit'] : $_GET['rowstart'].",".(!empty($news_settings['news_pagination']) ? $news_settings['news_pagination'] : 12)

 );

 }

 protected static function getNewsQuery(array $filters = []) {

 $news_settings = self::getNewsSettings();

 $cat_filter = self::checkNewsFilter();

 $pattern = "SELECT %s(nr.rating_vote) FROM ".DB_RATINGS." AS nr WHERE nr.rating_item_id = n.news_id AND nr.rating_type = 'N'";

 $sql_count = sprintf($pattern, 'COUNT');

 $sql_sum = sprintf($pattern, 'SUM');

 return "SELECT n.*, nc.*, nu.user_id, nu.user_name, nu.user_status, nu.user_avatar , nu.user_level, nu.user_joined,

 ($sql_sum) AS news_sum_rating,

 ($sql_count) AS news_count_votes,

 (SELECT COUNT(ncc.comment_id) FROM ".DB_COMMENTS." AS ncc WHERE ncc.comment_item_id = n.news_id AND ncc.comment_type = 'N') AS comments_count,

 ni.news_image, ni.news_image_t1, ni.news_image_t2

 FROM ".DB_NEWS." AS n

 LEFT JOIN ".DB_NEWS_IMAGES." AS ni ON ni.news_id=n.news_id AND ".(!empty($_GET['readmore']) ? "n.news_image_full_default=ni.news_image_id" : "n.news_image_front_default=ni.news_image_id")."

 LEFT JOIN ".DB_USERS." AS nu ON n.news_name=nu.user_id

 LEFT JOIN ".DB_NEWS_CATS." AS nc ON n.news_cat=nc.news_cat_id

 ".(multilang_table("NS") ? "WHERE ".in_group('news_language', LANGUAGE)." AND " : "WHERE ").groupaccess('news_visibility')." AND ".groupaccess("nc.news_cat_visibility")." AND (news_start='0'||news_start<='".time()."')

 AND (news_end='0'||news_end>='".time()."') AND news_draft='0'

 ".(!empty($filters['condition']) ? "AND ".$filters['condition'] : '')."

 GROUP BY ".(!empty($filters['group_by']) ? $filters['group_by'] : 'news_id')."

 ORDER BY ".(!empty($filters['order']) ? $filters['order'].',' : '')." news_sticky DESC, ".$cat_filter['order']."

 LIMIT ".(!empty($filters['limit']) ? $filters['limit'] : $_GET['rowstart'].",".(!empty($news_settings['news_pagination']) ? $news_settings['news_pagination'] : 12)

 );

 }