Hindware Immacula 3 in 1 Wall Mixer with Provision Shower, F110019CP

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` = 35962
AND `tbl_products`.`status` = 1
AND `tbl_products`.`catalog_status` = 1 ?>

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

INSERT INTO `tbl_products_click` (`product_id`, `indate`, `ip`) VALUES (35962, '2026-09-29 00:53:40', '216.73.216.39') ?>

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

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '672'
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` = 35962
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` = 35962
 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(43447, 47362, 59635, 29076, 65107, 61589, 34364, 61658, 68596, 41890, 110868, 64746, 26293, 37182, 113874, 24063, 18550, 40795, 41893, 63241, 10917, 86395, 33486, 105140, 26130, 93746, 3385, 44459, 3380, 98992, 111749, 65094, 87615, 18826, 37195, 41134, 46407, 63243, 45721, 95559, 83795, 81927, 29074, 96384, 29065, 61508, 4026, 46403, 113363, 35962)
AND `tbl_products`.`id` != 35962
 LIMIT 10 ?>

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

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

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

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

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

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

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

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

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

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

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` = 35962 ?>

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

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 (35962,35963,35709,35727,35735)
AND `tbl_products`.`id` != 35962 
ORDER BY FIELD(tbl_products.id, 35962, 35963, 35709, 35727, 35735)
 LIMIT 4 ?>

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

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

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

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

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` = 35962
AND `tbl_cart`.`session_id` = 'e7498440d6afb472965e320f73dc4094' ?>

select * FROM tbl_seo_update where uri='product/productdetails/237263-hindware-hindware-immacula-3-in-1-wall-mixer-with-provision-shower-f110019cp' ?>

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

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

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 ?>

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

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

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

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

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

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

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