/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 vote259 views1 answer
Php date modify plus 1 day
PHP
6 votes248 views1 answer
Insall laravel
PHP Laravel
7 votes225 views3 answers
Array_intersect php
PHP
15 votes229 views3 answers
Laravel timezone
PHP
2 votes247 views1 answer
Magento 2 -Limit the length of the product name on the front end.
PHP
4 votes262 views1 answer
Laravel validation numeric vs integer
PHP Laravel
2 votes218 views1 answer
15000 tl to usd
PHP
0 vote286 views1 answer
Artisan laravel require bootstrap
PHP Laravel
0 vote219 views1 answer
Month php written out
PHP
4 votes234 views1 answer
Please provide a valid cache path.
PHP