V-Neck Knit Panel Top

A V-neck top features soft knit side panels, four pockets, including one scissor pocket on left and cell phone pocket with tab snap closure on right. Center back length: 26"

Fabric: 100% Cotton Sheeting

Available Sizes: XS - 3XL Size Chart

Coordinating Colors

Pants in these colors coordinate well with this top. Click to browse.

Ready to Shop?

Search the store locator for your nearest uniform retailer.

Style 1912C in color TDHT

Size Chart

Women

Sizes
XXS
XS
S
M
L
XL
2XL
3XL
4XL
5XL
Numeric 0-1 2-4 6-8 10-12 14-16 18-20 22-24 26-28 30-32 34-36
Bust 31-32 33-34 35-36 37-39 40-43 44-47 48-51 52-55 56-59 60-63
Waist 24-25 24-25 26-27 28-30 31-34 35-38 39-42 43-46 47-50 51-54
Hip 33-34 35-36 37-38 39-41 42-45 46-49 50-53 54-57 58-61 62-65

Regular inseams 30-31"
Petite inseams 27 1/2 - 28 1/2"
Tall inseams 33-34"
Ultra Tall inseams 36" unhemmed

SetCategoryInfo in BaseModel.php Array ( [category_name] => New Prints [description] => Array ( [short] => [long] => ) [required] => Array ( [gca] => Array ( [0] => 30 ) [gsa] => Array ( [0] => 40 ) [gscia] => Array ( [0] => 45 ) [gba] => Array ( [0] => 89 ) [ca] => Array ( [0] => 3010 ) [sa] => Array ( [0] => 4012 ) ) [optional] => Array ( [scia] => Array ( [0] => 4503 [1] => 4550 [2] => 4560 ) [ba] => Array ( [0] => 8900 [1] => 8904 ) ) ) RegisterFilter in BaseSearch.php szFilterField: gca szFilterVal: 30 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: gsa szFilterVal: 40 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: gscia szFilterVal: 45 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: gba szFilterVal: 89 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: ca szFilterVal: 3010 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: sa szFilterVal: 4012 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 4503 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 4550 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 4560 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8900 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8904 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 1912C szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: TDHT szFilterType: required 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, marketing_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 = '648') 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 ( [ca] => Array ( [0] => 30 ) [sa] => Array ( [0] => 40 ) [scia] => Array ( [0] => 45 ) [ba] => Array ( [0] => 89 ) ) [ca] => Array ( [0] => 3010 ) [sa] => Array ( [0] => 4012 ) [style_id] => Array ( [0] => 1912C ) [color_id] => Array ( [0] => TDHT ) ) [optional] => Array ( [scia] => Array ( [0] => 4503 [1] => 4550 [2] => 4560 ) [ba] => Array ( [0] => 8900 [1] => 8904 ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=ca value= 3010 group=30 base:=color_attribute # join: p.color_id = #.color_id AND #.color_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 color_attribute req1_ca, ( color c, style s, marketing_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 = '648') WHERE req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.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=sa value= 4012 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_attribute req1_ca, ( color c, style s, marketing_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 = '648') WHERE req1_sa.style_group_id = '40' AND p.style_id = req1_sa.style_id AND req1_sa.style_attribute_id IN ('4012') AND req1_sa.status = 0 AND req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.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= 1912C 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_attribute req1_ca, ( color c, style s, marketing_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 = '648') WHERE p.style_id = req2_s.style_id AND req2_s.style_id IN ('1912C') 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 ('4012') AND req1_sa.status = 0 AND req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.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= TDHT 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 req2_c, style req2_s, style_attribute req1_sa, color_attribute req1_ca, ( color c, style s, marketing_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 = '648') WHERE p.color_id = req2_c.color_id AND req2_c.color_id IN ('TDHT') AND req2_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('1912C') 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 ('4012') AND req1_sa.status = 0 AND req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.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=scia 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_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_scia, color req2_c, style req2_s, style_attribute req1_sa, color_attribute req1_ca, ( color c, style s, marketing_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 = '648') WHERE p.style_id = opt1_scia.style_id AND p.color_id = opt1_scia.color_id AND p.identifier_id = opt1_scia.identifier_id AND opt1_scia.sci_attribute_id IN ('4503','4550','4560') AND opt1_scia.status = 0 AND p.color_id = req2_c.color_id AND req2_c.color_id IN ('TDHT') AND req2_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('1912C') 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 ('4012') AND req1_sa.status = 0 AND req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.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, sci_attribute opt1_scia, color req2_c, style req2_s, style_attribute req1_sa, color_attribute req1_ca, ( color c, style s, marketing_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 = '648') 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','8904') AND opt1_ba.status = 0 AND p.style_id = opt1_scia.style_id AND p.color_id = opt1_scia.color_id AND p.identifier_id = opt1_scia.identifier_id AND opt1_scia.sci_attribute_id IN ('4503','4550','4560') AND opt1_scia.status = 0 AND p.color_id = req2_c.color_id AND req2_c.color_id IN ('TDHT') AND req2_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('1912C') 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 ('4012') AND req1_sa.status = 0 AND req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.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, sci_attribute opt1_scia, color req2_c, style req2_s, style_attribute req1_sa, color_attribute req1_ca, ( color c, style s, marketing_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 = '648') 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','8904') AND opt1_ba.status = 0 AND p.style_id = opt1_scia.style_id AND p.color_id = opt1_scia.color_id AND p.identifier_id = opt1_scia.identifier_id AND opt1_scia.sci_attribute_id IN ('4503','4550','4560') AND opt1_scia.status = 0 AND p.color_id = req2_c.color_id AND req2_c.color_id IN ('TDHT') AND req2_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('1912C') 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 ('4012') AND req1_sa.status = 0 AND req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.status = 0 AND p.style_id = '1912C' 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, sci_attribute opt1_scia, color req2_c, style req2_s, style_attribute req1_sa, color_attribute req1_ca, ( color c, style s, marketing_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 = '648') 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','8904') AND opt1_ba.status = 0 AND p.style_id = opt1_scia.style_id AND p.color_id = opt1_scia.color_id AND p.identifier_id = opt1_scia.identifier_id AND opt1_scia.sci_attribute_id IN ('4503','4550','4560') AND opt1_scia.status = 0 AND p.color_id = req2_c.color_id AND req2_c.color_id IN ('TDHT') AND req2_c.status = 0 AND p.style_id = req2_s.style_id AND req2_s.style_id IN ('1912C') 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 ('4012') AND req1_sa.status = 0 AND req1_ca.color_group_id = '30' AND p.color_id = req1_ca.color_id AND req1_ca.color_attribute_id IN ('3010') AND req1_ca.status = 0 AND p.style_id = '1912C' 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! Exiting Search in BaseSearch =============================================================================================== !! Searching with category returned nothing; doing it again with category=0; RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 1912C szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: TDHT szFilterType: required 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, marketing_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 = '648') 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 ( [style_id] => Array ( [0] => 1912C ) [color_id] => Array ( [0] => TDHT ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=style_id value= 1912C 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 req1_s, ( color c, style s, marketing_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 = '648') WHERE p.style_id = req1_s.style_id AND req1_s.style_id IN ('1912C') AND req1_s.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= TDHT 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 req1_s, ( color c, style s, marketing_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 = '648') WHERE p.color_id = req1_c.color_id AND req1_c.color_id IN ('TDHT') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('1912C') AND req1_s.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: | | 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 req1_s, ( color c, style s, marketing_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 = '648') WHERE p.color_id = req1_c.color_id AND req1_c.color_id IN ('TDHT') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('1912C') AND req1_s.status = 0 AND p.style_id = '1912C' 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.0093810558319092 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: apparel