/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

49 votes334 views6 answers
Laravel add column to existing table
PHP Laravel
0 vote255 views2 answers
Laravel migration table softdeletes
PHP Laravel
8 votes288 views1 answer
Laravel store link
PHP Laravel
0 vote303 views1 answer
Install Older Version of Laravel using Composer
PHP Laravel
0 vote302 views1 answer
Laravel collection collapse
PHP Laravel
0 vote262 views1 answer
Laravel disable config cache
PHP
0 vote261 views1 answer
Laravel migrate specific path
PHP Laravel
3 votes264 views2 answers
Custom 404 page in laravel
PHP Laravel
0 vote254 views1 answer
Verta sample jalali laravel problem return object
PHP
1 vote260 views3 answers
Import faker in laravel
PHP