Slip Resistant Injected Closed Back Clog in WHT

Style: EXACT Color: WHT

Choose a size:

Size Chart

Selected Color:

26.97

Please Choose A Size

Colors

Neon Pink
Neon Green

About This Product

Extremely lightweight and flexible DBL compound. Molded, removable, cushioned insole with vent channels. It is washable using cool to warm water. Flexible Slip Resistant outsole delivers long-lasting durability on a variety of surfaces. APMA accepted.

More like this

More in this style Slip Resistant Injected Closed Back Clog (EXACT)

More in this color (WHT)

Size Chart

Anywear: Zone, Exact, Point

Sizes
5
6
7
8
9
10
11
12
13
Womens 5 6 7 8 9 10 11 12 13
Mens 3 4 5 6 7 8 9 10 11
SetCategoryInfo in BaseModel.php Array ( [category_name] => Footwear [description] => Array ( [short] => [long] => ) [required] => Array ( [gsa] => Array ( [0] => 40 ) [gba] => Array ( [0] => 89 ) [sa] => Array ( [0] => 4040 ) ) [optional] => Array ( [ba] => Array ( [0] => 8900 [1] => 8901 [2] => 8902 [3] => 8907 [4] => 8908 [5] => 8918 [6] => 8919 [7] => 8922 [8] => 8923 [9] => 8934 [10] => 8935 [11] => 8937 [12] => 8938 [13] => 8939 [14] => 8940 [15] => 8941 [16] => 8945 [17] => 8950 [18] => 8952 [19] => 8955 [20] => 8957 [21] => 9003 [22] => 9005 [23] => 9006 [24] => 89103 [25] => 89104 ) ) ) RegisterFilter in BaseSearch.php szFilterField: gsa szFilterVal: 40 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: gba szFilterVal: 89 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: sa szFilterVal: 4040 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8900 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8901 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8902 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8907 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8908 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8918 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8919 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8922 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8923 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8934 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8935 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8937 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8938 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8939 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8940 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8941 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8945 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8950 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8952 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8955 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8957 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 9003 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 9005 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 9006 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 89103 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 89104 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: EXACT szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: WHT szFilterType: required RegisterFilter in BaseSearch.php szFilterField: start_num szFilterVal: 36 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 2 filters In BaseSearch::GenerateQuery filters are Array ( [required] => Array ( [group] => Array ( [sa] => Array ( [0] => 40 ) [ba] => Array ( [0] => 89 ) ) [sa] => Array ( [0] => 4040 ) [style_id] => Array ( [0] => EXACT ) [color_id] => Array ( [0] => WHT ) ) [optional] => Array ( [ba] => Array ( [0] => 8900 [1] => 8901 [2] => 8902 [3] => 8907 [4] => 8908 [5] => 8918 [6] => 8919 [7] => 8922 [8] => 8923 [9] => 8934 [10] => 8935 [11] => 8937 [12] => 8938 [13] => 8939 [14] => 8940 [15] => 8941 [16] => 8945 [17] => 8950 [18] => 8952 [19] => 8955 [20] => 8957 [21] => 9003 [22] => 9005 [23] => 9006 [24] => 89103 [25] => 89104 ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=sa value= 4040 group=40 base:=style_attribute # join: p.style_id = #.style_id AND #.style_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 style_attribute req1_sa, ( 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_sa.style_group_id = '40' AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4040') AND req1_sa.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= EXACT 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, style_attribute req1_sa, ( 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 ('EXACT') AND req2_s.status = 0 AND req1_sa.style_group_id = '40' AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4040') AND req1_sa.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= WHT 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, style_attribute req1_sa, ( 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 ('WHT') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('EXACT') AND req2_s.status = 0 AND req1_sa.style_group_id = '40' AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4040') AND req1_sa.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 RefactorOptional in QueryBuilderBase::RefactorOptional field=ba value= group= 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 RefactorOptional QueryBuilderBase::RefactorOptional 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 opt1_ba, color req1_c, style req2_s, style_attribute req1_sa, ( 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 = opt1_ba.style_id AND p.color_id = opt1_ba.color_id AND p.identifier_id = opt1_ba.identifier_id AND opt1_ba.sci_group_id='89' AND opt1_ba.sci_attribute_id IN ('8900','8901','8902','8907','8908','8918','8919','8922','8923','8934','8935','8937','8938','8939','8940','8941','8945','8950','8952','8955','8957','9003','9005','9006','89103','89104') AND opt1_ba.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('WHT') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('EXACT') AND req2_s.status = 0 AND req1_sa.style_group_id = '40' AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4040') AND req1_sa.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: 8900 | | 1; Refactored to: 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 opt1_ba, color req1_c, style req2_s, style_attribute req1_sa, ( 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 = opt1_ba.style_id AND p.color_id = opt1_ba.color_id AND p.identifier_id = opt1_ba.identifier_id AND opt1_ba.sci_group_id='89' AND opt1_ba.sci_attribute_id IN ('8900','8901','8902','8907','8908','8918','8919','8922','8923','8934','8935','8937','8938','8939','8940','8941','8945','8950','8952','8955','8957','9003','9005','9006','89103','89104') AND opt1_ba.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('WHT') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('EXACT') AND req2_s.status = 0 AND req1_sa.style_group_id = '40' AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4040') AND req1_sa.status = 0 AND p.style_id = 'EXACT' 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 =============================================================================================== 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 sci_attribute opt1_ba, color req1_c, style req2_s, style_attribute req1_sa, ( 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 = opt1_ba.style_id AND p.color_id = opt1_ba.color_id AND p.identifier_id = opt1_ba.identifier_id AND opt1_ba.sci_group_id='89' AND opt1_ba.sci_attribute_id IN ('8900','8901','8902','8907','8908','8918','8919','8922','8923','8934','8935','8937','8938','8939','8940','8941','8945','8950','8952','8955','8957','9003','9005','9006','89103','89104') AND opt1_ba.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('WHT') AND req1_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('EXACT') AND req2_s.status = 0 AND req1_sa.style_group_id = '40' AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4040') AND req1_sa.status = 0 AND p.style_id = 'EXACT' 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.0042750835418701 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: shoe