/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

5 votes284 views3 answers
Crrate model in laravel
PHP
4 votes289 views2 answers
Php move file
PHP
0 vote269 views1 answer
Put the date from new york with php
PHP
-1 vote278 views1 answer
Laravel migration table bigint
PHP
53 votes311 views6 answers
Laravel join
PHP
10 votes336 views4 answers
Compact laravel
PHP Laravel
14 votes291 views4 answers
Laravel set timezone dynamically
PHP
7 votes287 views1 answer
Php set no memory limit
PHP
0 vote339 views1 answer
Edit items in Laravel collection
PHP Laravel
0 vote317 views1 answer
Laravel new project command doesn't create vendor
PHP Laravel