/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

22 votes156 views4 answers
Php secure password hash
PHP
31 votes162 views1 answer
Php nombre de caractère
PHP
0 vote167 views1 answer
Call to a member function move() on string
PHP
3 votes156 views3 answers
$this- db- where in codeigniter
PHP
1 vote197 views2 answers
Randon file name php
PHP
3 votes154 views1 answer
Laravel find by
PHP
0 vote188 views1 answer
Undefined function bcmul php linux
PHP
2 votes204 views3 answers
Format date laravel timestamp view
PHP
0 vote277 views1 answer
Yii form custom label
PHP Yii
0 vote196 views1 answer
Laravel check model column was changed
PHP