/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

1 vote291 views1 answer
Php insert array into mysql table
PHP
1 vote321 views2 answers
Javascript php loop
PHP
0 vote285 views1 answer
2 days left format in laravel
PHP
0 vote333 views1 answer
Parse data from xml CDATA php
PHP
0 vote296 views1 answer
Php draw line pixel
PHP
6 votes353 views4 answers
Illuminate database queryexception could not find driver laravel
PHP
25 votes307 views5 answers
Php get user ip address
PHP
2 votes290 views1 answer
15000 tl to usd
PHP
0 vote332 views1 answer
Php sort time
PHP
18 votes279 views4 answers
Carbon time laravel
PHP