/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

5 votes231 views3 answers
Laravel get view variables
PHP Laravel
0 vote238 views1 answer
Turn off wordpress user list exposed
PHP Wordpress
72 votes201 views6 answers
Php typecast to int
PHP
2 votes218 views1 answer
Laravel where update query
PHP Laravel
1 vote207 views1 answer
Php multi condition if
PHP
58 votes217 views6 answers
In_array php
PHP
6 votes249 views3 answers
Laravel blade route redirect back
PHP
0 vote204 views1 answer
LDownload multiple files as a zip-file using php
PHP
0 vote264 views1 answer
Wordpress get page number
PHP Wordpress
1 vote212 views4 answers
Hide error in php
PHP