/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 vote161 views1 answer
Add controller to laravel with requests
PHP
2 votes177 views2 answers
Wordpress functions add to header
PHP Wordpress
0 vote163 views1 answer
Php extract email address from string
PHP
16 votes194 views6 answers
Laravel model events
PHP
7 votes163 views6 answers
Array key value php
PHP
6 votes158 views6 answers
Php array sort
PHP
0 vote123 views1 answer
Display product page title in field cf7
PHP
0 vote155 views1 answer
Laravel factory get foreign key
PHP
7 votes166 views4 answers
Php random 5 digit number
PHP
2 votes178 views1 answer
How to return chunk data laravel
PHP