/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 vote181 views1 answer
Where () mayor que laravel Eloquent
PHP
3 votes218 views2 answers
Laravel 8 Target class [FormController] does not exist.
PHP
42 votes258 views5 answers
Create controller laravel with model
PHP
3 votes251 views2 answers
Laravel longblob migration
PHP Laravel
0 vote207 views1 answer
Parameter to laravel seeder
PHP
10 votes245 views2 answers
Laravel collection toArray
PHP Laravel
0 vote219 views1 answer
Filter array in php with passing extra params
PHP
3 votes215 views2 answers
Spaceship operator
PHP
0 vote212 views1 answer
Get text field value in php
PHP
0 vote183 views1 answer
Php howto ignore file with BOM
PHP