/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 vote159 views3 answers
Incorrect format parameter phpmyadmin xampp
PHP
12 votes138 views4 answers
Php array remove empty values recursive
PHP
8 votes185 views4 answers
Laravel hash password sample
PHP Laravel
0 vote136 views1 answer
Php multiplication
PHP
1 vote159 views2 answers
Get unique array from multidimentional array by value in php
PHP
5 votes221 views5 answers
Unique laravel migration
PHP Laravel
0 vote161 views1 answer
Using laravel passport with mongodb
PHP Laravel
0 vote175 views5 answers
Date format change in laravel
PHP Laravel
-2 votes218 views2 answers
Why we use pusher in laravel
PHP Laravel
0 vote123 views1 answer
Php integer to js integer
PHP