/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

13 votes319 views3 answers
Laravel password encryption
PHP Laravel
0 vote274 views2 answers
Current date time in php for input
PHP
3 votes338 views1 answer
Php curl print status
PHP
0 vote282 views1 answer
Laravel dompdf barcode
PHP
0 vote265 views1 answer
Filter from taggable laravel
PHP
0 vote294 views1 answer
How to get all the records with same ID in laravel
PHP
0 vote323 views2 answers
Upload video in laravel
PHP Laravel
1 vote261 views2 answers
In PackageManifest.php line 122:
PHP
0 vote294 views1 answer
Php how to rename a file before saving it
PHP
0 vote392 views2 answers
How to unhash password_hash in php
PHP