/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 vote212 views1 answer
Import facade laravel
PHP Laravel
0 vote171 views1 answer
Show phpinfo just modules
PHP
2 votes162 views1 answer
Merubah judul menjadi slug codeigniter
PHP
0 vote218 views1 answer
Orderby total sales woocommerce
PHP
1 vote193 views2 answers
Decode jwt token laravel
PHP Laravel
15 votes205 views6 answers
Wordpress shortcode
PHP
0 vote323 views1 answer
Jpeg nach und nach laden
PHP
1 vote206 views1 answer
Messed up pagination laravel
PHP Laravel
0 vote185 views1 answer
Get_categories not__in
PHP
0 vote198 views1 answer
Create command laravel sample parameter
PHP Laravel