/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 vote187 views1 answer
Mysql gone away error in php
PHP
0 vote209 views1 answer
Symfony set content type
PHP Symfony
11 votes192 views5 answers
Resource route laravel
PHP Laravel
2 votes148 views1 answer
Laravel check if session variable exists
PHP
0 vote171 views1 answer
Dhl api integration in php - create a shipment
PHP
0 vote170 views1 answer
Header remove php
PHP
3 votes183 views1 answer
Wordpress get domain
PHP
4 votes166 views1 answer
Laravel before migration
PHP
1 vote197 views1 answer
How validate if one parameter is exist another parameter must exist in laravel
PHP Laravel
0 vote233 views1 answer
Get current post categody id wp
PHP Wordpress