/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

8 votes199 views1 answer
Php split string along spaces
PHP
3 votes215 views2 answers
Return last inserted id in laravel
PHP Laravel
0 vote232 views1 answer
Quitar html con laravel 5
PHP
0 vote179 views1 answer
0 == "string" php
PHP
-1 vote185 views2 answers
Laravel model save get id
PHP
0 vote222 views1 answer
Laravel create pivot migration
PHP Laravel
2 votes213 views2 answers
Laravel get public path url
PHP Laravel
3 votes245 views2 answers
Php prepared statements
PHP
0 vote202 views1 answer
Migration not found laravel
PHP Laravel
0 vote188 views3 answers
Not Found The requested URL was not found on this server. Apache/2.4.48 (Win64) OpenSSL/1.1.1k PHP/8.0.8 Server at localhost Port 80
PHP