share
A Database Error Occurred
Error Number: 1055
Expression #18 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yji2021.jpc.slug' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT `p`.*, `au`.`name` as `created_by`, `jpc`.`slug`, `jpc`.`post_category` FROM `jt_post_highlight` `pc` LEFT JOIN `jt_post` `p` ON `pc`.`post_id` = `p`.`id` LEFT JOIN `auth_user` `au` ON `p`.`created_by` = `au`.`id` LEFT JOIN `jt_post_cat_detail` `jpcd` ON `pc`.`post_id` = `jpcd`.`post_id` LEFT JOIN `jt_post_category` `jpc` ON `jpcd`.`post_category_id` = `jpc`.`id` WHERE `pc`.`post_category_id` IN('7') AND `p`.`status` = 'PUBLISH' AND `p`.`lang_id` = '1' GROUP BY `pc`.`post_id` ORDER BY `p`.`post_date` DESC, `p`.`created_on` DESC LIMIT 1
Filename: modules/jt_core/models/Jt_model.php
Line Number: 747