/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

2 votes149 views3 answers
Php setinterval
PHP
0 vote128 views1 answer
Echo string in php
PHP
0 vote186 views5 answers
Run schedule laravel
PHP Laravel
2 votes188 views2 answers
Assert file exists laravel
PHP
0 vote240 views3 answers
Best wordpress functions to include
PHP
0 vote136 views6 answers
Array value auto fill in old value laravel 8
PHP
1 vote133 views1 answer
Laravel eloquent where id not equal to
PHP
0 vote138 views1 answer
Repalce 0 in phone with 234
PHP
9 votes138 views4 answers
Laravel merge collections
PHP
12 votes167 views1 answer
Laravel model without timestamps
PHP Laravel