/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

7 votes318 views2 answers
Laravel ui
PHP
8 votes482 views4 answers
Codeigniter 4 redirect to home
PHP CodeIgniter
1 vote270 views1 answer
Get month in words php
PHP
0 vote320 views1 answer
Woocommerce get post terms product
PHP
44 votes348 views6 answers
Php array size
PHP
2 votes326 views2 answers
Factorial function php
PHP
0 vote317 views1 answer
Class 'Dompdf\Dompdf' not found
PHP
0 vote306 views1 answer
Apache use public folder as root
PHP
2 votes345 views1 answer
Php curl timeout
PHP
1 vote317 views1 answer
DB::connection('local')->create() laravel
PHP Laravel