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

Currently Filtered by

Category

Medications

Refine Search

  GO
 
Brand

PhysiciansCare(12)

Lil' Drug Store(11)

Airborne(4)

First Aid Only(4)

Advil(4)

Tylenol(2)

LISTERINE®(2)

Neosporin(2)

Motrin(2)

Cadbury(2)

Mucinex(1)

Bayer(1)

SunX(1)

Lil' Drug(1)

Alka-Seltzer(1)

Pepto-Bismol(1)

Zyrtec(1)

Acme United(1)

Aleve(1)

Colgate(1)

Ricola(1)

 
Color

Black(1)

Yellow(1)

White(1)

 
Recycled

No(54)

 
Packaged Quantity

50 / Box(18)

1 Each(5)

100 / Box(5)

12 / Box(5)

30 / Box(5)

125 / Box(2)

20 / Box(2)

60 / Box(2)

21 / Each(1)

30 / Pack(1)

2160 / Carton(1)

160 / Box(1)

7 / Box(1)

10 / Tube(1)

15 / Box(1)

240 / Case(1)

144 / Box(1)

6 / Box(1)

1 / Each(1)

21 / Bag(1)

 
Assembly Required

No(1)

 
Weight (Approximate)

0.03 oz(1)

0.85 oz(1)

 
Recycled Content

No(2)

 
Recommended Use

Lip(1)

 
Case Style

Wall Mountable(1)

 
Flavor

Citrus(2)

Cherry(2)

Mint(2)

Zesty Orange(1)

Fruit(1)

Honey Lemon(1)

 
Package Type

Box(1)

Bulk(1)

 
Volume Capacity

0.35 fl oz(1)

 
Fluid Quantity

0.03 oz(2)

0.26 oz(1)

1 gal(1)

1.59 quart(1)

 
Nutrition Facts

Per Drop:

  • 17 kcal
  • Carbohydrate 4.1g
  • Sugars 3.2g
  • Sugar Alcohols 0g
  • Other Carbohydrates 0g
  • Fats 0g
  • Fiber 0g
  • Sodium 0g
  • Vitamin C 0mg
(1)

 
Medicine Type

Tablet(28)

Caplet(5)

Ointment(5)

Liquid(2)

Lozenge(1)

Cream(1)

Pill(1)

 
Dosage

Single-dose(25)

 
Medicine Per Dosage

2(9)

1(8)

 
Manufacturer Part Number

58030(1)

53026(1)

62001(1)

71613(1)

97047(1)

7776(1)

51060(1)

51030(1)

42755(1)

42750(1)

44910(1)

48152(1)

512372200(1)

97187(1)

97197(1)

29703(1)

30004(1)

QK00027(1)

QK60591(1)

CTSS010661(1)

18572(1)

10030CT(1)

97257(1)

97217(1)

97477(1)

07207(1)

10030(1)

23769(1)

20436(1)

90036(1)

90016(1)

90087(1)

90089(1)

90091(1)

90015(1)

90014(1)

15000(1)

12408(1)

40800(1)

51025(1)

90010(1)

90092(1)

90109(1)

13600(1)

13006(1)

18012(1)

044909(1)

048101(1)

12700(1)

12001(1)

90780(1)

90751(1)

62182(1)

62183(1)

09782(1)

016902(1)

 
Country of Origin

United States(4)

China(1)

 
Height

11"(1)

 
Width

15.3"(1)

 
Depth

2.5"(1)

 
Container Type

Tube(1)

 
Case Material

Plastic(1)

 
 
 

© 2019-2020 LOP Office Supply, All Rights Reserved