/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 vote302 views1 answer
Laravel storage save file folder on disk
PHP
1 vote293 views1 answer
Laravel route fallback
PHP
11 votes298 views4 answers
Php get file mime type
PHP
0 vote320 views1 answer
Markdown mail html rendering laravel
PHP Laravel
0 vote394 views1 answer
Update query in codeigniter using where condition
PHP CodeIgniter
0 vote403 views1 answer
How to prevent user to add duplicate card in stripe using laravel
PHP
0 vote373 views1 answer
Laravel 8 date difference in days
PHP Laravel
7 votes308 views1 answer
Encode zlib php
PHP
0 vote340 views2 answers
How to get all roles in wordpress
PHP
16 votes374 views5 answers
Laravel one command for model table and controller
PHP Laravel