SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_19` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('165')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%Televisions' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Televisions' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Televisions' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Televisions"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Televisions"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Televisions"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Televisions"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Televisions' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Televisions',`category_4` ='Televisions') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Televisions,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Televisions', `pinfo`.`desc_title`)) DESC

Best-selling work order forms eliminate extra write-ups for invoicing!One write-up does it all! Easily record costs in preprinted sections for materials, labor & more. When job is finished, your invoice is ready!

Best-selling work order forms eliminate extra write-ups for invoicing!One write-up does it all! Easily record costs in preprinted sections for materials, labor & more. When job is finished, your invoice is ready!

One write-up does it all! Work order, invoice, and job cost record. All on one, multi-part form with plenty of room for all the details. Includes preprinted section for customer to sign-off on service/work as acceptable.

One write-up does it all! Work order, invoice, and job cost record. All on one, multi-part form with plenty of room for all the details. Includes preprinted section for customer to sign-off on service/work as acceptable.

One write-up does it all! Work order, invoice, and job cost record. All on one, multi-part form with plenty of room for all the details. Includes preprinted section for customer to sign-off on service/work as acceptable.

Just for jewelers! Repair orders with ample space to detail needed repairs. Has room for special instructions, like engraving and sizing, on one convenient form. Snapset format. Third part has adhesive on back for attaching poly bag. They help you:

Just for cleaning professionals. Work order and invoice in one multi-part form. Plenty of room for all the details. Labor and materials record on back. Last part is sturdy manila tag. Snapset format. These work orders help you:

This best-selling HVAC work order features more room for detailed descriptions!Our HVAC service order/invoice simplifies everything - work writeups, invoicing AND cost documentation!Large format HVAC business form includes extra space for work performed, materials, labor & compliance details.

This best-selling HVAC work order features more room for detailed descriptions!Our HVAC service order/invoice simplifies everything - work writeups, invoicing AND cost documentation!Large format HVAC business form includes extra space for work performed, materials, labor & compliance details.

Write up service orders, invoice for completed jobs and keep a permanent cost record with this service order form.This service order business form keeps you organized and provides customers with a detailed service record.

Write up service orders, invoice for completed jobs and keep a permanent cost record with this service order form.This service order business form keeps you organized and provides customers with a detailed service record.

Keep accurate records of every plumbing job. Use the preprinted checklist to help you plan materials, schedule jobs and record materials used. Last part is durable tag stock, useful for tracking jobs and calculating profit. They help you:

Write up work orders, invoice for completed jobs and keep a permanent cost record with this work order form.This work order form keeps you organized and provides customers with a detailed service record.

Best-selling work order forms eliminate extra write-ups for invoicing!One write-up does it all! Easily record costs in preprinted sections for materials, labor & more. When job is finished, your invoice is ready!

Best-selling work order forms eliminate extra write-ups for invoicing!One write-up does it all! Easily record costs in preprinted sections for materials, labor & more. When job is finished, your invoice is ready!

One write-up does it all! Work order, invoice, and job cost record. All on one, multi-part form with plenty of room for all the details. Includes preprinted section for customer to sign-off on service/work as acceptable.

One write-up does it all! Work order, invoice, and job cost record. All on one, multi-part form with plenty of room for all the details. Includes preprinted section for customer to sign-off on service/work as acceptable.

One write-up does it all! Work order, invoice, and job cost record. All on one, multi-part form with plenty of room for all the details. Includes preprinted section for customer to sign-off on service/work as acceptable.

Just for jewelers! Repair orders with ample space to detail needed repairs. Has room for special instructions, like engraving and sizing, on one convenient form. Snapset format. Third part has adhesive on back for attaching poly bag. They help you:

Just for cleaning professionals. Work order and invoice in one multi-part form. Plenty of room for all the details. Labor and materials record on back. Last part is sturdy manila tag. Snapset format. These work orders help you:

This best-selling HVAC work order features more room for detailed descriptions!Our HVAC service order/invoice simplifies everything - work writeups, invoicing AND cost documentation!Large format HVAC business form includes extra space for work performed, materials, labor & compliance details.

This best-selling HVAC work order features more room for detailed descriptions!Our HVAC service order/invoice simplifies everything - work writeups, invoicing AND cost documentation!Large format HVAC business form includes extra space for work performed, materials, labor & compliance details.

Write up service orders, invoice for completed jobs and keep a permanent cost record with this service order form.This service order business form keeps you organized and provides customers with a detailed service record.

Write up service orders, invoice for completed jobs and keep a permanent cost record with this service order form.This service order business form keeps you organized and provides customers with a detailed service record.

Keep accurate records of every plumbing job. Use the preprinted checklist to help you plan materials, schedule jobs and record materials used. Last part is durable tag stock, useful for tracking jobs and calculating profit. They help you:

Write up work orders, invoice for completed jobs and keep a permanent cost record with this work order form.This work order form keeps you organized and provides customers with a detailed service record.