SELECT *
FROM `LISTING`
LEFT JOIN `CATEGORY` ON `CATEGORY`.`CAT_SN` = `LISTING`.`LISTING_CAT`
LEFT JOIN `REGISTER` ON `REGISTER`.`R_SN` = `LISTING`.`LISTING_USER`
WHERE `LISTING_RSTATUS` = 'Y'
AND `R_RSTATUS` = 'Y'
AND `LISTING_CAT` = 5
ORDER BY `LISTING_SN` DESCSELECT *
FROM `LISTING`
LEFT JOIN `CATEGORY` ON `CATEGORY`.`CAT_SN` = `LISTING`.`LISTING_CAT`
LEFT JOIN `REGISTER` ON `REGISTER`.`R_SN` = `LISTING`.`LISTING_USER`
WHERE `LISTING_RSTATUS` = 'Y'
AND `R_RSTATUS` = 'Y'
AND `LISTING_CAT` = 5
ORDER BY `LISTING_SN` DESC
LIMIT 10
Search Result
