Littmann Cardiology III in RED

Style: L3140 Color: RED

Selected Color:

was: $261.80

your price:150.97

save: $110.83

About This Product

The Littmann Cardiology III is characterized by outstanding acoustic performance and exceptional versatility. This innovative design offers a tunable diaphragm on each side of the chestpiece. The large side can be used on adults, while the small side is especially useful in pediatrics or special uses.

More like this

More in this style Littmann Cardiology III (L3140)

More in this color (RED)

SetCategoryInfo in BaseModel.php Array ( [category_name] => Cardiology Stethoscopes [description] => Array ( [short] => [long] => ) [required] => Array ( [gscia] => Array ( [0] => 56 ) [gba] => Array ( [0] => 89 ) [scia] => Array ( [0] => 5820 ) [ba] => Array ( [0] => 8959 ) ) ) RegisterFilter in BaseSearch.php szFilterField: gscia szFilterVal: 56 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: gba szFilterVal: 89 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 5820 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8959 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: L3140 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: RED szFilterType: required RegisterFilter in BaseSearch.php szFilterField: start_num szFilterVal: 0 szFilterType: required ! ignored filter start_num 1. I'm in the Search function in BaseSearch.php. SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL In BaseSearch::GenerateQuery with 1 filters In BaseSearch::GenerateQuery filters are Array ( [required] => Array ( [group] => Array ( [scia] => Array ( [0] => 56 ) [ba] => Array ( [0] => 89 ) ) [scia] => Array ( [0] => 5820 ) [ba] => Array ( [0] => 8959 ) [style_id] => Array ( [0] => L3140 ) [color_id] => Array ( [0] => RED ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=scia value= 5820 group= base:=sci_attribute # join: p.style_id = #.style_id AND p.color_id = #.color_id AND p.identifier_id = #.identifier_id AND #.sci_attribute_id = '?' AND #.status = 0 End RefactorRequired QueryBuilderBase::RefactorRequired query SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM sci_attribute req1_scia, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = req1_scia.style_id AND p.color_id = req1_scia.color_id AND p.identifier_id = req1_scia.identifier_id AND req1_scia.sci_attribute_id IN ('5820') AND req1_scia.status = 0 AND p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=ba value= 8959 group=89 base:=sci_attribute # join: p.style_id = #.style_id AND p.color_id = #.color_id AND p.identifier_id = #.identifier_id AND #.sci_group_id='89' AND #.sci_attribute_id = '?' AND #.status = 0 End RefactorRequired QueryBuilderBase::RefactorRequired query SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM sci_attribute req1_ba, sci_attribute req1_scia, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE req1_ba.sci_group_id = '89' AND p.style_id = req1_ba.style_id AND p.color_id = req1_ba.color_id AND p.identifier_id = req1_ba.identifier_id AND req1_ba.sci_group_id='89' AND req1_ba.sci_attribute_id IN ('8959') AND req1_ba.status = 0 AND p.style_id = req1_scia.style_id AND p.color_id = req1_scia.color_id AND p.identifier_id = req1_scia.identifier_id AND req1_scia.sci_attribute_id IN ('5820') AND req1_scia.status = 0 AND p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=style_id value= L3140 group= base:=style # join: p.style_id = #.style_id AND #.style_id = '?' AND #.status = 0 End RefactorRequired QueryBuilderBase::RefactorRequired query SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM style req2_s, sci_attribute req1_ba, sci_attribute req1_scia, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = req2_s.style_id AND req2_s.style_id IN ('L3140') AND req2_s.status = 0 AND req1_ba.sci_group_id = '89' AND p.style_id = req1_ba.style_id AND p.color_id = req1_ba.color_id AND p.identifier_id = req1_ba.identifier_id AND req1_ba.sci_group_id='89' AND req1_ba.sci_attribute_id IN ('8959') AND req1_ba.status = 0 AND p.style_id = req1_scia.style_id AND p.color_id = req1_scia.color_id AND p.identifier_id = req1_scia.identifier_id AND req1_scia.sci_attribute_id IN ('5820') AND req1_scia.status = 0 AND p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=color_id value= RED group= base:=color # join: p.color_id = #.color_id AND #.color_id = '?' AND #.status = 0 End RefactorRequired QueryBuilderBase::RefactorRequired query SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM color req1_c, style req2_s, sci_attribute req1_ba, sci_attribute req1_scia, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.color_id = req1_c.color_id AND req1_c.color_id IN ('RED') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('L3140') AND req2_s.status = 0 AND req1_ba.sci_group_id = '89' AND p.style_id = req1_ba.style_id AND p.color_id = req1_ba.color_id AND p.identifier_id = req1_ba.identifier_id AND req1_ba.sci_group_id='89' AND req1_ba.sci_attribute_id IN ('8959') AND req1_ba.status = 0 AND p.style_id = req1_scia.style_id AND p.color_id = req1_scia.color_id AND p.identifier_id = req1_scia.identifier_id AND req1_scia.sci_attribute_id IN ('5820') AND req1_scia.status = 0 AND p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL Checking for a brand RefactorQuery: | 8959 | 1; Not needed =============================================================================================== Executed this query: SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM color req1_c, style req2_s, sci_attribute req1_ba, sci_attribute req1_scia, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.color_id = req1_c.color_id AND req1_c.color_id IN ('RED') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('L3140') AND req2_s.status = 0 AND req1_ba.sci_group_id = '89' AND p.style_id = req1_ba.style_id AND p.color_id = req1_ba.color_id AND p.identifier_id = req1_ba.identifier_id AND req1_ba.sci_group_id='89' AND req1_ba.sci_attribute_id IN ('8959') AND req1_ba.status = 0 AND p.style_id = req1_scia.style_id AND p.color_id = req1_scia.color_id AND p.identifier_id = req1_scia.identifier_id AND req1_scia.sci_attribute_id IN ('5820') AND req1_scia.status = 0 AND p.style_id = 'L3140' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL =============================================================================================== No errors found. Well done! Attaching Attributes to results 1 style attributes found 1 color attributes found 1 sci attributes found Exiting attribute attachment after 0.0039081573486328 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: apparel