/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

3 votes134 views2 answers
Smarty assign var
PHP
3 votes144 views1 answer
Insert rows in migrations laravel
PHP
0 vote123 views1 answer
Laravel create new file if not exists
PHP
2 votes178 views1 answer
Set session after login with laravel
PHP Laravel
0 vote117 views1 answer
How to delete a row in phpmyadmin
PHP
0 vote184 views1 answer
Updating a row from databse using php
PHP
4 votes167 views5 answers
Laravel with and where
PHP Laravel
48 votes252 views6 answers
Laravel joins
PHP Laravel
-1 vote146 views1 answer
Create new record via model in laravel
PHP
4 votes276 views2 answers
Redirect back in codeigniter
PHP CodeIgniter