/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 vote266 views1 answer
Display data from two dimensional array in vew laravel
PHP Laravel
0 vote247 views2 answers
Is_wplogin
PHP
0 vote258 views1 answer
Get the current script file name
PHP
1 vote247 views2 answers
Php date to seconds
PHP
5 votes265 views3 answers
Laravel display error message
PHP Laravel
0 vote263 views1 answer
Acf sub_field image title
PHP
40 votes232 views5 answers
Print date in php
PHP
14 votes250 views2 answers
Get type of variable php
PHP
0 vote242 views1 answer
Laravel how to address to git repo for develop packages
PHP
3 votes257 views1 answer
Php foreach string char
PHP