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

Artists' Oil Colours

by Winsor & Newton


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50903955
barcode_type EAN8
col1 alizarin crimson
col1_sortorder 81
col2 4
col2_sortorder 146
col3 37 ml
col3_sortorder 1711
color_swatch 164-0-0.jpg
cost 7.26
deal_of_the_week NO
description alizarin crimson, 4, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 20218
list_price 16.99
map YES
mfr_num 1214004
net_weight 0.18
non_member_discount 40
non_member_price 10.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 20218
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.5
ta_dealer_c_price 7.99
ta_price 11.04
text
array
1 20218
2 1214004
3 alizarin crimson, 4, 37 ml
timestamp 2015-03-31T17:52:53.403Z
vip_member_price 8.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376940251
barcode_type UPC
col1 bismuth yellow
col1_sortorder 395
col2 25
col2_sortorder 167
col3 37 ml
col3_sortorder 1711
color_swatch 240-240-47.jpg
cost 15.63
deal_of_the_week NO
description bismuth yellow, 25, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 61188
list_price 36.59
map YES
mfr_num 1214025
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 61188
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 61188
2 1214025
3 bismuth yellow, 25, 37 ml
timestamp 2015-03-31T17:53:59.721Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50903993
barcode_type EAN8
col1 blue black
col1_sortorder 555
col2 34
col2_sortorder 176
col3 37 ml
col3_sortorder 1711
color_swatch 0-0-74.jpg
cost 5.29
deal_of_the_week NO
description blue black, 34, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 43311
list_price 12.39
map YES
mfr_num 1214034
net_weight 0.18
non_member_discount 40
non_member_price 7.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 43311
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.2
ta_dealer_c_price 5.82
ta_price 8.05
text
array
1 43311
2 1214034
3 blue black, 34, 37 ml
timestamp 2015-03-31T17:53:27.967Z
vip_member_price 6.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904006
barcode_type EAN8
col1 bright red
col1_sortorder 729
col2 42
col2_sortorder 184
col3 37 ml
col3_sortorder 1711
color_swatch 210-0-0.jpg
cost 5.29
deal_of_the_week NO
description bright red, 42, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 70853
list_price 12.39
map YES
mfr_num 1214042
net_weight 0.18
non_member_discount 40
non_member_price 7.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 70853
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.2
ta_dealer_c_price 5.82
ta_price 8.05
text
array
1 70853
2 1214042
3 bright red, 42, 37 ml
timestamp 2015-03-31T17:54:19.756Z
vip_member_price 6.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50730438
barcode_type EAN8
col1 bronze
col1_sortorder 791
col2 58
col2_sortorder 200
col3 37 ml
col3_sortorder 1711
color_swatch 149-112-47.jpg
cost 7.26
deal_of_the_week NO
description bronze, 58, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 88309
list_price 16.99
map YES
mfr_num 1214058
net_weight 0.18
non_member_discount 40
non_member_price 10.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 88309
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.5
ta_dealer_c_price 7.99
ta_price 11.04
text
array
1 88309
2 1214058
3 bronze, 58, 37 ml
timestamp 2015-03-31T17:54:41.601Z
vip_member_price 8.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376940855
barcode_type UPC
col1 brown madder
col1_sortorder 810
col2 56
col2_sortorder 198
col3 37 ml
col3_sortorder 1711
color_swatch 119-48-0.jpg
cost 5.29
deal_of_the_week NO
description brown madder, 56, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 45945
list_price 12.39
map YES
mfr_num 1214056
net_weight 0.18
non_member_discount 40
non_member_price 7.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 45945
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.2
ta_dealer_c_price 5.82
ta_price 8.05
text
array
1 45945
2 1214056
3 brown madder, 56, 37 ml
timestamp 2015-03-31T17:53:31.356Z
vip_member_price 6.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376940268
barcode_type UPC
col1 brown ochre
col1_sortorder 812
col2 59
col2_sortorder 201
col3 37 ml
col3_sortorder 1711
color_swatch 149-102-47.jpg
cost 5.29
deal_of_the_week NO
description brown ochre, 59, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 31231
list_price 12.39
map YES
mfr_num 1214059
net_weight 0.18
non_member_discount 40
non_member_price 7.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 31231
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.2
ta_dealer_c_price 5.82
ta_price 8.05
text
array
1 31231
2 1214059
3 brown ochre, 59, 37 ml
timestamp 2015-03-31T17:53:09.676Z
vip_member_price 6.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904020
barcode_type EAN8
col1 burnt sienna
col1_sortorder 876
col2 74
col2_sortorder 216
col3 37 ml
col3_sortorder 1711
color_swatch 164-75-0.jpg
cost 5.29
deal_of_the_week NO
description burnt sienna, 74, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 18919
list_price 12.39
map YES
mfr_num 1214074
net_weight 0.18
non_member_discount 40
non_member_price 7.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 18919
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.2
ta_dealer_c_price 5.82
ta_price 8.05
text
array
1 18919
2 1214074
3 burnt sienna, 74, 37 ml
timestamp 2015-03-31T17:52:51.096Z
vip_member_price 6.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904037
barcode_type EAN8
col1 burnt umber
col1_sortorder 887
col2 76
col2_sortorder 218
col3 37 ml
col3_sortorder 1711
color_swatch 149-112-47.jpg
cost 5.29
deal_of_the_week NO
description burnt umber, 76, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 12225
list_price 12.39
map YES
mfr_num 1214076
net_weight 0.18
non_member_discount 40
non_member_price 7.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 12225
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.2
ta_dealer_c_price 5.82
ta_price 8.05
text
array
1 12225
2 1214076
3 burnt umber, 76, 37 ml
timestamp 2015-03-31T17:52:38.664Z
vip_member_price 6.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904051
barcode_type EAN8
col1 cadmium green pale
col1_sortorder 934
col2 84
col2_sortorder 222
col3 37 ml
col3_sortorder 1711
color_swatch 191-210-0.jpg
cost 15.63
deal_of_the_week NO
description cadmium green pale, 84, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 17868
list_price 36.59
map YES
mfr_num 1214084
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 YES
ship_rule_desc STD
shipping STD
sku 17868
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 17868
2 1214084
3 cadmium green pale, 84, 37 ml
timestamp 2015-03-31T17:52:49.215Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904068
barcode_type EAN8
col1 cadmium lemon
col1_sortorder 935
col2 86
col2_sortorder 223
col3 37 ml
col3_sortorder 1711
color_swatch 255-255-77.jpg
cost 15.63
deal_of_the_week NO
description cadmium lemon, 86, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 69181
list_price 36.59
map YES
mfr_num 1214086
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 YES
ship_rule_desc STD
shipping STD
sku 69181
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 69181
2 1214086
3 cadmium lemon, 86, 37 ml
timestamp 2015-03-31T17:54:16.22Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904075
barcode_type EAN8
col1 cadmium orange
col1_sortorder 939
col2 89
col2_sortorder 224
col3 37 ml
col3_sortorder 1711
color_swatch 255-173-0.jpg
cost 15.63
deal_of_the_week NO
description cadmium orange, 89, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 73428
list_price 36.59
map YES
mfr_num 1214089
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 YES
ship_rule_desc STD
shipping STD
sku 73428
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 73428
2 1214089
3 cadmium orange, 89, 37 ml
timestamp 2015-03-31T17:54:24.77Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904082
barcode_type EAN8
col1 cadmium red
col1_sortorder 955
col2 94
col2_sortorder 225
col3 37 ml
col3_sortorder 1711
color_swatch 210-65-0.jpg
cost 15.63
deal_of_the_week NO
description cadmium red, 94, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 25412
list_price 36.59
map YES
mfr_num 1214094
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 YES
ship_rule_desc STD
shipping STD
sku 25412
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 25412
2 1214094
3 cadmium red, 94, 37 ml
timestamp 2015-03-31T17:53:01.406Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904099
barcode_type EAN8
col1 cadmium red deep
col1_sortorder 960
col2 97
col2_sortorder 227
col3 37 ml
col3_sortorder 1711
color_swatch 195-47-47.jpg
cost 15.63
deal_of_the_week NO
description cadmium red deep, 97, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 56877
list_price 36.59
map YES
mfr_num 1214097
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 YES
ship_rule_desc STD
shipping STD
sku 56877
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 56877
2 1214097
3 cadmium red deep, 97, 37 ml
timestamp 2015-03-31T17:53:51.017Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904105
barcode_type EAN8
col1 cadmium scarlet
col1_sortorder 995
col2 106
col2_sortorder 238
col3 37 ml
col3_sortorder 1711
color_swatch 255-105-0.jpg
cost 15.63
deal_of_the_week NO
description cadmium scarlet, 106, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 33938
list_price 36.59
map YES
mfr_num 1214106
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 YES
ship_rule_desc STD
shipping STD
sku 33938
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 33938
2 1214106
3 cadmium scarlet, 106, 37 ml
timestamp 2015-03-31T17:53:15.769Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904112
barcode_type EAN8
col1 cadmium yellow
col1_sortorder 997
col2 108
col2_sortorder 240
col3 37 ml
col3_sortorder 1711
color_swatch 240-240-47.jpg
cost 15.63
deal_of_the_week NO
description cadmium yellow, 108, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 88728
list_price 36.59
map YES
mfr_num 1214108
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 YES
ship_rule_desc STD
shipping STD
sku 88728
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 88728
2 1214108
3 cadmium yellow, 108, 37 ml
timestamp 2015-03-31T17:54:41.781Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904129
barcode_type EAN8
col1 cadmium yellow deep
col1_sortorder 1002
col2 111
col2_sortorder 243
col3 37 ml
col3_sortorder 1711
color_swatch 255-204-77.jpg
cost 15.63
deal_of_the_week NO
description cadmium yellow deep, 111, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 21088
list_price 36.59
map YES
mfr_num 1214111
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 YES
ship_rule_desc STD
shipping STD
sku 21088
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 21088
2 1214111
3 cadmium yellow deep, 111, 37 ml
timestamp 2015-03-31T17:52:55.418Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904136
barcode_type EAN8
col1 cadmium yellow pale
col1_sortorder 1029
col2 118
col2_sortorder 250
col3 37 ml
col3_sortorder 1711
color_swatch 240-240-138.jpg
cost 15.63
deal_of_the_week NO
description cadmium yellow pale, 118, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 49329
list_price 36.59
map YES
mfr_num 1214118
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 YES
ship_rule_desc STD
shipping STD
sku 49329
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 49329
2 1214118
3 cadmium yellow pale, 118, 37 ml
timestamp 2015-03-31T17:53:36.044Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904150
barcode_type EAN8
col1 cerulean blue
col1_sortorder 1155
col2 137
col2_sortorder 269
col3 37 ml
col3_sortorder 1711
color_swatch 77-205-255.jpg
cost 15.63
deal_of_the_week NO
description cerulean blue, 137, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 64211
list_price 36.59
map YES
mfr_num 1214137
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 64211
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 64211
2 1214137
3 cerulean blue, 137, 37 ml
timestamp 2015-03-31T17:54:06.548Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904167
barcode_type EAN8
col1 charcoal gray
col1_sortorder 1186
col2 142
col2_sortorder 274
col3 37 ml
col3_sortorder 1711
color_swatch 75-75-75.jpg
cost 5.29
deal_of_the_week NO
description charcoal gray, 142, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 89025
list_price 12.39
map YES
mfr_num 1214142
net_weight 0.18
non_member_discount 40
non_member_price 7.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 89025
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.2
ta_dealer_c_price 5.82
ta_price 8.05
text
array
1 89025
2 1214142
3 charcoal gray, 142, 37 ml
timestamp 2015-03-31T17:54:42.443Z
vip_member_price 6.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904198
barcode_type EAN8
col1 chrome green deep hue
col1_sortorder 1242
col2 147
col2_sortorder 279
col3 37 ml
col3_sortorder 1711
color_swatch 80-104-47.jpg
cost 5.29
deal_of_the_week NO
description chrome green deep hue, 147, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 49459
list_price 12.39
map YES
mfr_num 1214147
net_weight 0.18
non_member_discount 40
non_member_price 7.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 49459
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.2
ta_dealer_c_price 5.82
ta_price 8.05
text
array
1 49459
2 1214147
3 chrome green deep hue, 147, 37 ml
timestamp 2015-03-31T17:53:36.11Z
vip_member_price 6.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50730445
barcode_type EAN8
col1 chrome yellow hue
col1_sortorder 1256
col2 149
col2_sortorder 281
col3 37 ml
col3_sortorder 1711
color_swatch 240-226-47.jpg
cost 5.29
deal_of_the_week NO
description chrome yellow hue, 149, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 73514
list_price 12.39
map YES
mfr_num 1214149
net_weight 0.18
non_member_discount 40
non_member_price 7.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 73514
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.2
ta_dealer_c_price 5.82
ta_price 8.05
text
array
1 73514
2 1214149
3 chrome yellow hue, 149, 37 ml
timestamp 2015-03-31T17:54:25.097Z
vip_member_price 6.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904266
barcode_type EAN8
col1 cobalt blue
col1_sortorder 1353
col2 178
col2_sortorder 309
col3 37 ml
col3_sortorder 1711
color_swatch 0-75-210.jpg
cost 15.63
deal_of_the_week NO
description cobalt blue, 178, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 29485
list_price 36.59
map YES
mfr_num 1214178
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 29485
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 29485
2 1214178
3 cobalt blue, 178, 37 ml
timestamp 2015-03-31T17:53:06.823Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904273
barcode_type EAN8
col1 cobalt blue deep
col1_sortorder 1354
col2 180
col2_sortorder 311
col3 37 ml
col3_sortorder 1711
color_swatch 77-77-164.jpg
cost 26.39
deal_of_the_week NO
description cobalt blue deep, 180, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 31981
list_price 61.79
map YES
mfr_num 1214180
net_weight 0.18
non_member_discount 40
non_member_price 37.07
prop65 YES
ship_rule_desc STD
shipping STD
sku 31981
sku_pix YES
supplier_id 1
ta_dealer_a_price 30.9
ta_dealer_c_price 29.04
ta_price 40.16
text
array
1 31981
2 1214180
3 cobalt blue deep, 180, 37 ml
timestamp 2015-03-31T17:53:10.496Z
vip_member_price 32.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376941043
barcode_type UPC
col1 cobalt chromite green
col1_sortorder 1370
col2 183
col2_sortorder 314
col3 37 ml
col3_sortorder 1711
color_swatch 47-195-124.jpg
cost 15.63
deal_of_the_week NO
description cobalt chromite green, 183, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 33532
list_price 36.59
map YES
mfr_num 1214183
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 33532
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 33532
2 1214183
3 cobalt chromite green, 183, 37 ml
timestamp 2015-03-31T17:53:15.066Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904280
barcode_type EAN8
col1 cobalt green
col1_sortorder 1372
col2 184
col2_sortorder 315
col3 37 ml
col3_sortorder 1711
color_swatch 168-210-168.jpg
cost 26.39
deal_of_the_week NO
description cobalt green, 184, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 34395
list_price 61.79
map YES
mfr_num 1214184
net_weight 0.18
non_member_discount 40
non_member_price 37.07
prop65 NO
ship_rule_desc STD
shipping STD
sku 34395
sku_pix YES
supplier_id 1
ta_dealer_a_price 30.9
ta_dealer_c_price 29.04
ta_price 40.16
text
array
1 34395
2 1214184
3 cobalt green, 184, 37 ml
timestamp 2015-03-31T17:53:16.328Z
vip_member_price 32.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904303
barcode_type EAN8
col1 cobalt turquoise
col1_sortorder 1389
col2 190
col2_sortorder 321
col3 37 ml
col3_sortorder 1711
color_swatch 0-164-164.jpg
cost 26.39
deal_of_the_week NO
description cobalt turquoise, 190, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 23648
list_price 61.79
map YES
mfr_num 1214190
net_weight 0.18
non_member_discount 40
non_member_price 37.07
prop65 NO
ship_rule_desc STD
shipping STD
sku 23648
sku_pix YES
supplier_id 1
ta_dealer_a_price 30.9
ta_dealer_c_price 29.04
ta_price 40.16
text
array
1 23648
2 1214190
3 cobalt turquoise, 190, 37 ml
timestamp 2015-03-31T17:52:59.441Z
vip_member_price 32.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 094376940275
barcode_type UPC
col1 cobalt turquoise light
col1_sortorder 1393
col2 191
col2_sortorder 322
col3 37 ml
col3_sortorder 1711
color_swatch 77-199-210.jpg
cost 15.63
deal_of_the_week NO
description cobalt turquoise light, 191, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 37945
list_price 36.59
map YES
mfr_num 1214191
net_weight 0.18
non_member_discount 40
non_member_price 21.95
prop65 NO
ship_rule_desc STD
shipping STD
sku 37945
sku_pix YES
supplier_id 1
ta_dealer_a_price 18.3
ta_dealer_c_price 17.2
ta_price 23.78
text
array
1 37945
2 1214191
3 cobalt turquoise light, 191, 37 ml
timestamp 2015-03-31T17:53:21.5Z
vip_member_price 19.03

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904310
barcode_type EAN8
col1 cobalt violet
col1_sortorder 1396
col2 192
col2_sortorder 323
col3 37 ml
col3_sortorder 1711
color_swatch 185-92-195.jpg
cost 26.39
deal_of_the_week NO
description cobalt violet, 192, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 20664
list_price 61.79
map YES
mfr_num 1214192
net_weight 0.18
non_member_discount 40
non_member_price 37.07
prop65 YES
ship_rule_desc STD
shipping STD
sku 20664
sku_pix YES
supplier_id 1
ta_dealer_a_price 30.9
ta_dealer_c_price 29.04
ta_price 40.16
text
array
1 20664
2 1214192
3 cobalt violet, 192, 37 ml
timestamp 2015-03-31T17:52:54.857Z
vip_member_price 32.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50730452
barcode_type EAN8
col1 copper
col1_sortorder 1529
col2 214
col2_sortorder 359
col3 37 ml
col3_sortorder 1711
color_swatch 164-104-0.jpg
cost 7.26
deal_of_the_week NO
description copper, 214, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 53056
list_price 16.99
map YES
mfr_num 1214214
net_weight 0.18
non_member_discount 40
non_member_price 10.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 53056
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.5
ta_dealer_c_price 7.99
ta_price 11.04
text
array
1 53056
2 1214214
3 copper, 214, 37 ml
timestamp 2015-03-31T17:53:46.338Z
vip_member_price 8.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50946242
barcode_type EAN8
col1 cremnitz white
col1_sortorder 1606
col2 201
col2_sortorder 332
col3 37 ml
col3_sortorder 1711
color_swatch 255-255-255.jpg
cost 5.29
deal_of_the_week NO
description cremnitz white, 201, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 35516
list_price 12.39
map YES
mfr_num 1214201
net_weight 0.18
non_member_discount 40
non_member_price 7.43
prop65 YES
ship_rule_desc STD
shipping STD
sku 35516
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.2
ta_dealer_c_price 5.82
ta_price 8.05
text
array
1 35516
2 1214201
3 cremnitz white, 201, 37 ml
timestamp 2015-03-31T17:53:18.092Z
vip_member_price 6.44

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e0308dac44f5b17d1f0b32497f1732456757
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=mold-making&CatC=fp~8-32~&gr=castin-craft-mixing-cups.html
urltoken CFID=30798878&CFTOKEN=23625230&jsessionid=e0308dac44f5b17d1f0b32497f1732456757
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 13:02:27'}
sessionid e030e41eda52333001531c631e344f1fd314
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html
urltoken CFID=30798877&CFTOKEN=52524076&jsessionid=e030e41eda52333001531c631e344f1fd314
validationerror [empty string]


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

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

ItemIDList: 38650
AvailQtyList: 24.000000000000

struct
FLAGS 0
VIP_member_discount 48
barcode 50904341
barcode_type EAN8
col1 Davy's gray
col1_sortorder 1778
col2 217
col2_sortorder 362
col3 37 ml
col3_sortorder 1711
color_swatch 240-240-240.jpg
cost 7.26
deal_of_the_week NO
description Davy's gray, 217, 37 ml
group_id 131
group_uname winsor-newton-artists-oil-colours
id 51542
list_price 16.99
map YES
mfr_num 1214217
net_weight 0.18
non_member_discount 40
non_member_price 10.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 51542
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.5
ta_dealer_c_price 7.99
ta_price 11.04
text
array
1 51542
2 1214217
3 Davy's gray, 217, 37 ml
timestamp 2015-03-31T17:53:38.311Z
vip_member_price 8.83

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 24.000000000000 38650
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] = '1803' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 23.22.53.212

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=paints&CatD=fb~winsor-newton~fp~7-8~&gr=winsor-newton-artists-oil-colours.html

StartSessionVariables: