/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 vote364 views1 answer
Laravel query foreach
PHP Laravel
0 vote326 views1 answer
Regenerate session ID and remove all session data
PHP
34 votes372 views6 answers
Laravel create controller with methods
PHP Laravel
3 votes349 views3 answers
How to get last id in database codeigniter 4
PHP
25 votes319 views4 answers
Php get client ip address
PHP
-1 vote320 views1 answer
Addphp calculate next letter
PHP
2 votes347 views2 answers
Laravel validation if data exists
PHP
0 vote348 views1 answer
Union type php does not work
PHP
11 votes389 views2 answers
How login one user with id in laravel
PHP Laravel
1 vote372 views2 answers
Cakephp login session
PHP