Banner1 Banner1
 
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_36` 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 ('213')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 '%Calculators' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Calculators' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Calculators' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Calculators"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Calculators"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Calculators"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Calculators"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Calculators' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Calculators',`category_4` ='Calculators') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Calculators,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Calculators', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Calculators

Refine Search

  GO
 
Brand

Victor(6)

Sharp(3)

 
Size

5.78 x 8.78(1)

8 x 12(1)

8.78 x 13.2(1)

4.5 x 5.5(1)

6 x 7.5 x 1.5(1)

7.75 x 9.75 x 2.5(1)

7.5 x 9.5(1)

6 x 7.5(1)

2 1/2 x 4 1/2(1)

 
Manufacturer Part Number

EL1750V(1)

EL2192RII(1)

EL2630PIII(1)

1100-3A(1)

1208-2(1)

1212-3A(1)

1310(1)

2140(1)

900(1)

 
Country of Origin

CN(8)

MY(1)

 
Power Source(s)

AC; Battery(3)

AC(3)

Battery; Solar(3)

 
Display Type(s)

LCD(6)

Fluorescent(2)

Two-Color Dot Matrix(1)

 
Number of Display Digits

12(6)

10(1)

10; 12(1)

8(1)

 
Percent Key(s)

Yes(8)

No(1)

 
Display Notation

Numeric(8)

Punctuated(1)

 
Grand Total Key

Yes(6)

No(3)

 
+/- Switch Key

Yes(8)

No(1)

 
Time/Date

Yes(5)

No(4)

 
Double Zero Key

Yes(7)

No(1)

 
Tax Calculation

Yes(7)

No(2)

 
Percent Add-On/Discount

Yes(5)

No(4)

 
Backspace Key

Yes(7)

No(2)

 
Item Count Function

Yes(6)

No(3)

 
Markup/Down Key

No(5)

Yes(3)

 
Decimal Function

Yes(6)

No(2)

 
Loan Calculation

No(8)

 
Square Root Key

No(4)

Yes(4)

 
Fraction/Decimal Conversions

No(7)

 
Display Characters Height

19 mm(2)

15 mm(2)

12 mm(1)

17 mm(1)

16 mm(1)

18 mm(1)

14 mm(1)

 
Trig/Log Functions

No(7)

 
Amortization

No(7)

 
Complex Number Calculations

No(7)

 
Interest Rate Conversion

No(7)

 
Bond Calculations

No(7)

 
Time-Value-of-Money

No(7)

Yes(1)

 
Probability (Random Number)

No(7)

 
Simultaneous Equations

No(7)

 
Variable Regression

No(7)

 
Hyperbolic Functions

No(7)

 
Base Number Calculations

No(6)

 
Logical (Boolean) Operations

No(7)

 
Date Calculations

No(6)

Yes(1)

 
Hypothesis Testing

No(7)

 
Linear Regression

No(7)

 
Metric Conversion

No(7)

 
Polar-Rectangular Conversion

No(7)

 
Confidence Interval Calculating

No(7)

 
Matrices

No(7)

 
Display Angle

Fixed(6)

Angled(1)

 
Replacement Batteries

AA(3)

1.5V Silver Oxide(2)

L1131(1)

 
Display Characters x Display Lines

12 x 1(1)

 
Case

Hard; Slide(1)

 
Print Color(s)

Black; Red(5)

Black(1)

 
Print Speed (Lines per Second)

2(1)

3(1)

4.8(1)

2.3(1)

2.7(1)

6(1)

 
Variable Statistics

No(2)

 
Replacement Roll Paper

UNV-35720(5)

UNV-35762(1)

 
Cash Flow Calculations

No(2)

 
Replacement Ribbon/Roller

DPS-R1427(3)

DPS-R1477-2(1)

DPS-R3027(1)

 
Memory

4-Key(7)

3-Key(2)

 
Cost/Sell/Margin

Yes(6)

No(3)

 
Wall-Mountable

No(1)

 
Currency Exchange Function

No(8)

Yes(1)

 
Fraction Calculations

No(6)

Yes(1)

 
Depreciation Calculations

No(7)

 
Equation Editor

No(7)

 
Ribbon/Roller Printer

Roller(4)

Ribbon(1)

 
 
 

© 2020-2021 Gateway Business Products, All Rights Reserved