/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

1 vote376 views1 answer
How to add data to an object in php
PHP
1 vote326 views3 answers
Laravel check if collection has value
PHP
3 votes329 views2 answers
Current timestamp carbon
PHP
0 vote325 views2 answers
Wc php get product category in product page
PHP
0 vote342 views1 answer
Find distance between two coordinate in php
PHP
1 vote343 views10 answers
Stack overflow
PHP
2 votes349 views1 answer
How to return chunk data laravel
PHP Laravel
0 vote331 views1 answer
Php adding options from an array
PHP
0 vote339 views1 answer
Pdo mysqli error handling
PHP
1 vote453 views3 answers
Laravel destroy or delete
PHP Laravel