/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
Wp_query limit 1
PHP
1 vote141 views2 answers
Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes) in phar://D:/Program Files/Composer - PHP/composer.phar/src/Composer/DependencyResolver/Solver.php on line 223
PHP
5 votes161 views4 answers
App url laravel
PHP Laravel
4 votes125 views2 answers
Simple localhost php
PHP
0 vote160 views1 answer
12 months service expiary in php
PHP
2 votes92 views1 answer
Htmlspecialchars() expects parameter
PHP
1 vote121 views1 answer
Find substring regx php
PHP
0 vote126 views1 answer
Sql update views +1
PHP
0 vote125 views3 answers
Count with left join in laravel
PHP
0 vote123 views1 answer
Create email template php
PHP