/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 vote192 views1 answer
Chart trong laravel
PHP Laravel
1 vote170 views1 answer
Laravel collection toJson
PHP
-1 vote199 views1 answer
Wordpress custom php use wp query
PHP Wordpress
-1 vote162 views2 answers
Map array php
PHP
0 vote169 views2 answers
Bigtext migration laravel
PHP
1 vote205 views1 answer
Use of segment in laravel 8
PHP Laravel
1 vote179 views1 answer
Php include multiple files at once
PHP
11 votes154 views5 answers
Get count laravel
PHP
5 votes173 views3 answers
Get last month using php
PHP
1 vote160 views1 answer
Php check name
PHP