A Database Error Occurred
Error Number: 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tradexl_sitev1jan15.product_tbl.p_user_Id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT `product_tbl`.`p_user_Id`, `product_by_user`.`product_By_User_Name`, `product_by_user`.`product_By_User_url` FROM `product_tbl` JOIN `product_by_user` ON `product_by_user`.`product_By_User_Id`=`product_tbl`.`p_user_Id` JOIN `user_registration` ON `user_registration`.`user_Id`=`product_by_user`.`user_Id` JOIN `city` ON `city`.`city_id`=`user_registration`.`user_City` JOIN `product_meta` ON `product_meta`.`prod_url`=`product_by_user`.`product_By_User_url` WHERE `product_tbl`.`p_cat_Id` = '22' AND `product_tbl`.`p_subcat_Id` = '41' AND `product_by_user`.`status_Flag` = 'Accepted' AND `user_registration`.`live_status` = 1 AND `product_meta`.`status` = 1 GROUP BY `product_by_user`.`product_By_User_url` LIMIT 5
Filename: models/Common_model.php
Line Number: 131