MK 4W TPN Double Door DB, S4WTPNDD

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

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

INSERT INTO `tbl_products_click` (`product_id`, `indate`, `ip`) VALUES (38187, '2026-09-29 23:11:18', '216.73.217.33') ?>

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

SELECT `id`
FROM `tbl_product_category`
WHERE `parent_id` = '235'
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` = 38187
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` = 38187
 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(38190, 39410, 20649, 32049, 95148, 23072, 39412, 44984, 23074, 45031, 27502, 39407, 45024, 39408, 39413, 20647, 45153, 20654, 20643, 23073, 39405, 16894, 39409, 20639, 45016, 45693, 102099, 20646, 45002, 32046, 40111, 38187)
AND `tbl_products`.`id` != 38187
 LIMIT 10 ?>

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

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

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

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

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

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

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

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

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

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

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

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

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 (38187,38188,38183,38192,38193)
AND `tbl_products`.`id` != 38187 
ORDER BY FIELD(tbl_products.id, 38187, 38188, 38183, 38192, 38193)
 LIMIT 4 ?>

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

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

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

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

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` = 'RS037779'
AND `tbl_products`.`status` = 1
AND `tbl_products`.`catalog_status` = 1
AND `tbl_products`.`id` != 38187 ?>

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

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` = 38187
AND `tbl_cart`.`session_id` = '72ac74fe540a4b96d15ba860c7fd5981' ?>

select * FROM tbl_seo_update where uri='product/productdetails/239488-mk-mk-4w-tpn-double-door-db-s4wtpndd' ?>

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

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

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