/PHP/Join with 2 table where id match in table 1 comma separated

Join with 2 table where id match in table 1 comma separated

<?php 
 SELECT `mgt_products`.`id`,`mgt_products`.`pro_name`,`mgt_products`.`cate_id`,
	`mgt_products`.`subcate_ids`,`mgt_subcategories`.subcat_id FROM `mgt_products` 
	JOIN `mgt_categories` ON `mgt_products`.`cate_id` = `mgt_categories`.`cat_id`
	JOIN `mgt_subcategories` ON find_in_set(mgt_subcategories.subcat_id, mgt_products.`subcate_ids`)
    WHERE `mgt_categories`.`cat_id` = 2
    AND find_in_set(7, mgt_products.`subcate_ids`)
    GROUP BY `mgt_products`.`id`
      
?>

Similar codes

0 vote131 views1 answer
Laravel routes return view in web.php
PHP
17 votes163 views3 answers
Wordpress max memory limit
PHP Wordpress
0 vote156 views1 answer
Laravel-medialibrary packagist
PHP Laravel
1 vote168 views1 answer
Laravel validation required_if one parameter exist
PHP Laravel
3 votes158 views3 answers
Sum row data and get all data eloquent laravel
PHP Laravel
1 vote170 views2 answers
Laravel throttle
PHP Laravel
1 vote140 views1 answer
Php absolute value
PHP
1 vote166 views1 answer
Laravel realation with has
PHP
2 votes151 views4 answers
In date function + 1 month and - 1 day in php
PHP
1 vote163 views1 answer
Php get next saturday
PHP