/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

17 votes118 views6 answers
Update query laravel
PHP Laravel
0 vote114 views1 answer
Laravel withcount change name
PHP Laravel
1 vote98 views1 answer
Php explode trim
PHP
2 votes135 views2 answers
Import big sql file phpmyadmin
PHP
0 vote108 views1 answer
Php check if string email
PHP
0 vote100 views1 answer
Ussd php
PHP
0 vote125 views1 answer
How to display image from aws s3 in laravel blade
PHP Laravel
0 vote103 views2 answers
The media must not be greater than 12288 kilobytes in laravel
PHP
0 vote102 views1 answer
Make() laravel
PHP
0 vote121 views1 answer
Laravel post request search query
PHP Laravel