/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
How to create header in csv file inphp
PHP
0 vote148 views1 answer
Databases supported by php
PHP
2 votes120 views1 answer
Php split string at first space
PHP
0 vote134 views1 answer
Laravel get request check
PHP
12 votes136 views5 answers
First item in array php
PHP
0 vote142 views1 answer
Laravel get all vendor files
PHP Laravel
4 votes135 views3 answers
Session variable
PHP
13 votes113 views3 answers
Laravel password encryption
PHP
0 vote133 views1 answer
Php delete all files in folder
PHP
28 votes119 views3 answers
Remove array values php
PHP