|
|
SELECT zen_categories.categories_id AS id, zen_categories_description.categories_name AS name, zen_categories.categories_image, ListingPricing.LPrice
FROM zen_categories, zen_categories_description
LEFT JOIN ListingPricing ON zen_categories.categories_id = ListingPricing.CatID
WHERE zen_categories.categories_id = zen_categories_description.categories_id
and zen_categories.parent_id = 0
and zen_categories.categories_id <> 1
ORDER BY zen_categories.sort_order | |