/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

13 votes116 views5 answers
Php destroy session after some time
PHP
0 vote120 views1 answer
Acf if image else display other image
PHP
0 vote171 views1 answer
Wordpress send reset password link inside wp_new_user_notification_email
PHP
13 votes205 views2 answers
Php rename files in directory
PHP
0 vote141 views1 answer
Laravel get previous route without domain
PHP
0 vote105 views1 answer
Trying to access variable outside laravel collection
PHP
0 vote114 views2 answers
Minishlink/web-push v5.2.5 requires ext-gmp *
PHP
0 vote125 views1 answer
How to search by sku woocommerce
PHP
0 vote127 views1 answer
Get_post_meta
PHP
3 votes157 views2 answers
Laravel Migrations from an existing database
PHP Laravel