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

Watercolors

by Van Gogh


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046538
barcode_type EAN
col1 azo yellow deep
col1_sortorder 276
col2 [empty string]
col3 [empty string]
color_swatch 240-199-47.jpg
cost 1.9
deal_of_the_week NO
description azo yellow deep
group_id 660
group_uname van-gogh-watercolors
id 11589
list_price 4.8
map NO
mfr_num 100515500
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 11589
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 11589
2 100515500
3 azo yellow deep
timestamp 2015-03-31T17:52:37.657Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046514
barcode_type EAN
col1 azo yellow light
col1_sortorder 278
col2 [empty string]
col3 [empty string]
color_swatch 240-225-138.jpg
cost 1.9
deal_of_the_week NO
description azo yellow light
group_id 660
group_uname van-gogh-watercolors
id 36921
list_price 4.8
map NO
mfr_num 100515498
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 36921
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 36921
2 100515498
3 azo yellow light
timestamp 2015-03-31T17:53:19.817Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046521
barcode_type EAN
col1 azo yellow medium
col1_sortorder 279
col2 [empty string]
col3 [empty string]
color_swatch 240-213-47.jpg
cost 1.9
deal_of_the_week NO
description azo yellow medium
group_id 660
group_uname van-gogh-watercolors
id 39566
list_price 4.8
map NO
mfr_num 100515499
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 39566
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 39566
2 100515499
3 azo yellow medium
timestamp 2015-03-31T17:53:23.585Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046835
barcode_type EAN
col1 burnt sienna
col1_sortorder 876
col2 [empty string]
col3 [empty string]
color_swatch 195-95-47.jpg
cost 1.9
deal_of_the_week NO
description burnt sienna
group_id 660
group_uname van-gogh-watercolors
id 15588
list_price 4.8
map NO
mfr_num 100515511
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 15588
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 15588
2 100515511
3 burnt sienna
timestamp 2015-03-31T17:52:46.694Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046842
barcode_type EAN
col1 burnt umber
col1_sortorder 887
col2 [empty string]
col3 [empty string]
color_swatch 74-58-0.jpg
cost 1.9
deal_of_the_week NO
description burnt umber
group_id 660
group_uname van-gogh-watercolors
id 57991
list_price 4.8
map NO
mfr_num 100515510
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 57991
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 57991
2 100515510
3 burnt umber
timestamp 2015-03-31T17:53:51.74Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046675
barcode_type EAN
col1 cerulean blue
col1_sortorder 1155
col2 [empty string]
col3 [empty string]
color_swatch 0-115-255.jpg
cost 1.9
deal_of_the_week NO
description cerulean blue
group_id 660
group_uname van-gogh-watercolors
id 27491
list_price 4.8
map NO
mfr_num 100515517
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 27491
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 27491
2 100515517
3 cerulean blue
timestamp 2015-03-31T17:53:04.784Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046484
barcode_type EAN
col1 Chinese white
col1_sortorder 1217
col2 [empty string]
col3 [empty string]
color_swatch 255-255-255.jpg
cost 1.9
deal_of_the_week NO
description Chinese white
group_id 660
group_uname van-gogh-watercolors
id 23659
list_price 4.8
map NO
mfr_num 100515491
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 23659
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 23659
2 100515491
3 Chinese white
timestamp 2015-03-31T17:52:59.454Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046668
barcode_type EAN
col1 cobalt blue
col1_sortorder 1353
col2 [empty string]
col3 [empty string]
color_swatch 77-120-255.jpg
cost 1.9
deal_of_the_week NO
description cobalt blue
group_id 660
group_uname van-gogh-watercolors
id 59062
list_price 4.8
map NO
mfr_num 100515515
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 59062
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 59062
2 100515515
3 cobalt blue
timestamp 2015-03-31T17:53:52.84Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046569
barcode_type EAN
col1 gamboge
col1_sortorder 2376
col2 [empty string]
col3 [empty string]
color_swatch 240-213-47.jpg
cost 1.9
deal_of_the_week NO
description gamboge
group_id 660
group_uname van-gogh-watercolors
id 43081
list_price 4.8
map NO
mfr_num 100515495
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 43081
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 43081
2 100515495
3 gamboge
timestamp 2015-03-31T17:53:27.441Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046750
barcode_type EAN
col1 hooker green deep
col1_sortorder 2844
col2 [empty string]
col3 [empty string]
color_swatch 0-119-106.jpg
cost 1.9
deal_of_the_week NO
description hooker green deep
group_id 660
group_uname van-gogh-watercolors
id 68682
list_price 4.8
map NO
mfr_num 100515526
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 68682
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 68682
2 100515526
3 hooker green deep
timestamp 2015-03-31T17:54:15.004Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046743
barcode_type EAN
col1 hooker green light
col1_sortorder 2845
col2 [empty string]
col3 [empty string]
color_swatch 92-195-162.jpg
cost 1.9
deal_of_the_week NO
description hooker green light
group_id 660
group_uname van-gogh-watercolors
id 32733
list_price 4.8
map NO
mfr_num 100515525
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 32733
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 32733
2 100515525
3 hooker green light
timestamp 2015-03-31T17:53:11.343Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046705
barcode_type EAN
col1 indigo
col1_sortorder 2951
col2 [empty string]
col3 [empty string]
color_swatch 0-0-164.jpg
cost 1.9
deal_of_the_week NO
description indigo
group_id 660
group_uname van-gogh-watercolors
id 52969
list_price 4.8
map NO
mfr_num 100515516
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 52969
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 52969
2 100515516
3 indigo
timestamp 2015-03-31T17:53:46.298Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046880
barcode_type EAN
col1 ivory black
col1_sortorder 3126
col2 [empty string]
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.9
deal_of_the_week NO
description ivory black
group_id 660
group_uname van-gogh-watercolors
id 53195
list_price 4.8
map NO
mfr_num 100515529
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 53195
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 53195
2 100515529
3 ivory black
timestamp 2015-03-31T17:53:46.524Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046811
barcode_type EAN
col1 light oxide red
col1_sortorder 3389
col2 [empty string]
col3 [empty string]
color_swatch 164-93-77.jpg
cost 1.9
deal_of_the_week NO
description light oxide red
group_id 660
group_uname van-gogh-watercolors
id 25263
list_price 4.8
map NO
mfr_num 100515504
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 25263
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 25263
2 100515504
3 light oxide red
timestamp 2015-03-31T17:53:01.312Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046613
barcode_type EAN
col1 madder lake deep
col1_sortorder 3530
col2 [empty string]
col3 [empty string]
color_swatch 255-0-130.jpg
cost 1.9
deal_of_the_week NO
description madder lake deep
group_id 660
group_uname van-gogh-watercolors
id 24563
list_price 4.8
map NO
mfr_num 100515503
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 24563
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 24563
2 100515503
3 madder lake deep
timestamp 2015-03-31T17:53:00.285Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046606
barcode_type EAN
col1 madder lake light
col1_sortorder 3531
col2 [empty string]
col3 [empty string]
color_swatch 240-92-126.jpg
cost 1.9
deal_of_the_week NO
description madder lake light
group_id 660
group_uname van-gogh-watercolors
id 71021
list_price 4.8
map NO
mfr_num 100515502
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 71021
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 71021
2 100515502
3 madder lake light
timestamp 2015-03-31T17:54:19.978Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046552
barcode_type EAN
col1 Naples yellow red
col1_sortorder 3920
col2 [empty string]
col3 [empty string]
color_swatch 240-202-183.jpg
cost 1.9
deal_of_the_week NO
description Naples yellow red
group_id 660
group_uname van-gogh-watercolors
id 67733
list_price 4.8
map NO
mfr_num 100515492
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 67733
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 67733
2 100515492
3 Naples yellow red
timestamp 2015-03-31T17:54:12.996Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046774
barcode_type EAN
col1 olive green
col1_sortorder 4171
col2 [empty string]
col3 [empty string]
color_swatch 126-149-92.jpg
cost 1.9
deal_of_the_week NO
description olive green
group_id 660
group_uname van-gogh-watercolors
id 24492
list_price 4.8
map NO
mfr_num 100515522
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 24492
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 24492
2 100515522
3 olive green
timestamp 2015-03-31T17:53:00.209Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046873
barcode_type EAN
col1 payne's gray
col1_sortorder 4426
col2 [empty string]
col3 [empty string]
color_swatch 75-75-75.jpg
cost 1.9
deal_of_the_week NO
description payne's gray
group_id 660
group_uname van-gogh-watercolors
id 78479
list_price 4.8
map NO
mfr_num 100515530
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 78479
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 78479
2 100515530
3 payne's gray
timestamp 2015-03-31T17:54:31.282Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046903
barcode_type EAN
col1 permanent blue violet
col1_sortorder 4553
col2 [empty string]
col3 [empty string]
color_swatch 99-47-149.jpg
cost 1.9
deal_of_the_week NO
description permanent blue violet
group_id 660
group_uname van-gogh-watercolors
id 80474
list_price 4.8
map NO
mfr_num 100515519
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 80474
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 80474
2 100515519
3 permanent blue violet
timestamp 2015-03-31T17:54:33.499Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079047733
barcode_type EAN
col1 permanent green
col1_sortorder 4562
col2 [empty string]
col3 [empty string]
color_swatch 47-195-172.jpg
cost 1.9
deal_of_the_week NO
description permanent green
group_id 660
group_uname van-gogh-watercolors
id 47635
list_price 4.8
map NO
mfr_num 100515527
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 47635
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 47635
2 100515527
3 permanent green
timestamp 2015-03-31T17:53:33.483Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046545
barcode_type EAN
col1 permanent orange
col1_sortorder 4591
col2 [empty string]
col3 [empty string]
color_swatch 210-121-77.jpg
cost 1.9
deal_of_the_week NO
description permanent orange
group_id 660
group_uname van-gogh-watercolors
id 76071
list_price 4.8
map NO
mfr_num 100515497
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 76071
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 76071
2 100515497
3 permanent orange
timestamp 2015-03-31T17:54:28.25Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046590
barcode_type EAN
col1 permanent red deep
col1_sortorder 4593
col2 [empty string]
col3 [empty string]
color_swatch 210-0-72.jpg
cost 1.9
deal_of_the_week NO
description permanent red deep
group_id 660
group_uname van-gogh-watercolors
id 65865
list_price 4.8
map NO
mfr_num 100515507
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 65865
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 65865
2 100515507
3 permanent red deep
timestamp 2015-03-31T17:54:09.474Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046576
barcode_type EAN
col1 permanent red light
col1_sortorder 4594
col2 [empty string]
col3 [empty string]
color_swatch 210-77-77.jpg
cost 1.9
deal_of_the_week NO
description permanent red light
group_id 660
group_uname van-gogh-watercolors
id 41856
list_price 4.8
map NO
mfr_num 100515506
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 41856
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 41856
2 100515506
3 permanent red light
timestamp 2015-03-31T17:53:25.745Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046637
barcode_type EAN
col1 permanent red violet
col1_sortorder 4600
col2 [empty string]
col3 [empty string]
color_swatch 164-0-146.jpg
cost 1.9
deal_of_the_week NO
description permanent red violet
group_id 660
group_uname van-gogh-watercolors
id 84024
list_price 4.8
map NO
mfr_num 100515518
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 84024
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 84024
2 100515518
3 permanent red violet
timestamp 2015-03-31T17:54:37.692Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046712
barcode_type EAN
col1 permanent yellow green
col1_sortorder 4619
col2 [empty string]
col3 [empty string]
color_swatch 166-210-0.jpg
cost 1.9
deal_of_the_week NO
description permanent yellow green
group_id 660
group_uname van-gogh-watercolors
id 70043
list_price 4.8
map NO
mfr_num 100515524
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 70043
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 70043
2 100515524
3 permanent yellow green
timestamp 2015-03-31T17:54:18.019Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046507
barcode_type EAN
col1 permanent yellow lemon
col1_sortorder 4620
col2 [empty string]
col3 [empty string]
color_swatch 240-233-138.jpg
cost 1.9
deal_of_the_week NO
description permanent yellow lemon
group_id 660
group_uname van-gogh-watercolors
id 61201
list_price 4.8
map NO
mfr_num 100515496
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 61201
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 61201
2 100515496
3 permanent yellow lemon
timestamp 2015-03-31T17:53:59.748Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079047771
barcode_type EAN
col1 phthalo blue
col1_sortorder 4660
col2 [empty string]
col3 [empty string]
color_swatch 0-98-210.jpg
cost 1.9
deal_of_the_week NO
description phthalo blue
group_id 660
group_uname van-gogh-watercolors
id 35015
list_price 4.8
map NO
mfr_num 100515520
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 35015
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 35015
2 100515520
3 phthalo blue
timestamp 2015-03-31T17:53:17.021Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046736
barcode_type EAN
col1 phthalo green
col1_sortorder 4679
col2 [empty string]
col3 [empty string]
color_swatch 0-210-210.jpg
cost 1.9
deal_of_the_week NO
description phthalo green
group_id 660
group_uname van-gogh-watercolors
id 89122
list_price 4.8
map NO
mfr_num 100515528
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 89122
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 89122
2 100515528
3 phthalo green
timestamp 2015-03-31T17:54:42.565Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046699
barcode_type EAN
col1 Prussian blue
col1_sortorder 4903
col2 [empty string]
col3 [empty string]
color_swatch 0-53-119.jpg
cost 1.9
deal_of_the_week NO
description Prussian blue
group_id 660
group_uname van-gogh-watercolors
id 73794
list_price 4.8
map NO
mfr_num 100515514
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 73794
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 73794
2 100515514
3 Prussian blue
timestamp 2015-03-31T17:54:25.343Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046620
barcode_type EAN
col1 quinacridone rose
col1_sortorder 5019
col2 [empty string]
col3 [empty string]
color_swatch 240-47-132.jpg
cost 1.9
deal_of_the_week NO
description quinacridone rose
group_id 660
group_uname van-gogh-watercolors
id 47681
list_price 4.8
map NO
mfr_num 100515505
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 47681
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 47681
2 100515505
3 quinacridone rose
timestamp 2015-03-31T17:53:33.509Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


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

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

