#1 Place for Craft Supplies, Art Supplies, Artist Materials and Kids Crafts

Concepts Underglaze

by Duncan


Problem with item sku 66786. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754286390
barcode_type UPC
col1 aqua sprinkles
col1_sortorder 188
col2 CN519
col2_sortorder 1397
col3 2 oz.
col3_sortorder 1211
color_swatch 69-184-231.jpg
cost 1.67
deal_of_the_week NO
description aqua sprinkles, CN519, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 66786
list_price 3.65
map NO
mfr_num CN519-2 28639
net_weight 0.22
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 66786
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 66786
2 CN519-2 28639
3 aqua sprinkles, CN519, 2 oz.
timestamp 2015-03-31T17:54:11.473Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 37282. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988522
barcode_type UPC
col1 black
col1_sortorder 402
col2 CN253
col2_sortorder 1354
col3 2 oz.
col3_sortorder 1211
color_swatch 0-0-0.jpg
cost 1.67
deal_of_the_week NO
description black, CN253, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 37282
list_price 3.65
map NO
mfr_num CN253-2 98852
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 37282
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 37282
2 CN253-2 98852
3 black, CN253, 2 oz.
timestamp 2015-03-31T17:53:20.666Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 66890. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754286451
barcode_type UPC
col1 black sprinkles
col1_sortorder 485
col2 CN525
col2_sortorder 1403
col3 2 oz.
col3_sortorder 1211
color_swatch 0-0-0.jpg
cost 1.67
deal_of_the_week NO
description black sprinkles, CN525, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 66890
list_price 3.65
map NO
mfr_num CN525-2 28645
net_weight 0.23
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 66890
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 66890
2 CN525-2 28645
3 black sprinkles, CN525, 2 oz.
timestamp 2015-03-31T17:54:11.681Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 66799. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754286444
barcode_type UPC
col1 briarwood sprinkles
col1_sortorder 679
col2 CN524
col2_sortorder 1402
col3 2 oz.
col3_sortorder 1211
color_swatch 117-41-18.jpg
cost 1.67
deal_of_the_week NO
description briarwood sprinkles, CN524, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 66799
list_price 3.65
map NO
mfr_num CN524-2 28644
net_weight 0.21
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 66799
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 66799
2 CN524-2 28644
3 briarwood sprinkles, CN524, 2 oz.
timestamp 2015-03-31T17:54:11.518Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 55963. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988423
barcode_type UPC
col1 bright aqua
col1_sortorder 687
col2 CN142
col2_sortorder 1328
col3 2 oz.
col3_sortorder 1211
color_swatch 64-129-183.jpg
cost 1.67
deal_of_the_week NO
description bright aqua, CN142, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 55963
list_price 3.65
map NO
mfr_num CN142S-2 98842
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 55963
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 55963
2 CN142S-2 98842
3 bright aqua, CN142, 2 oz.
timestamp 2015-03-31T17:53:49.188Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 78043. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988683
barcode_type UPC
col1 bright blue spruce
col1_sortorder 694
col2 CN152
col2_sortorder 1330
col3 2 oz.
col3_sortorder 1211
color_swatch 83-113-113.jpg
cost 1.67
deal_of_the_week NO
description bright blue spruce, CN152, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 78043
list_price 3.65
map NO
mfr_num CN152S-2 98868
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 78043
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 78043
2 CN152S-2 98868
3 bright blue spruce, CN152, 2 oz.
timestamp 2015-03-31T17:54:30.597Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 89188. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988508
barcode_type UPC
col1 bright blush
col1_sortorder 695
col2 CN222
col2_sortorder 1349
col3 2 oz.
col3_sortorder 1211
color_swatch 219-177-163.jpg
cost 1.67
deal_of_the_week NO
description bright blush, CN222, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 89188
list_price 3.65
map NO
mfr_num CN222-2 98850
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 89188
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 89188
2 CN222-2 98850
3 bright blush, CN222, 2 oz.
timestamp 2015-03-31T17:54:42.6Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 34633. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988492
barcode_type UPC
col1 bright briarwood
col1_sortorder 696
col2 CN232
col2_sortorder 1350
col3 2 oz.
col3_sortorder 1211
color_swatch 70-34-22.jpg
cost 1.67
deal_of_the_week NO
description bright briarwood, CN232, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 34633
list_price 3.65
map NO
mfr_num CN232-2 98849
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 34633
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 34633
2 CN232-2 98849
3 bright briarwood, CN232, 2 oz.
timestamp 2015-03-31T17:53:16.525Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 13645. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754802361
barcode_type UPC
col1 bright brown
col1_sortorder 697
col2 CN282
col2_sortorder 1361
col3 2 oz.
col3_sortorder 1211
color_swatch 89-55-46.jpg
cost 1.67
deal_of_the_week NO
description bright brown, CN282, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 13645
list_price 3.65
map NO
mfr_num CN282S-2 80236
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 13645
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 13645
2 CN282S-2 80236
3 bright brown, CN282, 2 oz.
timestamp 2015-03-31T17:52:40.727Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 38202. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988348
barcode_type UPC
col1 bright butternut
col1_sortorder 698
col2 CN032
col2_sortorder 1298
col3 2 oz.
col3_sortorder 1211
color_swatch 228-147-55.jpg
cost 1.67
deal_of_the_week NO
description bright butternut, CN032, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 38202
list_price 3.65
map NO
mfr_num CN032-2 98834
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 38202
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 38202
2 CN032-2 98834
3 bright butternut, CN032, 2 oz.
timestamp 2015-03-31T17:53:21.882Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 77692. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754802538
barcode_type UPC
col1 bright Caribbean
col1_sortorder 699
col2 CN302
col2_sortorder 1365
col3 2 oz.
col3_sortorder 1211
color_swatch 34-136-148.jpg
cost 1.67
deal_of_the_week NO
description bright Caribbean, CN302, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 77692
list_price 3.65
map NO
mfr_num CN302S-2 80253
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 77692
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 77692
2 CN302S-2 80253
3 bright Caribbean, CN302, 2 oz.
timestamp 2015-03-31T17:54:29.972Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 20559. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988409
barcode_type UPC
col1 bright delft
col1_sortorder 702
col2 CN112
col2_sortorder 1319
col3 2 oz.
col3_sortorder 1211
color_swatch 66-69-140.jpg
cost 1.67
deal_of_the_week NO
description bright delft, CN112, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 20559
list_price 3.65
map NO
mfr_num CN112-2 98840
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 20559
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 20559
2 CN112-2 98840
3 bright delft, CN112, 2 oz.
timestamp 2015-03-31T17:52:54.129Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 28460. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754813831
barcode_type UPC
col1 bright ginger
col1_sortorder 703
col2 CN312
col2_sortorder 1367
col3 2 oz.
col3_sortorder 1211
color_swatch 166-112-50.jpg
cost 1.67
deal_of_the_week NO
description bright ginger, CN312, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 28460
list_price 3.65
map NO
mfr_num CN312-2 81383
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 28460
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 28460
2 CN312-2 81383
3 bright ginger, CN312, 2 oz.
timestamp 2015-03-31T17:53:05.487Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 54922. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754804501
barcode_type UPC
col1 bright grape
col1_sortorder 707
col2 CN262
col2_sortorder 1356
col3 2 oz.
col3_sortorder 1211
color_swatch 82-65-110.jpg
cost 1.67
deal_of_the_week NO
description bright grape, CN262, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 54922
list_price 3.65
map NO
mfr_num CN262S-2 80450
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 54922
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 54922
2 CN262S-2 80450
3 bright grape, CN262, 2 oz.
timestamp 2015-03-31T17:53:48.095Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 16450. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988706
barcode_type UPC
col1 bright gray
col1_sortorder 708
col2 CN202
col2_sortorder 1342
col3 2 oz.
col3_sortorder 1211
color_swatch 101-105-104.jpg
cost 1.67
deal_of_the_week NO
description bright gray, CN202, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 16450
list_price 3.65
map NO
mfr_num CN202S-2 98870
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 16450
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 16450
2 CN202S-2 98870
3 bright gray, CN202, 2 oz.
timestamp 2015-03-31T17:52:47.633Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 39196. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988393
barcode_type UPC
col1 bright heather
col1_sortorder 711
col2 CN102
col2_sortorder 1316
col3 2 oz.
col3_sortorder 1211
color_swatch 87-80-148.jpg
cost 1.67
deal_of_the_week NO
description bright heather, CN102, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 39196
list_price 3.65
map NO
mfr_num CN102-2 98839
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 39196
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 39196
2 CN102-2 98839
3 bright heather, CN102, 2 oz.
timestamp 2015-03-31T17:53:23.358Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 69645. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754296450
barcode_type UPC
col1 bright honeysuckle
col1_sortorder 712
col2 CN372
col2_sortorder 1377
col3 2 oz.
col3_sortorder 1211
color_swatch 244-115-110.jpg
cost 1.67
deal_of_the_week NO
description bright honeysuckle, CN372, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 69645
list_price 3.65
map NO
mfr_num CN372-2 29645
net_weight 0.22
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 69645
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 69645
2 CN372-2 29645
3 bright honeysuckle, CN372, 2 oz.
timestamp 2015-03-31T17:54:17.176Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 54559. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754802323
barcode_type UPC
col1 bright jade
col1_sortorder 713
col2 CN272
col2_sortorder 1359
col3 2 oz.
col3_sortorder 1211
color_swatch 74-140-104.jpg
cost 1.67
deal_of_the_week NO
description bright jade, CN272, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 54559
list_price 3.65
map NO
mfr_num CN272S-2 80232
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 54559
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 54559
2 CN272S-2 80232
3 bright jade, CN272, 2 oz.
timestamp 2015-03-31T17:53:47.771Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 38311. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988881
barcode_type UPC
col1 bright kelp
col1_sortorder 714
col2 CN172
col2_sortorder 1336
col3 2 oz.
col3_sortorder 1211
color_swatch 48-73-41.jpg
cost 1.67
deal_of_the_week NO
description bright kelp, CN172, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 38311
list_price 3.65
map NO
mfr_num CN172S-2 98888
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 38311
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 38311
2 CN172S-2 98888
3 bright kelp, CN172, 2 oz.
timestamp 2015-03-31T17:53:21.958Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 15948. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988898
barcode_type UPC
col1 bright kiwi
col1_sortorder 715
col2 CN182
col2_sortorder 1339
col3 2 oz.
col3_sortorder 1211
color_swatch 42-101-44.jpg
cost 1.67
deal_of_the_week NO
description bright kiwi, CN182, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 15948
list_price 3.65
map NO
mfr_num CN182S-2 98889
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 15948
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 15948
2 CN182S-2 98889
3 bright kiwi, CN182, 2 oz.
timestamp 2015-03-31T17:52:47.15Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 79315. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988836
barcode_type UPC
col1 bright nautical
col1_sortorder 720
col2 CN122
col2_sortorder 1322
col3 2 oz.
col3_sortorder 1211
color_swatch 42-47-102.jpg
cost 1.67
deal_of_the_week NO
description bright nautical, CN122, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 79315
list_price 3.65
map NO
mfr_num CN122S-2 98883
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 79315
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 79315
2 CN122S-2 98883
3 bright nautical, CN122, 2 oz.
timestamp 2015-03-31T17:54:32.255Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 72676. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754813893
barcode_type UPC
col1 bright olive
col1_sortorder 721
col2 CN332
col2_sortorder 1371
col3 2 oz.
col3_sortorder 1211
color_swatch 135-128-58.jpg
cost 1.67
deal_of_the_week NO
description bright olive, CN332, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 72676
list_price 3.65
map NO
mfr_num CN332-2 81389
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 72676
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 72676
2 CN332-2 81389
3 bright olive, CN332, 2 oz.
timestamp 2015-03-31T17:54:23.869Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 28367. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988768
barcode_type UPC
col1 bright papaya
col1_sortorder 724
col2 CN042
col2_sortorder 1301
col3 2 oz.
col3_sortorder 1211
color_swatch 214-104-41.jpg
cost 1.67
deal_of_the_week NO
description bright papaya, CN042, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 28367
list_price 3.65
map NO
mfr_num CN042S-2 98876
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 28367
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 28367
2 CN042S-2 98876
3 bright papaya, CN042, 2 oz.
timestamp 2015-03-31T17:53:05.429Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 30098. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754243324
barcode_type UPC
col1 bright pink
col1_sortorder 726
col2 CN342
col2_sortorder 1374
col3 2 oz.
col3_sortorder 1211
color_swatch 241-158-151.jpg
cost 1.67
deal_of_the_week NO
description bright pink, CN342, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 30098
list_price 3.65
map NO
mfr_num CN342-2 24332
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 30098
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 30098
2 CN342-2 24332
3 bright pink, CN342, 2 oz.
timestamp 2015-03-31T17:53:07.467Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 25742. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754813862
barcode_type UPC
col1 bright plum
col1_sortorder 727
col2 CN322
col2_sortorder 1369
col3 2 oz.
col3_sortorder 1211
color_swatch 62-26-52.jpg
cost 1.54
deal_of_the_week NO
description bright plum, CN322, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 25742
list_price 3.35
map NO
mfr_num CN322-2 81386
net_weight 0.11
non_member_discount 20
non_member_price 2.68
prop65 NO
ship_rule_desc STD
shipping STD
sku 25742
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.01
ta_dealer_c_price 1.68
ta_price 3.35
text
array
1 25742
2 CN322-2 81386
3 bright plum, CN322, 2 oz.
timestamp 2015-03-31T17:53:01.858Z
vip_member_price 2.35

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 33851. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754804495
barcode_type UPC
col1 bright purple
col1_sortorder 728
col2 CN292
col2_sortorder 1363
col3 2 oz.
col3_sortorder 1211
color_swatch 90-63-108.jpg
cost 1.67
deal_of_the_week NO
description bright purple, CN292, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 33851
list_price 3.65
map NO
mfr_num CN292S-2 80449
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 33851
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 33851
2 CN292S-2 80449
3 bright purple, CN292, 2 oz.
timestamp 2015-03-31T17:53:15.686Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 29679. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988744
barcode_type UPC
col1 bright saffron
col1_sortorder 733
col2 CN022
col2_sortorder 1296
col3 2 oz.
col3_sortorder 1211
color_swatch 228-166-23.jpg
cost 1.67
deal_of_the_week NO
description bright saffron, CN022, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 29679
list_price 3.65
map NO
mfr_num CN022S-2 98874
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 29679
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 29679
2 CN022S-2 98874
3 bright saffron, CN022, 2 oz.
timestamp 2015-03-31T17:53:07.161Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 62413. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988799
barcode_type UPC
col1 bright salsa
col1_sortorder 734
col2 CN062
col2_sortorder 1306
col3 2 oz.
col3_sortorder 1211
color_swatch 207-83-45.jpg
cost 1.67
deal_of_the_week NO
description bright salsa, CN062, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 62413
list_price 3.65
map NO
mfr_num CN062S-2 98879
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 62413
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 62413
2 CN062S-2 98879
3 bright salsa, CN062, 2 oz.
timestamp 2015-03-31T17:54:03.385Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 52559. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988362
barcode_type UPC
col1 bright scarlet
col1_sortorder 735
col2 CN072
col2_sortorder 1309
col3 2 oz.
col3_sortorder 1211
color_swatch 190-66-54.jpg
cost 1.67
deal_of_the_week NO
description bright scarlet, CN072, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 52559
list_price 3.65
map NO
mfr_num CN072-2 98836
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 52559
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 52559
2 CN072-2 98836
3 bright scarlet, CN072, 2 oz.
timestamp 2015-03-31T17:53:45.412Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 25265. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988331
barcode_type UPC
col1 bright straw
col1_sortorder 737
col2 CN012
col2_sortorder 1293
col3 2 oz.
col3_sortorder 1211
color_swatch 237-237-51.jpg
cost 1.67
deal_of_the_week NO
description bright straw, CN012, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 25265
list_price 3.65
map NO
mfr_num CN012-2 98833
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 25265
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 25265
2 CN012-2 98833
3 bright straw, CN012, 2 oz.
timestamp 2015-03-31T17:53:01.314Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 52118. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988355
barcode_type UPC
col1 bright tangerine
col1_sortorder 738
col2 CN052
col2_sortorder 1303
col3 2 oz.
col3_sortorder 1211
color_swatch 213-84-53.jpg
cost 1.67
deal_of_the_week NO
description bright tangerine, CN052, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 52118
list_price 3.65
map NO
mfr_num CN052-2 98835
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 52118
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 52118
2 CN052-2 98835
3 bright tangerine, CN052, 2 oz.
timestamp 2015-03-31T17:53:38.962Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 08:45:15'}
sessionid e0306ad9ade257581f2d24495429477b5c39
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html
urltoken CFID=30748437&CFTOKEN=74125140&jsessionid=e0306ad9ade257581f2d24495429477b5c39
validationerror [empty string]


Problem with item sku 46424. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a7636 7636&wt=json&indent=on&fl=*&rows=1000&fq=group_id:7636&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 56891
AvailQtyList: 10.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754988713
barcode_type UPC
col1 bright taupe
col1_sortorder 739
col2 CN212
col2_sortorder 1346
col3 2 oz.
col3_sortorder 1211
color_swatch 120-116-104.jpg
cost 1.67
deal_of_the_week NO
description bright taupe, CN212, 2 oz.
group_id 7636
group_uname duncan-concepts-underglaze
id 46424
list_price 3.65
map NO
mfr_num CN212S-2 98871
net_weight 0.11
non_member_discount 20
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 46424
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.19
ta_dealer_c_price 1.83
ta_price 3.65
text
array
1 46424
2 CN212S-2 98871
3 bright taupe, CN212, 2 oz.
timestamp 2015-03-31T17:53:31.866Z
vip_member_price 2.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 10.000000000000 56891
CACHED false
EXECUTIONTIME 15
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '5386' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.161.234.150

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fb~duncan~&gr=duncan-concepts-underglaze.html

StartSessionVariables: