Pure Source Lemon Grass Aroma Oil, 100 ml

SET NAMES 'UTF8' ?>

SELECT `tbl_products`.*, `tbl_user`.`company_name` as `sellername`, `tbl_measurement_unit`.`unit_name` as `measurement_unit_name`, `tbl_product_category`.`name` as `product_category_name`
FROM `tbl_products`
LEFT JOIN `tbl_user` ON `tbl_products`.`seller_id` = `tbl_user`.`id`
LEFT JOIN `tbl_measurement_unit` ON `tbl_products`.`measurement_unit` = `tbl_measurement_unit`.`id`
LEFT JOIN `tbl_product_category` ON `tbl_products`.`product_category_id` = `tbl_product_category`.`id`
WHERE `tbl_products`.`id` = 33054
AND `tbl_products`.`status` = 1
AND `tbl_products`.`catalog_status` = 1 ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = 33054 ?>

INSERT INTO `tbl_products_click` (`product_id`, `indate`, `ip`) VALUES (33054, '2026-09-29 09:28:25', '216.73.216.39') ?>

SELECT `id`, `name`, `parent_id`, `slug`
FROM `tbl_product_category`
WHERE `id` = '697'
AND `status` != 5 ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '697'
AND `status` = 1 ?>

SELECT `tbl_product_attribute`.`attribute_id`, `tbl_product_attribute`.`description`, `tbl_attribute`.`name` as `attributename`, IF(tbl_attribute.priority IS NULL OR tbl_attribute.priority = 0, 100, tbl_attribute.priority) as sort_pri
FROM `tbl_product_attribute`
LEFT JOIN `tbl_attribute` ON `tbl_attribute`.`id` = `tbl_product_attribute`.`attribute_id`
WHERE `tbl_product_attribute`.`product_id` = 33054
AND `tbl_attribute`.`status` = 1
ORDER BY `sort_pri` ?>

SELECT `tbl_spotbuy_catalogue`.*, `tbl_products`.`product_name`, `tbl_products`.`packing_quantity`, `tbl_products`.`mrp`, `tbl_products`.`listing_price`, `tbl_products`.`brand_name`, `tbl_products`.`min_order_quantity`, `tbl_measurement_unit`.`unit_name` as `measurement_unit_name`, `tbl_products`.`slug` as `product_slug`, `tbl_products`.`validity_end_date`
FROM `tbl_spotbuy_catalogue`
LEFT JOIN `tbl_products` ON `tbl_spotbuy_catalogue`.`product_id` = `tbl_products`.`id`
LEFT JOIN `tbl_measurement_unit` ON `tbl_products`.`measurement_unit` = `tbl_measurement_unit`.`id`
WHERE `tbl_spotbuy_catalogue`.`status` = 1
AND `tbl_spotbuy_catalogue`.`product_id` = 33054
 LIMIT 2 ?>

SELECT `tbl_products`.*, `tbl_measurement_unit`.`unit_name` as `measurement_unit_name`
FROM `tbl_products`
LEFT JOIN `tbl_measurement_unit` ON `tbl_products`.`measurement_unit` = `tbl_measurement_unit`.`id`
WHERE `tbl_products`.`status` = 1
AND `tbl_products`.`id` IN(65677, 21528, 87544, 84385, 84374, 19661, 69525, 112752, 35870, 8717, 101698, 65298, 24071, 65379, 34937, 55209, 38119, 66783, 39332, 46316, 60153, 35218, 93756, 99425, 23757, 26750, 10670, 38374, 40440, 84268, 63072, 39150, 30150, 26758, 69495, 24140, 68346, 114512, 84377, 37808, 101067, 69134, 112247, 46314, 79086, 81293, 60161, 60152, 38520, 112257, 65357, 63472, 84371, 46315, 46317, 46570, 112262, 46572, 86201, 45409, 118835, 30024, 21419, 8631, 31659, 86183, 8672, 72253, 85834, 4196, 38377, 84279, 65311, 45417, 29019, 11342, 102707, 19669, 16871, 34223, 18021, 67106, 112491, 63475, 30213, 19649, 68916, 29689, 96536, 19644, 111921, 2994, 69481, 77665, 36457, 26843, 112309, 63672, 24000, 19349, 25316, 88714, 104911, 33054)
AND `tbl_products`.`id` != 33054
 LIMIT 10 ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '2994' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '4196' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '8631' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '8672' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '8717' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '10670' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '11342' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '16871' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '18021' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '19349' ?>

SELECT `tbl_products`.*, `tbl_user`.`company_name` as `sellername`, `tbl_measurement_unit`.`unit_name` as `measurement_unit_name`, `tbl_product_category`.`name` as `product_category_name`
FROM `tbl_products`
LEFT JOIN `tbl_user` ON `tbl_products`.`seller_id` = `tbl_user`.`id`
LEFT JOIN `tbl_measurement_unit` ON `tbl_products`.`measurement_unit` = `tbl_measurement_unit`.`id`
LEFT JOIN `tbl_product_category` ON `tbl_products`.`product_category_id` = `tbl_product_category`.`id`
WHERE `tbl_products`.`id` = 33054 ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = 33054 ?>

