/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 vote131 views3 answers
Laravel load relationship
PHP Laravel
0 vote115 views1 answer
WordPress oEmbed Funktion abschalten
PHP
1 vote110 views2 answers
Php check if associative array
PHP
1 vote116 views2 answers
Laravel 8 seeding
PHP
3 votes122 views2 answers
Library not loaded: /usr/local/opt/icu4c/lib/libicuio.64.dylib Referenced from: /usr/local/bin/php
PHP
1 vote98 views1 answer
/laravel-2020-07-27.log" could not be opened
PHP
11 votes108 views6 answers
Php object to array
PHP
0 vote99 views1 answer
Merge two objects php laravel
PHP
8 votes136 views5 answers
Laravel route is current route
PHP Laravel
10 votes123 views4 answers
Laravel route pattern
PHP