/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 vote177 views1 answer
Laravel one session per user
PHP Laravel
0 vote127 views1 answer
Write a Multiplication program of two numbers in php using operator
PHP
0 vote149 views1 answer
Laravel move file from local to s3
PHP
4 votes147 views4 answers
Php get data from api
PHP
0 vote177 views1 answer
Ttl jwt
PHP
12 votes129 views4 answers
Php timestamp to seconds
PHP
0 vote202 views1 answer
What is errore Personal access client not found. Please create one in laravel
PHP Laravel
1 vote231 views1 answer
How to use old for select in blade laravel
PHP Laravel
0 vote144 views1 answer
Php foreach alternative syntax
PHP
0 vote153 views1 answer
How to pass value in app.blade
PHP