/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 vote241 views1 answer
Text or description laravel database column type
PHP
0 vote187 views1 answer
Php header location to same page
PHP
0 vote208 views1 answer
Logout all users laravel 8
PHP
0 vote173 views1 answer
Flexslider in laravel 5.8
PHP
-2 votes183 views1 answer
Get all the between dates from start and end date carbon
PHP
1 vote186 views4 answers
In_array validation laravel
PHP
3 votes192 views3 answers
Pregmatch
PHP
0 vote188 views1 answer
Map associative array php0
PHP
4 votes186 views3 answers
Laravel cmd command to watch logs
PHP
0 vote216 views1 answer
Laravel select only one word from string
PHP Laravel