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

Galeria Flow Formula Acrylic Colours

by Winsor & Newton


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 094376985528
barcode_type UPC
col1 buff titanium
col1_sortorder 846
col2 60 ml
col2_sortorder 2156
col3 60
col3_sortorder 202
color_swatch 210-191-122.jpg
cost 2
deal_of_the_week NO
description buff titanium, 60 ml, 60
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 64506
list_price 4.69
map NO
mfr_num 2120060
net_weight 0.2
non_member_discount 35
non_member_price 3.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 64506
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.05
text
array
1 64506
2 2120060
3 buff titanium, 60 ml, 60
timestamp 2015-03-27T14:47:44.965Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 094376971538
barcode_type UPC
col1 burgundy
col1_sortorder 849
col2 60 ml
col2_sortorder 2156
col3 75
col3_sortorder 217
color_swatch 104-47-72.jpg
cost 2
deal_of_the_week NO
description burgundy, 60 ml, 75
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 22170
list_price 4.69
map NO
mfr_num 2120075
net_weight 0.2
non_member_discount 35
non_member_price 3.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 22170
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.05
text
array
1 22170
2 2120075
3 burgundy, 60 ml, 75
timestamp 2015-03-27T14:46:43.124Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 094376913873
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 60 ml
col2_sortorder 2156
col3 74
col3_sortorder 216
color_swatch 195-127-47.jpg
cost 2
deal_of_the_week NO
description burnt sienna, 60 ml, 74
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 65707
list_price 4.69
map NO
mfr_num 2120074
net_weight 0.18
non_member_discount 35
non_member_price 3.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 65707
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.05
text
array
1 65707
2 2120074
3 burnt sienna, 60 ml, 74
timestamp 2015-03-27T14:47:47.294Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376914399
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 500 ml
col2_sortorder 2034
col3 74
col3_sortorder 216
color_swatch 195-127-47.jpg
cost 11.53
deal_of_the_week NO
description burnt sienna, 500 ml, 74
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 73062
list_price 26.99
map NO
mfr_num 2150074
net_weight 1.56
non_member_discount 40
non_member_price 16.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 73062
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.5
ta_dealer_c_price 12.69
ta_price 17.54
text
array
1 73062
2 2150074
3 burnt sienna, 500 ml, 74
timestamp 2015-03-27T14:48:03.23Z
vip_member_price 14.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376914146
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 250 ml
col2_sortorder 1400
col3 74
col3_sortorder 216
color_swatch 195-127-47.jpg
cost 5.76
deal_of_the_week NO
description burnt sienna, 250 ml, 74
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 87545
list_price 13.49
map NO
mfr_num 2137074
net_weight 0.76
non_member_discount 36
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 87545
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.34
ta_price 8.77
text
array
1 87545
2 2137074
3 burnt sienna, 250 ml, 74
timestamp 2015-03-27T14:48:19.745Z
vip_member_price 7.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376940435
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 200 ml
col2_sortorder 1278
col3 74
col3_sortorder 216
color_swatch 195-127-47.jpg
cost 4.7
deal_of_the_week NO
description burnt sienna, 200 ml, 74
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 89360
list_price 10.99
map NO
mfr_num 2136074
net_weight 0.62
non_member_discount 40
non_member_price 6.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 89360
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.5
ta_dealer_c_price 5.17
ta_price 7.14
text
array
1 89360
2 2136074
3 burnt sienna, 200 ml, 74
timestamp 2015-03-27T14:48:23.585Z
vip_member_price 5.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 094376985542
barcode_type UPC
col1 burnt sienna opaque
col1_sortorder 882
col2 60 ml
col2_sortorder 2156
col3 77
col3_sortorder 219
color_swatch 167-77-17.jpg
cost 2
deal_of_the_week NO
description burnt sienna opaque, 60 ml, 77
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 64507
list_price 4.69
map NO
mfr_num 2120077
net_weight 0.2
non_member_discount 35
non_member_price 3.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 64507
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.05
text
array
1 64507
2 2120077
3 burnt sienna opaque, 60 ml, 77
timestamp 2015-03-27T14:47:44.967Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376940442
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 200 ml
col2_sortorder 1278
col3 76
col3_sortorder 218
color_swatch 127-68-0.jpg
cost 4.7
deal_of_the_week NO
description burnt umber, 200 ml, 76
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 45851
list_price 10.99
map NO
mfr_num 2136076
net_weight 0.59
non_member_discount 40
non_member_price 6.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 45851
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.5
ta_dealer_c_price 5.17
ta_price 7.14
text
array
1 45851
2 2136076
3 burnt umber, 200 ml, 76
timestamp 2015-03-27T14:47:19.199Z
vip_member_price 5.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376914405
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 500 ml
col2_sortorder 2034
col3 76
col3_sortorder 218
color_swatch 127-68-0.jpg
cost 11.53
deal_of_the_week NO
description burnt umber, 500 ml, 76
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 74304
list_price 26.99
map NO
mfr_num 2150076
net_weight 1.56
non_member_discount 40
non_member_price 16.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 74304
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.5
ta_dealer_c_price 12.69
ta_price 17.54
text
array
1 74304
2 2150076
3 burnt umber, 500 ml, 76
timestamp 2015-03-27T14:48:04.627Z
vip_member_price 14.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 094376913880
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 60 ml
col2_sortorder 2156
col3 76
col3_sortorder 218
color_swatch 127-68-0.jpg
cost 2
deal_of_the_week NO
description burnt umber, 60 ml, 76
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 83117
list_price 4.69
map NO
mfr_num 2120076
net_weight 0.16
non_member_discount 35
non_member_price 3.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 83117
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.05
text
array
1 83117
2 2120076
3 burnt umber, 60 ml, 76
timestamp 2015-03-27T14:48:13.564Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376914153
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 250 ml
col2_sortorder 1400
col3 76
col3_sortorder 218
color_swatch 127-68-0.jpg
cost 5.76
deal_of_the_week NO
description burnt umber, 250 ml, 76
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 85088
list_price 13.49
map NO
mfr_num 2137076
net_weight 0.76
non_member_discount 36
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 85088
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.34
ta_price 8.77
text
array
1 85088
2 2137076
3 burnt umber, 250 ml, 76
timestamp 2015-03-27T14:48:15.064Z
vip_member_price 7.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376940459
barcode_type UPC
col1 cadmium orange hue
col1_sortorder 947
col2 200 ml
col2_sortorder 1278
col3 90
color_swatch 210-128-0.jpg
cost 4.7
deal_of_the_week NO
description cadmium orange hue, 200 ml, 90
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 35206
list_price 10.99
map NO
mfr_num 2136090
net_weight 0.61
non_member_discount 40
non_member_price 6.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 35206
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.5
ta_dealer_c_price 5.17
ta_price 7.14
text
array
1 35206
2 2136090
3 cadmium orange hue, 200 ml, 90
timestamp 2015-03-27T14:47:05.925Z
vip_member_price 5.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376914412
barcode_type UPC
col1 cadmium orange hue
col1_sortorder 947
col2 500 ml
col2_sortorder 2034
col3 90
color_swatch 210-128-0.jpg
cost 11.53
deal_of_the_week NO
description cadmium orange hue, 500 ml, 90
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 40568
list_price 26.99
map NO
mfr_num 2150090
net_weight 1.56
non_member_discount 40
non_member_price 16.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 40568
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.5
ta_dealer_c_price 12.69
ta_price 17.54
text
array
1 40568
2 2150090
3 cadmium orange hue, 500 ml, 90
timestamp 2015-03-27T14:47:12.691Z
vip_member_price 14.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 094376913897
barcode_type UPC
col1 cadmium orange hue
col1_sortorder 947
col2 60 ml
col2_sortorder 2156
col3 90
color_swatch 210-128-0.jpg
cost 2
deal_of_the_week NO
description cadmium orange hue, 60 ml, 90
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 63826
list_price 4.69
map NO
mfr_num 2120090
net_weight 0.18
non_member_discount 35
non_member_price 3.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 63826
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.05
text
array
1 63826
2 2120090
3 cadmium orange hue, 60 ml, 90
timestamp 2015-03-27T14:47:44.009Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376914160
barcode_type UPC
col1 cadmium orange hue
col1_sortorder 947
col2 250 ml
col2_sortorder 1400
col3 90
color_swatch 210-128-0.jpg
cost 5.76
deal_of_the_week NO
description cadmium orange hue, 250 ml, 90
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 65710
list_price 13.49
map NO
mfr_num 2137090
net_weight 0.76
non_member_discount 36
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 65710
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.34
ta_price 8.77
text
array
1 65710
2 2137090
3 cadmium orange hue, 250 ml, 90
timestamp 2015-03-27T14:47:47.493Z
vip_member_price 7.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376914177
barcode_type UPC
col1 cadmium red hue
col1_sortorder 968
col2 250 ml
col2_sortorder 1400
col3 95
col3_sortorder 226
color_swatch 210-90-0.jpg
cost 5.76
deal_of_the_week NO
description cadmium red hue, 250 ml, 95
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 52012
list_price 13.49
map NO
mfr_num 2137095
net_weight 0.76
non_member_discount 36
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 52012
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.34
ta_price 8.77
text
array
1 52012
2 2137095
3 cadmium red hue, 250 ml, 95
timestamp 2015-03-27T14:47:26.097Z
vip_member_price 7.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376914429
barcode_type UPC
col1 cadmium red hue
col1_sortorder 968
col2 500 ml
col2_sortorder 2034
col3 95
col3_sortorder 226
color_swatch 210-90-0.jpg
cost 11.53
deal_of_the_week NO
description cadmium red hue, 500 ml, 95
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 55253
list_price 26.99
map NO
mfr_num 2150095
net_weight 1.56
non_member_discount 40
non_member_price 16.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 55253
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.5
ta_dealer_c_price 12.69
ta_price 17.54
text
array
1 55253
2 2150095
3 cadmium red hue, 500 ml, 95
timestamp 2015-03-27T14:47:29.851Z
vip_member_price 14.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 094376913903
barcode_type UPC
col1 cadmium red hue
col1_sortorder 968
col2 60 ml
col2_sortorder 2156
col3 95
col3_sortorder 226
color_swatch 210-90-0.jpg
cost 2
deal_of_the_week NO
description cadmium red hue, 60 ml, 95
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 73017
list_price 4.69
map NO
mfr_num 2120095
net_weight 0.18
non_member_discount 35
non_member_price 3.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 73017
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.05
text
array
1 73017
2 2120095
3 cadmium red hue, 60 ml, 95
timestamp 2015-03-27T14:48:03.197Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376940466
barcode_type UPC
col1 cadmium red hue
col1_sortorder 968
col2 200 ml
col2_sortorder 1278
col3 95
col3_sortorder 226
color_swatch 210-90-0.jpg
cost 4.7
deal_of_the_week NO
description cadmium red hue, 200 ml, 95
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 81008
list_price 10.99
map NO
mfr_num 2136095
net_weight 0.62
non_member_discount 40
non_member_price 6.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 81008
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.5
ta_dealer_c_price 5.17
ta_price 7.14
text
array
1 81008
2 2136095
3 cadmium red hue, 200 ml, 95
timestamp 2015-03-27T14:48:11.688Z
vip_member_price 5.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376940480
barcode_type UPC
col1 cadmium yellow deep hue
col1_sortorder 1003
col2 200 ml
col2_sortorder 1278
col3 115
col3_sortorder 247
color_swatch 240-213-47.jpg
cost 4.7
deal_of_the_week NO
description cadmium yellow deep hue, 200 ml, 115
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 33201
list_price 10.99
map NO
mfr_num 2136115
net_weight 0.6
non_member_discount 40
non_member_price 6.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 33201
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.5
ta_dealer_c_price 5.17
ta_price 7.14
text
array
1 33201
2 2136115
3 cadmium yellow deep hue, 200 ml, 115
timestamp 2015-03-27T14:47:02.394Z
vip_member_price 5.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376914443
barcode_type UPC
col1 cadmium yellow deep hue
col1_sortorder 1003
col2 500 ml
col2_sortorder 2034
col3 115
col3_sortorder 247
color_swatch 240-213-47.jpg
cost 11.53
deal_of_the_week NO
description cadmium yellow deep hue, 500 ml, 115
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 50073
list_price 26.99
map NO
mfr_num 2150115
net_weight 1.56
non_member_discount 40
non_member_price 16.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 50073
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.5
ta_dealer_c_price 12.69
ta_price 17.54
text
array
1 50073
2 2150115
3 cadmium yellow deep hue, 500 ml, 115
timestamp 2015-03-27T14:47:24.425Z
vip_member_price 14.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376914191
barcode_type UPC
col1 cadmium yellow deep hue
col1_sortorder 1003
col2 250 ml
col2_sortorder 1400
col3 115
col3_sortorder 247
color_swatch 240-213-47.jpg
cost 5.76
deal_of_the_week NO
description cadmium yellow deep hue, 250 ml, 115
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 59237
list_price 13.49
map NO
mfr_num 2137115
net_weight 0.76
non_member_discount 36
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 59237
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.34
ta_price 8.77
text
array
1 59237
2 2137115
3 cadmium yellow deep hue, 250 ml, 115
timestamp 2015-03-27T14:47:35.217Z
vip_member_price 7.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 094376913927
barcode_type UPC
col1 cadmium yellow deep hue
col1_sortorder 1003
col2 60 ml
col2_sortorder 2156
col3 115
col3_sortorder 247
color_swatch 240-213-47.jpg
cost 2
deal_of_the_week NO
description cadmium yellow deep hue, 60 ml, 115
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 68991
list_price 4.69
map NO
mfr_num 2120115
net_weight 0.18
non_member_discount 35
non_member_price 3.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 68991
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.05
text
array
1 68991
2 2120115
3 cadmium yellow deep hue, 60 ml, 115
timestamp 2015-03-27T14:47:52.901Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376914450
barcode_type UPC
col1 cadmium yellow medium hue
col1_sortorder 1022
col2 500 ml
col2_sortorder 2034
col3 120
col3_sortorder 253
color_swatch 255-242-77.jpg
cost 11.53
deal_of_the_week NO
description cadmium yellow medium hue, 500 ml, 120
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 10445
list_price 26.99
map NO
mfr_num 2150120
net_weight 1.56
non_member_discount 40
non_member_price 16.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 10445
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.5
ta_dealer_c_price 12.69
ta_price 17.54
text
array
1 10445
2 2150120
3 cadmium yellow medium hue, 500 ml, 120
timestamp 2015-03-27T14:46:24.433Z
vip_member_price 14.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 094376913934
barcode_type UPC
col1 cadmium yellow medium hue
col1_sortorder 1022
col2 60 ml
col2_sortorder 2156
col3 120
col3_sortorder 253
color_swatch 255-242-77.jpg
cost 2
deal_of_the_week NO
description cadmium yellow medium hue, 60 ml, 120
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 14575
list_price 4.69
map NO
mfr_num 2120120
net_weight 0.17
non_member_discount 35
non_member_price 3.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 14575
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.05
text
array
1 14575
2 2120120
3 cadmium yellow medium hue, 60 ml, 120
timestamp 2015-03-27T14:46:31.084Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376914207
barcode_type UPC
col1 cadmium yellow medium hue
col1_sortorder 1022
col2 250 ml
col2_sortorder 1400
col3 120
col3_sortorder 253
color_swatch 255-242-77.jpg
cost 5.76
deal_of_the_week NO
description cadmium yellow medium hue, 250 ml, 120
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 32640
list_price 13.49
map NO
mfr_num 2137120
net_weight 0.76
non_member_discount 36
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 32640
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.34
ta_price 8.77
text
array
1 32640
2 2137120
3 cadmium yellow medium hue, 250 ml, 120
timestamp 2015-03-27T14:46:58.642Z
vip_member_price 7.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376940497
barcode_type UPC
col1 cadmium yellow medium hue
col1_sortorder 1022
col2 200 ml
col2_sortorder 1278
col3 120
col3_sortorder 253
color_swatch 255-242-77.jpg
cost 4.7
deal_of_the_week NO
description cadmium yellow medium hue, 200 ml, 120
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 42385
list_price 10.99
map NO
mfr_num 2136120
net_weight 0.61
non_member_discount 40
non_member_price 6.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 42385
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.5
ta_dealer_c_price 5.17
ta_price 7.14
text
array
1 42385
2 2136120
3 cadmium yellow medium hue, 200 ml, 120
timestamp 2015-03-27T14:47:14.919Z
vip_member_price 5.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 094376913910
barcode_type UPC
col1 cadmium yellow pale hue
col1_sortorder 1029
col2 60 ml
col2_sortorder 2156
col3 114
col3_sortorder 246
color_swatch 255-246-122.jpg
cost 2
deal_of_the_week NO
description cadmium yellow pale hue, 60 ml, 114
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 19583
list_price 4.69
map NO
mfr_num 2120114
net_weight 0.18
non_member_discount 35
non_member_price 3.05
prop65 NO
ship_rule_desc STD
shipping STD
sku 19583
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.35
ta_dealer_c_price 2.2
ta_price 3.05
text
array
1 19583
2 2120114
3 cadmium yellow pale hue, 60 ml, 114
timestamp 2015-03-27T14:46:39.716Z
vip_member_price 2.58

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 094376914184
barcode_type UPC
col1 cadmium yellow pale hue
col1_sortorder 1029
col2 250 ml
col2_sortorder 1400
col3 114
col3_sortorder 246
color_swatch 255-246-122.jpg
cost 5.76
deal_of_the_week NO
description cadmium yellow pale hue, 250 ml, 114
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 76338
list_price 13.49
map NO
mfr_num 2137114
net_weight 0.76
non_member_discount 36
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 76338
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.34
ta_price 8.77
text
array
1 76338
2 2137114
3 cadmium yellow pale hue, 250 ml, 114
timestamp 2015-03-27T14:48:06.317Z
vip_member_price 7.28

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376940473
barcode_type UPC
col1 cadmium yellow pale hue
col1_sortorder 1029
col2 200 ml
col2_sortorder 1278
col3 114
col3_sortorder 246
color_swatch 255-246-122.jpg
cost 4.7
deal_of_the_week NO
description cadmium yellow pale hue, 200 ml, 114
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 85082
list_price 10.99
map NO
mfr_num 2136114
net_weight 0.62
non_member_discount 40
non_member_price 6.59
prop65 NO
ship_rule_desc STD
shipping STD
sku 85082
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.5
ta_dealer_c_price 5.17
ta_price 7.14
text
array
1 85082
2 2136114
3 cadmium yellow pale hue, 200 ml, 114
timestamp 2015-03-27T14:48:15.058Z
vip_member_price 5.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376914436
barcode_type UPC
col1 cadmium yellow pale hue
col1_sortorder 1029
col2 500 ml
col2_sortorder 2034
col3 114
col3_sortorder 246
color_swatch 255-246-122.jpg
cost 11.53
deal_of_the_week NO
description cadmium yellow pale hue, 500 ml, 114
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 85917
list_price 26.99
map NO
mfr_num 2150114
net_weight 1.56
non_member_discount 40
non_member_price 16.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 85917
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.5
ta_dealer_c_price 12.69
ta_price 17.54
text
array
1 85917
2 2150114
3 cadmium yellow pale hue, 500 ml, 114
timestamp 2015-03-27T14:48:17.684Z
vip_member_price 14.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e0306d95b0f1240d51917f5430556275476e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=fp~4-9999.99~&gr=north-light-your-artist-s-brain.html
urltoken CFID=29537996&CFTOKEN=48261232&jsessionid=e0306d95b0f1240d51917f5430556275476e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:36:21'}
sessionid e03024ef606a90e598ee397c1a31b1d386d5
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html
urltoken CFID=29537995&CFTOKEN=88970469&jsessionid=e03024ef606a90e598ee397c1a31b1d386d5
validationerror [empty string]


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

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

ItemIDList: 44509
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376914467
barcode_type UPC
col1 cerulean blue hue
col1_sortorder 1163
col2 500 ml
col2_sortorder 2034
col3 138
col3_sortorder 270
color_swatch 0-120-210.jpg
cost 11.53
deal_of_the_week NO
description cerulean blue hue, 500 ml, 138
group_id 744
group_uname winsor-newton-galeria-flow-formula-acrylic-colours
id 37416
list_price 26.99
map NO
mfr_num 2150138
net_weight 1.56
non_member_discount 40
non_member_price 16.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 37416
sku_pix YES
supplier_id 1
ta_dealer_a_price 13.5
ta_dealer_c_price 12.69
ta_price 17.54
text
array
1 37416
2 2150138
3 cerulean blue hue, 500 ml, 138
timestamp 2015-03-27T14:47:09.237Z
vip_member_price 14.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 44509
CACHED false
EXECUTIONTIME 2
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] = '15752' 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.146.154

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=sort~1~fp~0-4~&gr=winsor-newton-galeria-flow-formula-acrylic-colours.html

StartSessionVariables: