/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 vote200 views2 answers
Mixed content: the page at was loaded over https, but requested an insecure xmlhttprequest endpoint
PHP
0 vote191 views1 answer
Wordpress get the main url
PHP
0 vote190 views1 answer
Throws php
PHP
0 vote197 views4 answers
Php check if any of multiple values in array
PHP
0 vote190 views1 answer
Curl upload image huawei
PHP
0 vote325 views1 answer
Schema key issue laravel
PHP Laravel
0 vote229 views1 answer
Form submitting is not working in php
PHP
0 vote176 views1 answer
Php get variable by string name
PHP
0 vote311 views1 answer
Adding an Item to The Cart codeigniter
PHP CodeIgniter
24 votes183 views4 answers
Laravel query not null
PHP