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

Artist Watercolor

by Holbein


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030393
barcode_type EAN
col1 aureolin
col1_sortorder 253
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 240-184-47.jpg
cost 6.17
deal_of_the_week NO
description aureolin, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97046
list_price 13.5
map NO
mfr_num W039
net_weight 0.02
non_member_discount 35
non_member_price 8.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 97046
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.75
ta_price 10.13
text
array
1 97046
2 W039
3 aureolin, 5 ml
timestamp 2015-03-31T17:54:51.436Z
vip_member_price 7.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030782
barcode_type EAN
col1 bamboo green
col1_sortorder 312
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 110-164-0.jpg
cost 4.71
deal_of_the_week NO
description bamboo green, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97047
list_price 10.3
map NO
mfr_num W078
net_weight 0.02
non_member_discount 35
non_member_price 6.67
prop65 NO
ship_rule_desc STD
shipping STD
sku 97047
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.15
ta_dealer_c_price 5.15
ta_price 7.73
text
array
1 97047
2 W078
3 bamboo green, 5 ml
timestamp 2015-03-31T17:54:51.44Z
vip_member_price 5.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669031505
barcode_type EAN
col1 blue grey
col1_sortorder 575
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 92-130-195.jpg
cost 4.23
deal_of_the_week NO
description blue grey, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97048
list_price 9.25
map NO
mfr_num W150
net_weight 0.02
non_member_discount 35
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 97048
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.63
ta_dealer_c_price 4.63
ta_price 6.94
text
array
1 97048
2 W150
3 blue grey, 5 ml
timestamp 2015-03-31T17:54:51.441Z
vip_member_price 5.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669031703
barcode_type EAN
col1 bright rose luminous
col1_sortorder 732
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 184-138-195.jpg
cost 4.71
deal_of_the_week NO
description bright rose luminous, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97049
list_price 10.3
map NO
mfr_num W170
net_weight 0.02
non_member_discount 35
non_member_price 6.67
prop65 NO
ship_rule_desc STD
shipping STD
sku 97049
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.15
ta_dealer_c_price 5.15
ta_price 7.73
text
array
1 97049
2 W170
3 bright rose luminous, 5 ml
timestamp 2015-03-31T17:54:51.444Z
vip_member_price 5.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669031758
barcode_type EAN
col1 bright violet luminous
col1_sortorder 741
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 167-47-195.jpg
cost 4.71
deal_of_the_week NO
description bright violet luminous, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97050
list_price 10.3
map NO
mfr_num W175
net_weight 0.02
non_member_discount 35
non_member_price 6.67
prop65 NO
ship_rule_desc STD
shipping STD
sku 97050
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.15
ta_dealer_c_price 5.15
ta_price 7.73
text
array
1 97050
2 W175
3 bright violet luminous, 5 ml
timestamp 2015-03-31T17:54:51.446Z
vip_member_price 5.67

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030478
barcode_type EAN
col1 brilliant orange
col1_sortorder 759
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 195-95-47.jpg
cost 5.38
deal_of_the_week NO
description brilliant orange, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97051
list_price 11.75
map NO
mfr_num W047
net_weight 0.03
non_member_discount 35
non_member_price 7.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 97051
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.88
ta_dealer_c_price 5.88
ta_price 8.81
text
array
1 97051
2 W047
3 brilliant orange, 5 ml
timestamp 2015-03-31T17:54:51.448Z
vip_member_price 6.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030256
barcode_type EAN
col1 brilliant pink
col1_sortorder 760
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 210-122-122.jpg
cost 4.23
deal_of_the_week NO
description brilliant pink, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97052
list_price 9.25
map NO
mfr_num W025
net_weight 0.02
non_member_discount 35
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 97052
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.63
ta_dealer_c_price 4.63
ta_price 6.94
text
array
1 97052
2 W025
3 brilliant pink, 5 ml
timestamp 2015-03-31T17:54:51.45Z
vip_member_price 5.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030232
barcode_type EAN
col1 brown madder
col1_sortorder 810
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 164-77-77.jpg
cost 7.43
deal_of_the_week NO
description brown madder, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97053
list_price 16.25
map NO
mfr_num W023
net_weight 0.02
non_member_discount 35
non_member_price 10.52
prop65 NO
ship_rule_desc STD
shipping STD
sku 97053
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.13
ta_dealer_c_price 8.13
ta_price 12.19
text
array
1 97053
2 W023
3 brown madder, 5 ml
timestamp 2015-03-31T17:54:51.452Z
vip_member_price 8.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669031345
barcode_type EAN
col1 burnt sienna
col1_sortorder 876
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 149-102-47.jpg
cost 4.23
deal_of_the_week NO
description burnt sienna, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97054
list_price 9.25
map NO
mfr_num W134
net_weight 0.02
non_member_discount 35
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 97054
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.63
ta_dealer_c_price 4.63
ta_price 6.94
text
array
1 97054
2 W134
3 burnt sienna, 5 ml
timestamp 2015-03-31T17:54:51.455Z
vip_member_price 5.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669031338
barcode_type EAN
col1 burnt umber
col1_sortorder 887
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 104-72-47.jpg
cost 4.23
deal_of_the_week NO
description burnt umber, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97055
list_price 9.25
map NO
mfr_num W133
net_weight 0.02
non_member_discount 35
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 97055
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.63
ta_dealer_c_price 4.63
ta_price 6.94
text
array
1 97055
2 W133
3 burnt umber, 5 ml
timestamp 2015-03-31T17:54:51.457Z
vip_member_price 5.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030706
barcode_type EAN
col1 cadmium green deep
col1_sortorder 929
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 92-149-92.jpg
cost 5.38
deal_of_the_week NO
description cadmium green deep, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97056
list_price 11.75
map NO
mfr_num W070
net_weight 0.02
non_member_discount 35
non_member_price 7.61
prop65 YES
ship_rule_desc STD
shipping STD
sku 97056
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.88
ta_dealer_c_price 5.88
ta_price 8.81
text
array
1 97056
2 W070
3 cadmium green deep, 5 ml
timestamp 2015-03-31T17:54:51.459Z
vip_member_price 6.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030690
barcode_type EAN
col1 cadmium green pale
col1_sortorder 934
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 92-195-92.jpg
cost 5.38
deal_of_the_week NO
description cadmium green pale, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97057
list_price 11.75
map NO
mfr_num W069
net_weight 0.03
non_member_discount 35
non_member_price 7.61
prop65 YES
ship_rule_desc STD
shipping STD
sku 97057
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.88
ta_dealer_c_price 5.88
ta_price 8.81
text
array
1 97057
2 W069
3 cadmium green pale, 5 ml
timestamp 2015-03-31T17:54:51.461Z
vip_member_price 6.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030157
barcode_type EAN
col1 cadmium red deep
col1_sortorder 960
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 164-0-62.jpg
cost 7.43
deal_of_the_week NO
description cadmium red deep, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97058
list_price 16.25
map NO
mfr_num W015
net_weight 0.03
non_member_discount 35
non_member_price 10.52
prop65 YES
ship_rule_desc STD
shipping STD
sku 97058
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.13
ta_dealer_c_price 8.13
ta_price 12.19
text
array
1 97058
2 W015
3 cadmium red deep, 5 ml
timestamp 2015-03-31T17:54:51.463Z
vip_member_price 8.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030140
barcode_type EAN
col1 cadmium red light
col1_sortorder 970
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 240-47-47.jpg
cost 7.43
deal_of_the_week NO
description cadmium red light, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97059
list_price 16.25
map NO
mfr_num W014
net_weight 0.02
non_member_discount 35
non_member_price 10.52
prop65 YES
ship_rule_desc STD
shipping STD
sku 97059
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.13
ta_dealer_c_price 8.13
ta_price 12.19
text
array
1 97059
2 W014
3 cadmium red light, 5 ml
timestamp 2015-03-31T17:54:51.465Z
vip_member_price 8.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030164
barcode_type EAN
col1 cadmium red orange
col1_sortorder 987
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 240-83-47.jpg
cost 7.43
deal_of_the_week NO
description cadmium red orange, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97060
list_price 16.25
map NO
mfr_num W016
net_weight 0.02
non_member_discount 35
non_member_price 10.52
prop65 YES
ship_rule_desc STD
shipping STD
sku 97060
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.13
ta_dealer_c_price 8.13
ta_price 12.19
text
array
1 97060
2 W016
3 cadmium red orange, 5 ml
timestamp 2015-03-31T17:54:51.466Z
vip_member_price 8.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030171
barcode_type EAN
col1 cadmium red purple
col1_sortorder 990
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 164-0-0.jpg
cost 7.43
deal_of_the_week NO
description cadmium red purple, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97061
list_price 16.25
map NO
mfr_num W017
net_weight 0.03
non_member_discount 35
non_member_price 10.52
prop65 YES
ship_rule_desc STD
shipping STD
sku 97061
sku_pix YES
supplier_id 1
ta_dealer_a_price 8.13
ta_dealer_c_price 8.13
ta_price 12.19
text
array
1 97061
2 W017
3 cadmium red purple, 5 ml
timestamp 2015-03-31T17:54:51.474Z
vip_member_price 8.94

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030430
barcode_type EAN
col1 cadmium yellow deep
col1_sortorder 1002
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 195-140-47.jpg
cost 5.38
deal_of_the_week NO
description cadmium yellow deep, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97062
list_price 11.75
map NO
mfr_num W043
net_weight 0.02
non_member_discount 35
non_member_price 7.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 97062
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.88
ta_dealer_c_price 5.88
ta_price 8.81
text
array
1 97062
2 W043
3 cadmium yellow deep, 5 ml
timestamp 2015-03-31T17:54:51.479Z
vip_member_price 6.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030409
barcode_type EAN
col1 cadmium yellow lemon
col1_sortorder 1010
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 240-240-92.jpg
cost 5.38
deal_of_the_week NO
description cadmium yellow lemon, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97063
list_price 11.75
map NO
mfr_num W040
net_weight 0.02
non_member_discount 35
non_member_price 7.61
prop65 YES
ship_rule_desc STD
shipping STD
sku 97063
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.88
ta_dealer_c_price 5.88
ta_price 8.81
text
array
1 97063
2 W040
3 cadmium yellow lemon, 5 ml
timestamp 2015-03-31T17:54:51.481Z
vip_member_price 6.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030423
barcode_type EAN
col1 cadmium yellow light
col1_sortorder 1011
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 240-213-47.jpg
cost 5.38
deal_of_the_week NO
description cadmium yellow light, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97064
list_price 11.75
map NO
mfr_num W042
net_weight 0.03
non_member_discount 35
non_member_price 7.61
prop65 YES
ship_rule_desc STD
shipping STD
sku 97064
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.88
ta_dealer_c_price 5.88
ta_price 8.81
text
array
1 97064
2 W042
3 cadmium yellow light, 5 ml
timestamp 2015-03-31T17:54:51.484Z
vip_member_price 6.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030447
barcode_type EAN
col1 cadmium yellow orange
col1_sortorder 1028
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 240-132-47.jpg
cost 5.38
deal_of_the_week NO
description cadmium yellow orange, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97065
list_price 11.75
map NO
mfr_num W044
net_weight 0.03
non_member_discount 35
non_member_price 7.61
prop65 YES
ship_rule_desc STD
shipping STD
sku 97065
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.88
ta_dealer_c_price 5.88
ta_price 8.81
text
array
1 97065
2 W044
3 cadmium yellow orange, 5 ml
timestamp 2015-03-31T17:54:51.486Z
vip_member_price 6.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030416
barcode_type EAN
col1 cadmium yellow pale
col1_sortorder 1029
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 240-240-138.jpg
cost 5.38
deal_of_the_week NO
description cadmium yellow pale, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97066
list_price 11.75
map NO
mfr_num W041
net_weight 0.03
non_member_discount 35
non_member_price 7.61
prop65 YES
ship_rule_desc STD
shipping STD
sku 97066
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.88
ta_dealer_c_price 5.88
ta_price 8.81
text
array
1 97066
2 W041
3 cadmium yellow pale, 5 ml
timestamp 2015-03-31T17:54:51.487Z
vip_member_price 6.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030119
barcode_type EAN
col1 carmine
col1_sortorder 1111
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 164-0-90.jpg
cost 4.23
deal_of_the_week NO
description carmine, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97067
list_price 9.25
map NO
mfr_num W011
net_weight 0.02
non_member_discount 35
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 97067
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.63
ta_dealer_c_price 4.63
ta_price 6.94
text
array
1 97067
2 W011
3 carmine, 5 ml
timestamp 2015-03-31T17:54:51.49Z
vip_member_price 5.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030928
barcode_type EAN
col1 cerulean blue
col1_sortorder 1155
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 122-155-210.jpg
cost 6.17
deal_of_the_week NO
description cerulean blue, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97068
list_price 13.5
map NO
mfr_num W092
net_weight 0.02
non_member_discount 35
non_member_price 8.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 97068
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.75
ta_price 10.13
text
array
1 97068
2 W092
3 cerulean blue, 5 ml
timestamp 2015-03-31T17:54:51.493Z
vip_member_price 7.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030249
barcode_type EAN
col1 cherry red
col1_sortorder 1203
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 210-0-72.jpg
cost 5.38
deal_of_the_week NO
description cherry red, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97069
list_price 11.75
map NO
mfr_num W024
net_weight 0.02
non_member_discount 35
non_member_price 7.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 97069
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.88
ta_dealer_c_price 5.88
ta_price 8.81
text
array
1 97069
2 W024
3 cherry red, 5 ml
timestamp 2015-03-31T17:54:51.496Z
vip_member_price 6.46

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030027
barcode_type EAN
col1 Chinese white
col1_sortorder 1217
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 255-255-255.jpg
cost 4.23
deal_of_the_week NO
description Chinese white, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97070
list_price 9.25
map NO
mfr_num W002
net_weight 0.03
non_member_discount 35
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 97070
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.63
ta_dealer_c_price 4.63
ta_price 6.94
text
array
1 97070
2 W002
3 Chinese white, 5 ml
timestamp 2015-03-31T17:54:51.498Z
vip_member_price 5.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030904
barcode_type EAN
col1 cobalt blue
col1_sortorder 1353
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 92-92-149.jpg
cost 6.17
deal_of_the_week NO
description cobalt blue, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97071
list_price 13.5
map NO
mfr_num W090
net_weight 0.02
non_member_discount 35
non_member_price 8.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 97071
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.75
ta_price 10.13
text
array
1 97071
2 W090
3 cobalt blue, 5 ml
timestamp 2015-03-31T17:54:51.5Z
vip_member_price 7.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030911
barcode_type EAN
col1 cobalt blue hue
col1_sortorder 1358
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 77-77-164.jpg
cost 4.23
deal_of_the_week NO
description cobalt blue hue, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97072
list_price 9.25
map NO
mfr_num W091
net_weight 0.02
non_member_discount 35
non_member_price 5.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 97072
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.63
ta_dealer_c_price 4.63
ta_price 6.94
text
array
1 97072
2 W091
3 cobalt blue hue, 5 ml
timestamp 2015-03-31T17:54:51.505Z
vip_member_price 5.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030638
barcode_type EAN
col1 cobalt green
col1_sortorder 1372
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 92-149-122.jpg
cost 6.17
deal_of_the_week NO
description cobalt green, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97073
list_price 13.5
map NO
mfr_num W063
net_weight 0.02
non_member_discount 35
non_member_price 8.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 97073
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.75
ta_price 10.13
text
array
1 97073
2 W063
3 cobalt green, 5 ml
timestamp 2015-03-31T17:54:51.507Z
vip_member_price 7.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669030768
barcode_type EAN
col1 cobalt green yellow shade
col1_sortorder 1377
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 90-104-47.jpg
cost 6.17
deal_of_the_week NO
description cobalt green yellow shade, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97074
list_price 13.5
map NO
mfr_num W076
net_weight 0.02
non_member_discount 35
non_member_price 8.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 97074
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.75
ta_price 10.13
text
array
1 97074
2 W076
3 cobalt green yellow shade, 5 ml
timestamp 2015-03-31T17:54:51.51Z
vip_member_price 7.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669031062
barcode_type EAN
col1 cobalt turquoise light
col1_sortorder 1393
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 92-143-195.jpg
cost 6.17
deal_of_the_week NO
description cobalt turquoise light, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97075
list_price 13.5
map NO
mfr_num W106
net_weight 0.02
non_member_discount 35
non_member_price 8.74
prop65 NO
ship_rule_desc STD
shipping STD
sku 97075
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.75
ta_dealer_c_price 6.75
ta_price 10.13
text
array
1 97075
2 W106
3 cobalt turquoise light, 5 ml
timestamp 2015-03-31T17:54:51.512Z
vip_member_price 7.43

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 4900669031109
barcode_type EAN
col1 cobalt violet light
col1_sortorder 1400
col2 5 ml
col2_sortorder 1974
col3 [empty string]
color_swatch 115-77-119.jpg
cost 11.42
deal_of_the_week NO
description cobalt violet light, 5 ml
group_id 6615
group_uname holbein-artist-watercolor
id 97076
list_price 24.95
map NO
mfr_num W110
net_weight 0.02
non_member_discount 35
non_member_price 16.16
prop65 YES
ship_rule_desc STD
shipping STD
sku 97076
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.48
ta_dealer_c_price 12.48
ta_price 18.71
text
array
1 97076
2 W110
3 cobalt violet light, 5 ml
timestamp 2015-03-31T17:54:51.516Z
vip_member_price 13.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 15.000000000000 14656
2 71.000000000000 25116
3 58.000000000000 39157
4 9.000000000000 60545
CACHED false
EXECUTIONTIME 3
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '1157' 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.227.215.139

URL: www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030ccceefd6217871672041155b4984f315
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=adhesives&catB=adhesive-removers&CatC=fp~9-33~&gr=best-test-bestine-solvent-and-thinner.html
urltoken CFID=30565096&CFTOKEN=27126037&jsessionid=e030ccceefd6217871672041155b4984f315
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 16:23:58'}
sessionid e030b7a856b061fdd04d795e593a2234761c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=watercolors&CatC=paints&CatD=fb~holbein~&gr=holbein-artist-watercolor.html
urltoken CFID=30565095&CFTOKEN=43820771&jsessionid=e030b7a856b061fdd04d795e593a2234761c
validationerror [empty string]


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

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

ItemIDList: 14656,25116,39157,60545
AvailQtyList: 15.000000000000,71.000000000000,58.000000000000,9.000000000000