Kores Pencil Carbon - 55 Blue with ISI Mark (Pack of 100)

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

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

INSERT INTO `tbl_products_click` (`product_id`, `indate`, `ip`) VALUES (28224, '2026-09-28 21:05:27', '216.73.216.39') ?>

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

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '76'
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` = 28224
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` = 28224
 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(103152, 97736, 39602, 45993, 18793, 111702, 85299, 113906, 121121, 68115, 123244, 66732, 71665, 66709, 111035, 44093, 116776, 324, 85297, 90382, 64579, 119064, 120010, 95943, 122048, 28226, 118489, 113749, 102350, 6335, 85019, 49330, 114845, 4140, 113905, 125688, 37022, 98733, 97387, 27541, 7811, 6398, 63006, 85301, 3608, 125044, 1888, 71661, 101240, 6409, 120438, 31033, 39582, 39592, 101312, 116792, 90523, 84044, 44092, 124929, 124276, 398, 66480, 72864, 3048, 103866, 90394, 63711, 91503, 31, 39581, 3607, 68482, 1892, 33839, 412, 109128, 108147, 11929, 111329, 95271, 103697, 117217, 38563, 10439, 117467, 36850, 123377, 123883, 85030, 122018, 102667, 102970, 55349, 90543, 39632, 16966, 11429, 10152, 69466, 3181, 121658, 26014, 58609, 3143, 124014, 11434, 98564, 69275, 124169, 37024, 11707, 101218, 28224)
AND `tbl_products`.`id` != 28224
 LIMIT 10 ?>

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

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

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

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

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

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

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

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

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

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

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

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

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 (28220,28226,264,28224,39426)
AND `tbl_products`.`id` != 28224 
ORDER BY FIELD(tbl_products.id, 28220, 28226, 264, 28224, 39426)
 LIMIT 4 ?>

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

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

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` = 28224
AND `tbl_cart`.`session_id` = '1fc937447b61b0c937e07841a5b4a974' ?>

select * FROM tbl_seo_update where uri='product/productdetails/229525-kores-kores-pencil-carbon-55-blue-with-isi-mark-pack-of-100' ?>

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

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

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