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

Envision Glazes

by Duncan


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754269959
barcode_type UPC
col1 apple green
col1_sortorder 175
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 143-164-77.jpg
cost 2.06
deal_of_the_week NO
description apple green, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 59255
list_price 4.5
map NO
mfr_num IN1639-4 26995
net_weight 0.43
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 59255
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 59255
2 IN1639-4 26995
3 apple green, translucent, 4 oz.
timestamp 2015-03-27T14:47:35.263Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754998057
barcode_type UPC
col1 aqua fresca
col1_sortorder 189
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 77-158-210.jpg
cost 2.06
deal_of_the_week NO
description aqua fresca, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 45313
list_price 4.5
map NO
mfr_num IN1056-4 99805
net_weight 0.42
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 45313
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 45313
2 IN1056-4 99805
3 aqua fresca, opaque, 4 oz.
timestamp 2015-03-27T14:47:18.352Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754269928
barcode_type UPC
col1 autumn
col1_sortorder 259
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 104-47-47.jpg
cost 2.06
deal_of_the_week NO
description autumn, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 59252
list_price 4.5
map NO
mfr_num IN1603-4 26992
net_weight 0.42
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 59252
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 59252
2 IN1603-4 26992
3 autumn, translucent, 4 oz.
timestamp 2015-03-27T14:47:35.251Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754812728
barcode_type UPC
col1 baby blue
col1_sortorder 290
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 77-143-255.jpg
cost 2.06
deal_of_the_week NO
description baby blue, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 29387
list_price 4.5
map NO
mfr_num IN1064-4 81272
net_weight 0.45
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 29387
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 29387
2 IN1064-4 81272
3 baby blue, translucent, 4 oz.
timestamp 2015-03-27T14:46:53.306Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754812803
barcode_type UPC
col1 baroque gold
col1_sortorder 336
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 195-140-47.jpg
cost 2.06
deal_of_the_week NO
description baroque gold, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 85467
list_price 4.5
map NO
mfr_num IN1072-4 81280
net_weight 0.45
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 85467
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 85467
2 IN1072-4 81280
3 baroque gold, opaque, 4 oz.
timestamp 2015-03-27T14:48:16.557Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754269935
barcode_type UPC
col1 black
col1_sortorder 402
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 0-0-0.jpg
cost 2.06
deal_of_the_week NO
description black, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 59253
list_price 4.5
map NO
mfr_num IN1613-4 26993
net_weight 0.42
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 59253
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 59253
2 IN1613-4 26993
3 black, opaque, 4 oz.
timestamp 2015-03-27T14:47:35.254Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754812742
barcode_type UPC
col1 blueberry spice
col1_sortorder 552
col2 translucent speckled
col2_sortorder 10
col3 4 oz.
col3_sortorder 1804
color_swatch 47-94-240.jpg
cost 2.06
deal_of_the_week NO
description blueberry spice, translucent speckled, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 19457
list_price 4.5
map NO
mfr_num IN1066-4 81274
net_weight 0.45
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 19457
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 19457
2 IN1066-4 81274
3 blueberry spice, translucent speckled, 4 oz.
timestamp 2015-03-27T14:46:39.626Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754980472
barcode_type UPC
col1 blue bonnet
col1_sortorder 555
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 0-120-210.jpg
cost 2.06
deal_of_the_week NO
description blue bonnet, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 20854
list_price 4.5
map NO
mfr_num IN1033-4 98047
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 20854
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 20854
2 IN1033-4 98047
3 blue bonnet, translucent, 4 oz.
timestamp 2015-03-27T14:46:41.031Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754980502
barcode_type UPC
col1 bluegrass
col1_sortorder 566
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 0-119-119.jpg
cost 2.06
deal_of_the_week NO
description bluegrass, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 23072
list_price 4.5
map NO
mfr_num IN1036-4 98050
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 23072
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 23072
2 IN1036-4 98050
3 bluegrass, translucent, 4 oz.
timestamp 2015-03-27T14:46:44.122Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754269966
barcode_type UPC
col1 bottle green
col1_sortorder 665
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 92-149-110.jpg
cost 2.06
deal_of_the_week NO
description bottle green, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 59256
list_price 4.5
map NO
mfr_num IN1669-4 26996
net_weight 0.43
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 59256
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 59256
2 IN1669-4 26996
3 bottle green, translucent, 4 oz.
timestamp 2015-03-27T14:47:35.268Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754811912
barcode_type UPC
col1 bright wine
col1_sortorder 744
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 164-0-62.jpg
cost 2.06
deal_of_the_week NO
description bright wine, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 72042
list_price 4.5
map NO
mfr_num IN1060-4 81191
net_weight 0.42
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 72042
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 72042
2 IN1060-4 81191
3 bright wine, opaque, 4 oz.
timestamp 2015-03-27T14:48:01.015Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754976666
barcode_type UPC
col1 butter toffee
col1_sortorder 898
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 149-102-47.jpg
cost 2.06
deal_of_the_week NO
description butter toffee, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 28813
list_price 4.5
map NO
mfr_num IN1023-4 97666
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 28813
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 28813
2 IN1023-4 97666
3 butter toffee, translucent, 4 oz.
timestamp 2015-03-27T14:46:52.493Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754913272
barcode_type UPC
col1 caramel
col1_sortorder 1094
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 195-168-138.jpg
cost 2.06
deal_of_the_week NO
description caramel, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 53266
list_price 4.5
map NO
mfr_num IN1667-4 91327
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 53266
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 53266
2 IN1667-4 91327
3 caramel, translucent, 4 oz.
timestamp 2015-03-27T14:47:28.393Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754976772
barcode_type UPC
col1 Caribbean blue
col1_sortorder 1103
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 77-158-210.jpg
cost 2.06
deal_of_the_week NO
description Caribbean blue, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 74810
list_price 4.5
map NO
mfr_num IN1015-4 97677
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 74810
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 74810
2 IN1015-4 97677
3 Caribbean blue, translucent, 4 oz.
timestamp 2015-03-27T14:48:05.002Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754976727
barcode_type UPC
col1 carnation pink
col1_sortorder 1120
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 240-183-196.jpg
cost 2.06
deal_of_the_week NO
description carnation pink, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 45049
list_price 4.5
map NO
mfr_num IN1007-4 97672
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 45049
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 45049
2 IN1007-4 97672
3 carnation pink, opaque, 4 oz.
timestamp 2015-03-27T14:47:18.011Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754976635
barcode_type UPC
col1 celadon
col1_sortorder 1140
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 199-210-168.jpg
cost 2.06
deal_of_the_week NO
description celadon, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 54452
list_price 4.5
map NO
mfr_num IN1018-4 97663
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 54452
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 54452
2 IN1018-4 97663
3 celadon, translucent, 4 oz.
timestamp 2015-03-27T14:47:29.127Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754976741
barcode_type UPC
col1 cherry red
col1_sortorder 1202
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 164-0-90.jpg
cost 2.06
deal_of_the_week NO
description cherry red, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 86089
list_price 4.5
map NO
mfr_num IN1009-4 97674
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 86089
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 86089
2 IN1009-4 97674
3 cherry red, translucent, 4 oz.
timestamp 2015-03-27T14:48:17.775Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754812902
barcode_type UPC
col1 chocolate brown
col1_sortorder 1222
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 0-42-74.jpg
cost 2.06
deal_of_the_week NO
description chocolate brown, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 38946
list_price 4.5
map NO
mfr_num IN1082-4 81290
net_weight 0.45
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 38946
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 38946
2 IN1082-4 81290
3 chocolate brown, opaque, 4 oz.
timestamp 2015-03-27T14:47:11.175Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754974044
barcode_type UPC
col1 clear
col1_sortorder 1318
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
cost 1.23
deal_of_the_week NO
description clear, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 24742
list_price 2.7
map NO
mfr_num IN1001-4 97404
net_weight 0.4
non_member_discount 20
non_member_price 2.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 24742
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.62
ta_dealer_c_price 1.35
ta_price 2.7
text
array
1 24742
2 IN1001-4 97404
3 clear, translucent, 4 oz.
timestamp 2015-03-27T14:46:46.111Z
vip_member_price 1.89

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754974068
barcode_type UPC
col1 clear
col1_sortorder 1318
col2 translucent
col2_sortorder 9
col3 128 oz.
col3_sortorder 893
cost 15.69
deal_of_the_week NO
description clear, translucent, 128 oz.
group_id 1048
group_uname duncan-envision-glazes
id 29518
list_price 30.25
map NO
mfr_num IN1001-28 97406
net_weight 12.8
non_member_discount 20
non_member_price 24.2
prop65 NO
ship_rule_desc STD
shipping STD
sku 29518
sku_pix YES
supplier_id 1
ta_dealer_a_price 21.18
ta_dealer_c_price 17.24
ta_price 30.25
text
array
1 29518
2 IN1001-28 97406
3 clear, translucent, 128 oz.
timestamp 2015-03-27T14:46:53.461Z
vip_member_price 21.18

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754974051
barcode_type UPC
col1 clear
col1_sortorder 1318
col2 translucent
col2_sortorder 9
col3 16 oz.
col3_sortorder 1008
cost 4.47
deal_of_the_week NO
description clear, translucent, 16 oz.
group_id 1048
group_uname duncan-envision-glazes
id 48616
list_price 8.6
map NO
mfr_num IN1001-16 97405
net_weight 1.6
non_member_discount 20
non_member_price 6.88
prop65 NO
ship_rule_desc STD
shipping STD
sku 48616
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.02
ta_dealer_c_price 4.9
ta_price 6.45
text
array
1 48616
2 IN1001-16 97405
3 clear, translucent, 16 oz.
timestamp 2015-03-27T14:47:23.047Z
vip_member_price 6.02

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754912749
barcode_type UPC
col1 clear black
col1_sortorder 1320
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 135-135-135.jpg
cost 2.06
deal_of_the_week NO
description clear black, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 14997
list_price 4.5
map NO
mfr_num IN1627-4 91274
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 14997
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 14997
2 IN1627-4 91274
3 clear black, translucent, 4 oz.
timestamp 2015-03-27T14:46:33.039Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754998071
barcode_type UPC
col1 clover
col1_sortorder 1342
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 77-210-119.jpg
cost 2.06
deal_of_the_week NO
description clover, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 46954
list_price 4.5
map NO
mfr_num IN1058-4 99807
net_weight 0.42
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 46954
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 46954
2 IN1058-4 99807
3 clover, opaque, 4 oz.
timestamp 2015-03-27T14:47:21.267Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754812834
barcode_type UPC
col1 cobalt blue
col1_sortorder 1352
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 0-0-164.jpg
cost 2.06
deal_of_the_week NO
description cobalt blue, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 47258
list_price 4.5
map NO
mfr_num IN1075-4 81283
net_weight 0.45
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 47258
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 47258
2 IN1075-4 81283
3 cobalt blue, opaque, 4 oz.
timestamp 2015-03-27T14:47:21.525Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754812896
barcode_type UPC
col1 cocoa
col1_sortorder 1407
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 119-60-0.jpg
cost 2.06
deal_of_the_week NO
description cocoa, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 87488
list_price 4.5
map NO
mfr_num IN1081-4 81289
net_weight 0.45
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 87488
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 87488
2 IN1081-4 81289
3 cocoa, opaque, 4 oz.
timestamp 2015-03-27T14:48:19.42Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754980441
barcode_type UPC
col1 cornmeal
col1_sortorder 1555
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 240-202-138.jpg
cost 2.06
deal_of_the_week NO
description cornmeal, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 29547
list_price 4.5
map NO
mfr_num IN1030-4 98044
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 29547
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 29547
2 IN1030-4 98044
3 cornmeal, opaque, 4 oz.
timestamp 2015-03-27T14:46:53.489Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754812827
barcode_type UPC
col1 cranberry
col1_sortorder 1587
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 195-47-47.jpg
cost 2.06
deal_of_the_week NO
description cranberry, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 66881
list_price 4.5
map NO
mfr_num IN1074-4 81282
net_weight 0.45
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 66881
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 66881
2 IN1074-4 81282
3 cranberry, opaque, 4 oz.
timestamp 2015-03-27T14:47:49.587Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754985682
barcode_type UPC
col1 delphinium
col1_sortorder 1846
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 77-120-255.jpg
cost 2.06
deal_of_the_week NO
description delphinium, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 28852
list_price 4.5
map NO
mfr_num IN1048-4 98568
net_weight 0.42
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 28852
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 28852
2 IN1048-4 98568
3 delphinium, opaque, 4 oz.
timestamp 2015-03-27T14:46:52.531Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754976611
barcode_type UPC
col1 denim blue
col1_sortorder 1851
col2 translucent
col2_sortorder 9
col3 4 oz.
col3_sortorder 1804
color_swatch 122-122-255.jpg
cost 2.06
deal_of_the_week NO
description denim blue, translucent, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 51006
list_price 4.5
map NO
mfr_num IN1013-4 97661
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 51006
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 51006
2 IN1013-4 97661
3 denim blue, translucent, 4 oz.
timestamp 2015-03-27T14:47:25.202Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754913111
barcode_type UPC
col1 downright white
col1_sortorder 1930
col2 opaque
col2_sortorder 4
col3 16 oz.
col3_sortorder 1008
color_swatch 223-213-255.jpg
cost 6.98
deal_of_the_week NO
description downright white, opaque, 16 oz.
group_id 1048
group_uname duncan-envision-glazes
id 39305
list_price 13.45
map NO
mfr_num IN1653-16 91311
net_weight 1.6
non_member_discount 20
non_member_price 10.76
prop65 NO
ship_rule_desc STD
shipping STD
sku 39305
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.42
ta_dealer_c_price 7.67
ta_price 10.09
text
array
1 39305
2 IN1653-16 91311
3 downright white, opaque, 16 oz.
timestamp 2015-03-27T14:47:11.607Z
vip_member_price 9.42

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754913104
barcode_type UPC
col1 downright white
col1_sortorder 1930
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 223-213-255.jpg
cost 2.06
deal_of_the_week NO
description downright white, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 71882
list_price 4.5
map NO
mfr_num IN1653-4 91310
net_weight 0.4
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 71882
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 71882
2 IN1653-4 91310
3 downright white, opaque, 4 oz.
timestamp 2015-03-27T14:48:00.763Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0303abcdb1a5aa022d2c7562607d3340878
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=sort~1~fp~0-7~&gr=art-institute-glitter-designer-dries-white-adhesive.html
urltoken CFID=29759246&CFTOKEN=81745783&jsessionid=e0303abcdb1a5aa022d2c7562607d3340878
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 19:00:32'}
sessionid e0301e462a359abd7d134234d5b2377c1a5b
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html
urltoken CFID=29759247&CFTOKEN=80488517&jsessionid=e0301e462a359abd7d134234d5b2377c1a5b
validationerror [empty string]


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

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

ItemIDList: 62823
AvailQtyList: 5.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 017754985637
barcode_type UPC
col1 driftwood
col1_sortorder 1940
col2 opaque
col2_sortorder 4
col3 4 oz.
col3_sortorder 1804
color_swatch 153-122-164.jpg
cost 2.06
deal_of_the_week NO
description driftwood, opaque, 4 oz.
group_id 1048
group_uname duncan-envision-glazes
id 70811
list_price 4.5
map NO
mfr_num IN1043-4 98563
net_weight 0.42
non_member_discount 20
non_member_price 3.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 70811
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.7
ta_dealer_c_price 2.25
ta_price 4.5
text
array
1 70811
2 IN1043-4 98563
3 driftwood, opaque, 4 oz.
timestamp 2015-03-27T14:47:57.525Z
vip_member_price 3.15

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 5.000000000000 62823
CACHED false
EXECUTIONTIME 3
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] = '8213' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=ceramics&catB=glaze-under-glaze&CatC=fp~0-2~&gr=duncan-envision-glazes.html

StartSessionVariables:
str