SELECT `tbl_products`.*, `tbl_measurement_unit`.`unit_name` as `measurement_unit_name`
FROM `tbl_products`
LEFT JOIN `tbl_measurement_unit` ON `tbl_products`.`measurement_unit` = `tbl_measurement_unit`.`id`
WHERE `tbl_products`.`status` = 1
AND `tbl_products`.`catalog_status` = 1
AND `tbl_products`.`id` in (59784,33054,66911,37478,37480)
AND `tbl_products`.`id` != 33054 
ORDER BY FIELD(tbl_products.id, 59784, 33054, 66911, 37478, 37480)
 LIMIT 4 ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '59784' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '66911' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '37478' ?>

SELECT *
FROM `tbl_product_image`
WHERE `status` = 1
AND `product_id` = '37480' ?>

SELECT `tbl_products`.*, `tbl_measurement_unit`.`unit_name` as `measurement_unit_name`
FROM `tbl_products`
LEFT JOIN `tbl_measurement_unit` ON `tbl_products`.`measurement_unit` = `tbl_measurement_unit`.`id`
WHERE `tbl_products`.`family` = 'RS037076'
AND `tbl_products`.`status` = 1
AND `tbl_products`.`catalog_status` = 1
AND `tbl_products`.`id` != 33054 ?>

SELECT `id`, `name`
FROM `tbl_attribute`
WHERE `family` = 1
AND `product_category_id` = '697' ?>

SELECT *
FROM `hm_trending_products`
WHERE `status` = 1
ORDER BY `priority` ?>

SELECT `quantity`
FROM `tbl_cart`
WHERE `tbl_cart`.`status` = 1
AND `tbl_cart`.`product_id` = 33054
AND `tbl_cart`.`session_id` = 'cd108de31edf8ac3d202c4a90e812c31' ?>

select * FROM tbl_seo_update where uri='product/productdetails/234355-pure-source-pure-source-lemon-grass-aroma-oil-100-ml' ?>

SELECT count(*) as total
FROM `tbl_cart`
WHERE `status` = 1
AND `session_id` = 'cd108de31edf8ac3d202c4a90e812c31' ?>

SELECT count(*) as total
FROM `tbl_quote`
WHERE `status` = 1
AND `session_id` = 'cd108de31edf8ac3d202c4a90e812c31' ?>

SELECT count(*) as total
FROM `tbl_price_request`
WHERE `status` = 3
AND `user_id` IS NULL ?>

SELECT count(tbl_online_rfq.id) as total
FROM `tbl_online_rfq_item`
LEFT JOIN `tbl_online_rfq` ON `tbl_online_rfq_item`.`rfq_id`=`tbl_online_rfq`.`id`
WHERE `tbl_online_rfq`.`status` IN(0, 1, 2, 3)
AND `tbl_online_rfq_item`.`status` = '0'
AND `tbl_online_rfq`.`buyer` IS NULL ?>

SELECT *
FROM `hm_product_category`
WHERE `status` = 1
ORDER BY `priority` ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '7'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '8'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '531'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '111'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '115'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '128'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '131'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '647'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '687'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '694'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '724'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '725'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '750'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '755'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '695'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '8'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '101'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '9'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '498'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '102'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '567'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '99'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '531'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '111'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '115'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '819'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '820'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '821'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '822'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '823'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '128'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '129'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '130'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '131'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '647'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '687'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '685'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '697'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '698'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '688'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '694'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '724'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '725'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '750'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '755'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '695'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '1'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '2'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '4'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '18'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '31'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '45'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '53'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '63'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '79'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '82'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '71'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '2'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '496'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '12'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '4'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '6'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '523'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '16'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '15'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '321'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '18'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '23'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '21'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '22'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '20'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '719'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '31'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '318'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '41'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '525'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '36'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '39'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '892'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '40'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '32'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '35'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '43'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '44'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '34'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '42'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '45'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '53'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '60'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '55'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '56'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '58'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '57'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '54'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '61'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '522'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '62'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '59'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '63'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '499'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '64'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '66'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '319'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '79'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '80'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '81'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '82'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '84'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '83'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '71'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '77'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '73'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '320'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '75'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '72'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '76'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '233'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '267'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '564'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '653'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '665'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '712'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '234'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '247'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '253'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '767'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '641'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '267'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '720'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '270'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '564'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '653'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '665'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '712'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '234'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '722'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '237'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '521'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '240'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '718'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '242'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '236'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '235'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '727'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '728'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '726'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '664'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '247'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '249'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '661'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT *
FROM `tbl_product_category`
WHERE `parent_id` = '253'
AND `status` = 1
AND `show_display` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '254'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '257'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '255'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '261'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '258'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '263'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '265'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '652'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '259'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '721'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '746'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '666'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '244'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '260'
AND `status` = 1
ORDER BY ISNULL(priority), `priority` ASC ?>