Hindware Oros Single Lever Bath and Shower Mixer Exposed, F350011CP

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

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

INSERT INTO `tbl_products_click` (`product_id`, `indate`, `ip`) VALUES (35854, '2026-09-28 23:14:52', '216.73.216.39') ?>

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

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '640'
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` = 35854
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` = 35854
 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(18565, 61431, 41095, 65095, 113047, 20018, 65738, 27719, 60066, 65726, 2305, 86326, 29101, 87613, 41131, 26181, 93715, 61402, 59829, 93682, 32599, 113491, 64733, 37199, 105409, 83576, 66344, 102190, 26164, 102863, 2295, 111701, 87589, 27077, 72295, 65732, 86258, 40789, 66141, 46391, 3416, 10895, 30639, 47712, 18055, 65727, 26166, 113875, 29083, 46389, 17780, 72428, 72249, 61394, 26196, 113038, 64736, 86017, 59849, 58437, 17813, 91263, 10804, 66146, 23369, 46402, 64731, 26163, 113062, 40053, 54604, 43445, 17788, 69557, 26162, 61513, 59850, 5038, 81187, 109785, 16247, 43442, 61581, 83609, 71048, 29097, 61501, 64732, 82281, 82312, 66180, 10905, 84640, 118919, 8697, 61510, 118660, 63209, 30656, 64728, 61624, 66339, 46216, 86551, 29134, 59838, 80000, 46419, 63238, 59475, 37180, 52977, 46388, 23970, 27596, 93703, 46854, 114042, 80581, 37086, 41138, 65913, 27723, 114200, 29078, 41132, 52840, 66161, 10912, 86255, 61950, 26176, 61577, 10919, 66488, 66462, 25131, 83798, 52978, 68454, 114047, 47360, 62776, 9081, 29111, 7222, 53998, 65713, 27078, 16248, 52981, 10890, 86739, 66164, 1432, 115149, 59611, 93714, 10908, 9077, 93713, 65015, 61432, 85316, 60996, 25554, 65001, 40793, 29089, 86989, 63207, 41120, 66145, 27720, 10903, 37190, 64170, 91260, 65013, 66172, 10899, 41128, 61476, 61572, 7570, 118975, 65744, 35932, 100878, 9080, 66279, 61570, 86257, 41521, 64741, 61585, 93716, 41117, 61623, 91848, 46868, 65012, 26660, 46170, 27400, 83986, 20419, 114049, 59614, 65733, 60946, 46384, 100622, 20420, 37184, 6852, 65753, 87614, 38255, 30658, 8913, 29138, 101850, 97017, 40784, 105147, 61594, 93745, 64726, 65752, 7533, 113516, 30657, 86960, 46422, 61586, 65748, 117739, 20028, 64720, 91453, 76558, 4737, 23962, 61809, 91201, 108155, 60209, 83985, 61523, 61575, 70578, 93688, 113022, 70495, 63233, 99254, 7202, 83612, 64723, 7579, 18228, 93704, 20428, 64725, 112978, 86246, 47711, 47255, 83582, 64722, 30367, 46861, 83967, 29109, 113085, 66343, 83698, 61443, 81928, 46427, 18823, 86968, 115120, 23966, 109271, 116193, 62189, 113083, 61609, 87598, 66391, 52010, 111476, 95569, 8169, 113876, 29091, 41101, 86321, 31317, 16241, 10907, 65006, 63237, 64759, 64763, 61573, 46400, 83712, 93739, 65010, 5555, 86447, 64980, 41110, 95532, 46428, 35958, 65745, 46399, 7577, 41121, 80362, 61511, 9073, 65749, 98407, 26175, 29068, 113017, 95052, 86256, 47715, 46850, 64738, 9093, 41102, 10897, 65763, 40742, 66377, 37178, 64686, 69727, 16244, 67748, 18536, 29133, 115148, 9082, 83970, 64979, 71049, 35818, 114037, 37176, 93700, 86275, 68231, 64971, 64719, 68456, 98670, 18540, 10809, 86969, 63841, 3410, 65769, 45458, 65712, 7227, 95051, 30655, 37185, 30633, 65009, 58446, 118089, 9094, 18538, 7568, 65723, 3379, 64727, 112953, 86980, 86328, 99230, 61440, 32392, 114046, 41111, 18093, 23913, 66166, 48707, 63229, 46383, 113008, 30356, 61525, 115939, 61400, 33500, 7205, 61404, 46382, 86313, 7221, 50623, 4247, 96167, 64734, 65722, 2314, 65762, 7578, 29137, 29087, 113010, 17787, 27722, 87593, 95558, 46425, 64758, 23960, 61495, 61569, 64735, 61584, 35789, 7550, 87591, 41104, 64761, 113020, 2304, 64713, 113873, 41107, 47253, 72265, 9078, 66348, 66378, 9961, 35938, 71054, 87590, 64762, 58601, 3397, 64685, 105245, 100734, 59625, 95045, 881, 87644, 47706, 83585, 85973, 62229, 48022, 68455, 93696, 119977, 29088, 95563, 52296, 10898, 64717, 91334, 59613, 20425, 18825, 26170, 19736, 27717, 64709, 46390, 96383, 65768, 16214, 3420, 8917, 80429, 26200, 35907, 86734, 30366, 16186, 20369, 18052, 66156, 46387, 55214, 71052, 65707, 29064, 98365, 880, 113060, 83972, 64712, 18225, 27247, 44425, 64724, 64999, 62188, 61386, 29079, 62724, 61583, 49345, 3381, 96170, 43422, 86707, 19839, 28344, 884, 66353, 61382, 64752, 64716, 93685, 71053, 46856, 64760, 86650, 29086, 18535, 18533, 109554, 83971, 64715, 27597, 20371, 19842, 40786, 63212, 93683, 24018, 2273, 64982, 46420, 30370, 26205, 3404, 96433, 61490, 61496, 114190, 64755, 83353, 112915, 59627, 65011, 9929, 24017, 117738, 11694, 10184, 66956, 65004, 83719, 46426, 66151, 54603, 87596, 23967, 10688, 40743, 1423, 46394, 66342, 114045, 41139, 65014, 64749, 26197, 63234, 62184, 65144, 68230, 33478, 18229, 58679, 95510, 63231, 41089, 54345, 65736, 46893, 65007, 64756, 30662, 18534, 64748, 3399, 61503, 117253, 64751, 10892, 66190, 46863, 118967, 37191, 23726, 42723, 64721, 86988, 23976, 10904, 64976, 61477, 4323, 66283, 2290, 30661, 9931, 23911, 113992, 95533, 64983, 95511, 95535, 58843, 86735, 41097, 61493, 86323, 87599, 83968, 48100, 87592, 61499, 71050, 65002, 95531, 91450, 114202, 65717, 41087, 67556, 18092, 20370, 46851, 20421, 2282, 23964, 18521, 111698, 70503, 65016, 114192, 65005, 81301, 113872, 18554, 66337, 62183, 87594, 43446, 10891, 87772, 113064, 62186, 113505, 23968, 29136, 29128, 27081, 60213, 61437, 41129, 40787, 26165, 54955, 57007, 66171, 883, 65000, 91259, 66185, 65140, 40785, 69087, 64714, 30348, 2324, 46839, 65143, 83990, 113023, 46847, 17807, 59852, 80685, 118966, 20423, 115122, 41899, 83797, 64703, 9670, 61379, 30659, 18215, 33477, 9671, 86975, 4736, 93702, 35854)
AND `tbl_products`.`id` != 35854
 LIMIT 10 ?>

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

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

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

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

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

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

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

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

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

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

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

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

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 (35854,35679,35974,35975,35764)
AND `tbl_products`.`id` != 35854 
ORDER BY FIELD(tbl_products.id, 35854, 35679, 35974, 35975, 35764)
 LIMIT 4 ?>

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

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

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

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

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` = 35854
AND `tbl_cart`.`session_id` = '3311bb8d5108a9841ef12526124421fe' ?>

select * FROM tbl_seo_update where uri='product/productdetails/237155-hindware-hindware-oros-single-lever-bath-and-shower-mixer-exposed-f350011cp' ?>

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

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

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