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

Cotman Water Colours

by Winsor & Newton


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
VIP_member_discount 52
barcode 094376902327
barcode_type UPC
col1 alizarin crimson hue
col1_sortorder 83
col2 3
col2_sortorder 145
col3 21 ml
col3_sortorder 1285
color_swatch 164-0-0.jpg
cost 4.05
deal_of_the_week NO
description alizarin crimson hue, 3, 21 ml
flags
array
1 2
group_id 610
group_uname winsor-newton-cotman-water-colours
id 12277
list_price 9.49
map NO
mfr_num 0308003
net_weight 0.08
non_member_discount 35
non_member_price 6.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 12277
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.75
ta_dealer_c_price 4.46
ta_price 6.64
text
array
1 12277
2 0308003
3 alizarin crimson hue, 3, 21 ml
timestamp 2015-03-27T14:46:27.329Z
vip_member_price 4.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901825
barcode_type UPC
col1 alizarin crimson hue
col1_sortorder 83
col2 3
col2_sortorder 145
col3 8 ml
col3_sortorder 2315
color_swatch 164-0-0.jpg
cost 1.92
deal_of_the_week NO
description alizarin crimson hue, 3, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 39311
list_price 4.49
map NO
mfr_num 0303003
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 39311
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 39311
2 0303003
3 alizarin crimson hue, 3, 8 ml
timestamp 2015-03-27T14:47:11.618Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
VIP_member_discount 52
barcode 094376902334
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 74
col2_sortorder 216
col3 21 ml
col3_sortorder 1285
color_swatch 164-75-0.jpg
cost 4.05
deal_of_the_week NO
description burnt sienna, 74, 21 ml
flags
array
1 2
group_id 610
group_uname winsor-newton-cotman-water-colours
id 12279
list_price 9.49
map NO
mfr_num 0308074
net_weight 0.08
non_member_discount 35
non_member_price 6.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 12279
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.75
ta_dealer_c_price 4.46
ta_price 6.64
text
array
1 12279
2 0308074
3 burnt sienna, 74, 21 ml
timestamp 2015-03-27T14:46:27.333Z
vip_member_price 4.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901832
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 74
col2_sortorder 216
col3 8 ml
col3_sortorder 2315
color_swatch 164-75-0.jpg
cost 1.92
deal_of_the_week NO
description burnt sienna, 74, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 20745
list_price 4.49
map NO
mfr_num 0303074
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 20745
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 20745
2 0303074
3 burnt sienna, 74, 8 ml
timestamp 2015-03-27T14:46:40.851Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
VIP_member_discount 52
barcode 094376902341
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 76
col2_sortorder 218
col3 21 ml
col3_sortorder 1285
color_swatch 149-112-47.jpg
cost 4.05
deal_of_the_week NO
description burnt umber, 76, 21 ml
flags
array
1 2
group_id 610
group_uname winsor-newton-cotman-water-colours
id 12282
list_price 9.49
map NO
mfr_num 0308076
net_weight 0.08
non_member_discount 35
non_member_price 6.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 12282
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.75
ta_dealer_c_price 4.46
ta_price 6.64
text
array
1 12282
2 0308076
3 burnt umber, 76, 21 ml
timestamp 2015-03-27T14:46:27.336Z
vip_member_price 4.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901849
barcode_type UPC
col1 burnt umber
col1_sortorder 886
col2 76
col2_sortorder 218
col3 8 ml
col3_sortorder 2315
color_swatch 149-112-47.jpg
cost 1.92
deal_of_the_week NO
description burnt umber, 76, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 36683
list_price 4.49
map NO
mfr_num 0303076
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 36683
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 36683
2 0303076
3 burnt umber, 76, 8 ml
timestamp 2015-03-27T14:47:08.033Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901856
barcode_type UPC
col1 cadmium orange
col1_sortorder 938
col2 89
col2_sortorder 224
col3 8 ml
col3_sortorder 2315
color_swatch 255-173-0.jpg
cost 2.77
deal_of_the_week NO
description cadmium orange, 89, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 46928
list_price 6.49
map NO
mfr_num 0303089
net_weight 0.04
non_member_discount 35
non_member_price 4.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 46928
sku_pix NO
supplier_id 1
ta_dealer_a_price 3.25
ta_dealer_c_price 3.05
ta_price 4.54
text
array
1 46928
2 0303089
3 cadmium orange, 89, 8 ml
timestamp 2015-03-27T14:47:21.242Z
vip_member_price 3.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901863
barcode_type UPC
col1 cadmium orange hue
col1_sortorder 947
col2 90
col3 8 ml
col3_sortorder 2315
color_swatch 240-172-92.jpg
cost 1.92
deal_of_the_week NO
description cadmium orange hue, 90, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 39391
list_price 4.49
map NO
mfr_num 0303090
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 39391
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 39391
2 0303090
3 cadmium orange hue, 90, 8 ml
timestamp 2015-03-27T14:47:11.676Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901894
barcode_type UPC
col1 cadmium red deep hue
col1_sortorder 961
col2 98
col2_sortorder 228
col3 8 ml
col3_sortorder 2315
color_swatch 240-120-92.jpg
cost 1.92
deal_of_the_week NO
description cadmium red deep hue, 98, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 35123
list_price 4.49
map NO
mfr_num 0303098
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 35123
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 35123
2 0303098
3 cadmium red deep hue, 98, 8 ml
timestamp 2015-03-27T14:47:05.678Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901887
barcode_type UPC
col1 cadmium red hue
col1_sortorder 968
col2 95
col2_sortorder 226
col3 8 ml
col3_sortorder 2315
color_swatch 210-65-0.jpg
cost 1.92
deal_of_the_week NO
description cadmium red hue, 95, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 64174
list_price 4.49
map NO
mfr_num 0303095
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 64174
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 64174
2 0303095
3 cadmium red hue, 95, 8 ml
timestamp 2015-03-27T14:47:44.439Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901917
barcode_type UPC
col1 cadmium red pale hue
col1_sortorder 988
col2 103
col2_sortorder 235
col3 8 ml
col3_sortorder 2315
color_swatch 255-147-122.jpg
cost 1.92
deal_of_the_week NO
description cadmium red pale hue, 103, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 31636
list_price 4.49
map NO
mfr_num 0303103
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 31636
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 31636
2 0303103
3 cadmium red pale hue, 103, 8 ml
timestamp 2015-03-27T14:46:57.274Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901931
barcode_type UPC
col1 cadmium yellow hue
col1_sortorder 1008
col2 109
col2_sortorder 241
col3 8 ml
col3_sortorder 2315
color_swatch 255-255-0.jpg
cost 1.92
deal_of_the_week NO
description cadmium yellow hue, 109, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 13683
list_price 4.49
map NO
mfr_num 0303109
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 13683
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 13683
2 0303109
3 cadmium yellow hue, 109, 8 ml
timestamp 2015-03-27T14:46:29.215Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901955
barcode_type UPC
col1 cadmium yellow pale hue
col1_sortorder 1029
col2 119
col2_sortorder 251
col3 8 ml
col3_sortorder 2315
color_swatch 255-255-122.jpg
cost 1.92
deal_of_the_week NO
description cadmium yellow pale hue, 119, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 32755
list_price 4.49
map NO
mfr_num 0303119
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 32755
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 32755
2 0303119
3 cadmium yellow pale hue, 119, 8 ml
timestamp 2015-03-27T14:46:58.785Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901962
barcode_type UPC
col1 cerulean blue
col1_sortorder 1154
col2 137
col2_sortorder 269
col3 8 ml
col3_sortorder 2315
color_swatch 77-205-255.jpg
cost 2.77
deal_of_the_week NO
description cerulean blue, 137, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 75203
list_price 6.49
map NO
mfr_num 0303137
net_weight 0.04
non_member_discount 35
non_member_price 4.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 75203
sku_pix NO
supplier_id 1
ta_dealer_a_price 3.25
ta_dealer_c_price 3.05
ta_price 4.54
text
array
1 75203
2 0303137
3 cerulean blue, 137, 8 ml
timestamp 2015-03-27T14:48:05.266Z
vip_member_price 3.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
VIP_member_discount 52
barcode 094376902419
barcode_type UPC
col1 cerulean blue hue
col1_sortorder 1163
col2 139
col2_sortorder 271
col3 21 ml
col3_sortorder 1285
color_swatch 77-241-255.jpg
cost 4.05
deal_of_the_week NO
description cerulean blue hue, 139, 21 ml
flags
array
1 2
group_id 610
group_uname winsor-newton-cotman-water-colours
id 12284
list_price 9.49
map NO
mfr_num 0308139
net_weight 0.08
non_member_discount 35
non_member_price 6.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 12284
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.75
ta_dealer_c_price 4.46
ta_price 6.64
text
array
1 12284
2 0308139
3 cerulean blue hue, 139, 21 ml
timestamp 2015-03-27T14:46:27.338Z
vip_member_price 4.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901979
barcode_type UPC
col1 cerulean blue hue
col1_sortorder 1163
col2 139
col2_sortorder 271
col3 8 ml
col3_sortorder 2315
color_swatch 77-241-255.jpg
cost 1.92
deal_of_the_week NO
description cerulean blue hue, 139, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 41953
list_price 4.49
map NO
mfr_num 0303139
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 41953
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 41953
2 0303139
3 cerulean blue hue, 139, 8 ml
timestamp 2015-03-27T14:47:14.456Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
VIP_member_discount 52
barcode 094376902426
barcode_type UPC
col1 Chinese white
col1_sortorder 1216
col2 150
col2_sortorder 282
col3 21 ml
col3_sortorder 1285
color_swatch 255-255-255.jpg
cost 4.05
deal_of_the_week NO
description Chinese white, 150, 21 ml
flags
array
1 2
group_id 610
group_uname winsor-newton-cotman-water-colours
id 12285
list_price 9.49
map NO
mfr_num 0308150
net_weight 0.08
non_member_discount 35
non_member_price 6.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 12285
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.75
ta_dealer_c_price 4.46
ta_price 6.64
text
array
1 12285
2 0308150
3 Chinese white, 150, 21 ml
timestamp 2015-03-27T14:46:27.343Z
vip_member_price 4.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901986
barcode_type UPC
col1 Chinese white
col1_sortorder 1216
col2 150
col2_sortorder 282
col3 8 ml
col3_sortorder 2315
color_swatch 255-255-255.jpg
cost 1.92
deal_of_the_week NO
description Chinese white, 150, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 45742
list_price 4.49
map NO
mfr_num 0303150
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 45742
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 45742
2 0303150
3 Chinese white, 150, 8 ml
timestamp 2015-03-27T14:47:19.078Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376901993
barcode_type UPC
col1 cobalt blue
col1_sortorder 1352
col2 178
col2_sortorder 309
col3 8 ml
col3_sortorder 2315
color_swatch 0-75-210.jpg
cost 2.77
deal_of_the_week NO
description cobalt blue, 178, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 11077
list_price 6.49
map NO
mfr_num 0303178
net_weight 0.04
non_member_discount 35
non_member_price 4.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 11077
sku_pix NO
supplier_id 1
ta_dealer_a_price 3.25
ta_dealer_c_price 3.05
ta_price 4.54
text
array
1 11077
2 0303178
3 cobalt blue, 178, 8 ml
timestamp 2015-03-27T14:46:25.079Z
vip_member_price 3.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
VIP_member_discount 52
barcode 094376902433
barcode_type UPC
col1 cobalt blue hue
col1_sortorder 1357
col2 179
col2_sortorder 310
col3 21 ml
col3_sortorder 1285
color_swatch 77-241-255.jpg
cost 4.05
deal_of_the_week NO
description cobalt blue hue, 179, 21 ml
flags
array
1 2
group_id 610
group_uname winsor-newton-cotman-water-colours
id 12298
list_price 9.49
map NO
mfr_num 0308179
net_weight 0.08
non_member_discount 35
non_member_price 6.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 12298
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.75
ta_dealer_c_price 4.46
ta_price 6.64
text
array
1 12298
2 0308179
3 cobalt blue hue, 179, 21 ml
timestamp 2015-03-27T14:46:27.368Z
vip_member_price 4.56

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376902006
barcode_type UPC
col1 cobalt blue hue
col1_sortorder 1357
col2 179
col2_sortorder 310
col3 8 ml
col3_sortorder 2315
color_swatch 0-75-210.jpg
cost 1.92
deal_of_the_week NO
description cobalt blue hue, 179, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 22040
list_price 4.49
map NO
mfr_num 0303179
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 22040
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 22040
2 0303179
3 cobalt blue hue, 179, 8 ml
timestamp 2015-03-27T14:46:42.905Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376902013
barcode_type UPC
col1 cobalt violet
col1_sortorder 1395
col2 192
col2_sortorder 323
col3 8 ml
col3_sortorder 2315
color_swatch 185-92-195.jpg
cost 2.77
deal_of_the_week NO
description cobalt violet, 192, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 67074
list_price 6.49
map NO
mfr_num 0303192
net_weight 0.04
non_member_discount 35
non_member_price 4.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 67074
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.25
ta_dealer_c_price 3.05
ta_price 4.54
text
array
1 67074
2 0303192
3 cobalt violet, 192, 8 ml
timestamp 2015-03-27T14:47:49.747Z
vip_member_price 3.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376902020
barcode_type UPC
col1 dioxazine violet
col1_sortorder 1914
col2 231
col2_sortorder 384
col3 8 ml
col3_sortorder 2315
color_swatch 99-47-149.jpg
cost 1.92
deal_of_the_week NO
description dioxazine violet, 231, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 11699
list_price 4.49
map NO
mfr_num 0303231
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 11699
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 11699
2 0303231
3 dioxazine violet, 231, 8 ml
timestamp 2015-03-27T14:46:26.286Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376902037
barcode_type UPC
col1 emerald
col1_sortorder 2027
col2 235
col2_sortorder 400
col3 8 ml
col3_sortorder 2315
color_swatch 0-119-92.jpg
cost 1.92
deal_of_the_week NO
description emerald, 235, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 80042
list_price 4.49
map NO
mfr_num 0303235
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 80042
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 80042
2 0303235
3 emerald, 235, 8 ml
timestamp 2015-03-27T14:48:09.985Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376902044
barcode_type UPC
col1 gamboge hue
col1_sortorder 2373
col2 266
col2_sortorder 436
col3 8 ml
col3_sortorder 2315
color_swatch 240-213-47.jpg
cost 1.92
deal_of_the_week NO
description gamboge hue, 266, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 39812
list_price 4.49
map NO
mfr_num 0303266
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 39812
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 39812
2 0303266
3 gamboge hue, 266, 8 ml
timestamp 2015-03-27T14:47:12.229Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376902051
barcode_type UPC
col1 hookers green dark
col1_sortorder 2851
col2 312
col2_sortorder 481
col3 8 ml
col3_sortorder 2315
color_swatch 0-119-77.jpg
cost 1.92
deal_of_the_week NO
description hookers green dark, 312, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 27328
list_price 4.49
map NO
mfr_num 0303312
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 27328
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 27328
2 0303312
3 hookers green dark, 312, 8 ml
timestamp 2015-03-27T14:46:50.5Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376902068
barcode_type UPC
col1 hookers green light
col1_sortorder 2856
col2 314
col2_sortorder 483
col3 8 ml
col3_sortorder 2315
color_swatch 0-164-0.jpg
cost 1.92
deal_of_the_week NO
description hookers green light, 314, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 68821
list_price 4.49
map NO
mfr_num 0303314
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 68821
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 68821
2 0303314
3 hookers green light, 314, 8 ml
timestamp 2015-03-27T14:47:52.226Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376902075
barcode_type UPC
col1 Indian red
col1_sortorder 2934
col2 317
col2_sortorder 485
col3 8 ml
col3_sortorder 2315
color_swatch 119-60-0.jpg
cost 1.92
deal_of_the_week NO
description Indian red, 317, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 36247
list_price 4.49
map NO
mfr_num 0303317
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 36247
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 36247
2 0303317
3 Indian red, 317, 8 ml
timestamp 2015-03-27T14:47:07.165Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376902082
barcode_type UPC
col1 indigo
col1_sortorder 2945
col2 322
col2_sortorder 495
col3 8 ml
col3_sortorder 2315
color_swatch 0-81-164.jpg
cost 1.92
deal_of_the_week NO
description indigo, 322, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 36334
list_price 4.49
map NO
mfr_num 0303322
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 36334
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 36334
2 0303322
3 indigo, 322, 8 ml
timestamp 2015-03-27T14:47:07.285Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376902099
barcode_type UPC
col1 intense phthalo blue
col1_sortorder 2961
col2 327
col2_sortorder 500
col3 8 ml
col3_sortorder 2315
color_swatch 0-0-164.jpg
cost 1.92
deal_of_the_week NO
description intense phthalo blue, 327, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 29447
list_price 4.49
map NO
mfr_num 0303327
net_weight 0.04
non_member_discount 35
non_member_price 2.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 29447
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.25
ta_dealer_c_price 2.11
ta_price 3.14
text
array
1 29447
2 0303327
3 intense phthalo blue, 327, 8 ml
timestamp 2015-03-27T14:46:53.364Z
vip_member_price 2.16

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 7.000000000000 11156
2 0E-12 12692
3 6.000000000000 15307
4 0E-12 15603
5 0E-12 15617
6 0E-12 28295
7 0E-12 29937
8 0E-12 70930
CACHED false
EXECUTIONTIME 8
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] = '12464' 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.145.209.130

URL: www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e0303062ecf9ab20b04739167e1e2e1d27a6
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=cool-accessories&gr=dillon-tiaras-and-crowns.html
urltoken CFID=29849909&CFTOKEN=80669907&jsessionid=e0303062ecf9ab20b04739167e1e2e1d27a6
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-29 02:35:38'}
sessionid e030cd469c924a94d8663b763261b545b295
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=browse&pg=more-ways-brand-names&paramOpts=fb~winsor-newton~c1~painting~&gr=winsor-newton-cotman-water-colours.html
urltoken CFID=29849910&CFTOKEN=76470682&jsessionid=e030cd469c924a94d8663b763261b545b295
validationerror [empty string]


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

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

ItemIDList: 11156,12692,15307,15603,15617,28295,29937,70930
AvailQtyList: 7.000000000000,0E-12,6.000000000000,0E-12,0E-12,0E-12,0E-12,0E-12

struct
FLAGS 0
VIP_member_discount 52
barcode 094376902105
barcode_type UPC
col1 intense phthalo green
col1_sortorder 2965
col2 329
col2_sortorder 502
col3 8 ml
col3_sortorder 2315
color_swatch 0-119-92.jpg
cost 1.92
deal_of_the_week NO
description intense phthalo green, 329, 8 ml
group_id 610
group_uname winsor-newton-cotman-water-colours
id 24688
list_price 4.49
map NO
mfr_num 0303329
net_weight