/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 vote292 views1 answer
Php isset post
PHP
0 vote330 views1 answer
Add custom attribute for validation errors laravel
PHP Laravel
0 vote317 views1 answer
Multiplication des variables sur laravel
PHP Laravel
6 votes284 views5 answers
Setcookie php
PHP
0 vote331 views1 answer
Laravel passport generate key
PHP Laravel
0 vote287 views1 answer
Php date is before
PHP
7 votes350 views5 answers
Wordpress get post by id
PHP Wordpress
1 vote284 views2 answers
How to display data from mysql database into html table using php
PHP
4 votes299 views2 answers
Datetime blade laravel
PHP Laravel
1 vote313 views1 answer
Laravel nigerian time zone
PHP Laravel