ItemIDList: 29698,60045
AvailQtyList: 60.000000000000,54.000000000000

struct
FLAGS 0
VIP_member_discount 49
barcode 8712079046798
barcode_type EAN
col1 raw sienna
col1_sortorder 5061
col2 [empty string]
col3 [empty string]
color_swatch 149-102-47.jpg
cost 1.9
deal_of_the_week NO
description raw sienna
group_id 660
group_uname van-gogh-watercolors
id 77651
list_price 4.8
map NO
mfr_num 100515494
net_weight 0.04
non_member_discount 39
non_member_price 2.93
prop65 NO
ship_rule_desc STD
shipping STD
sku 77651
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.4
ta_dealer_c_price 2.06
ta_price 3.37
text
array
1 77651
2 100515494
3 raw sienna
timestamp 2015-03-31T17:54:29.934Z
vip_member_price 2.45

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 60.000000000000 29698
2 54.000000000000 60045
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] = '1415' 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.246.183

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 20:43:53'}
sessionid e0308d29b9f643caf7e36e3367f3e340345e
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=sort~1~&gr=van-gogh-watercolors.html
urltoken CFID=30615432&CFTOKEN=66230528&jsessionid=e0308d29b9f643caf7e36e3367f3e340345e
validationerror [empty string]


EndSessionVariables: