/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 vote227 views1 answer
Db connection postgres laravel
PHP
16 votes212 views4 answers
Laravel auth helper function
PHP
1 vote181 views4 answers
Laravel assign active based on route name
PHP
0 vote186 views1 answer
Call Python From PHP And Get Return Code
PHP
0 vote140 views1 answer
Woocommerce remove from cart link
PHP
3 votes173 views4 answers
Mac os change the php verison
PHP
1 vote214 views1 answer
Copy env example to .env in laravel
PHP Laravel
0 vote225 views1 answer
Laravel run seeder enter timestamps
PHP Laravel
0 vote178 views1 answer
Case inside laravel query
PHP
14 votes182 views2 answers
Php get file extension from filename
PHP