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

Expert Acrylic Tubes

by Amsterdam


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289102
barcode_type EAN
col1 aureoline
col1_sortorder 255
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 210-170-48.jpg
cost 5.14
deal_of_the_week NO
description aureoline, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94237
list_price 12.95
map NO
mfr_num 100515322
net_weight 0.22
non_member_discount 34
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 94237
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.57
ta_dealer_c_price 5.57
ta_price 8.42
text
array
1 94237
2 100515322
3 aureoline, 75 ml
timestamp 2015-03-26T14:52:26.011Z
vip_member_price 7.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289386
barcode_type EAN
col1 burnt sienna
col1_sortorder 875
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 119-48-0.jpg
cost 3.26
deal_of_the_week NO
description burnt sienna, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94265
list_price 8.2
map NO
mfr_num 100515350
net_weight 0.22
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94265
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94265
2 100515350
3 burnt sienna, 75 ml
timestamp 2015-03-26T14:52:26.082Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289379
barcode_type EAN
col1 burnt umber
col1_sortorder 886
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 74-50-0.jpg
cost 3.26
deal_of_the_week NO
description burnt umber, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94264
list_price 8.2
map NO
mfr_num 100515349
net_weight 0.22
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94264
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94264
2 100515349
3 burnt umber, 75 ml
timestamp 2015-03-26T14:52:26.08Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289041
barcode_type EAN
col1 cadmium orange
col1_sortorder 938
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 210-128-0.jpg
cost 7.02
deal_of_the_week NO
description cadmium orange, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94231
list_price 17.7
map NO
mfr_num 100515316
net_weight 0.23
non_member_discount 34
non_member_price 11.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 94231
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.61
ta_dealer_c_price 7.61
ta_price 11.51
text
array
1 94231
2 100515316
3 cadmium orange, 75 ml
timestamp 2015-03-26T14:52:25.996Z
vip_member_price 10

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289225
barcode_type EAN
col1 cadmium red deep
col1_sortorder 959
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 164-0-0.jpg
cost 7.02
deal_of_the_week NO
description cadmium red deep, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94249
list_price 17.7
map NO
mfr_num 100515334
net_weight 0.25
non_member_discount 34
non_member_price 11.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 94249
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.61
ta_dealer_c_price 7.61
ta_price 11.51
text
array
1 94249
2 100515334
3 cadmium red deep, 75 ml
timestamp 2015-03-26T14:52:26.042Z
vip_member_price 10

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289218
barcode_type EAN
col1 cadmium red light
col1_sortorder 969
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 210-0-0.jpg
cost 7.02
deal_of_the_week NO
description cadmium red light, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94248
list_price 17.7
map NO
mfr_num 100515333
net_weight 0.25
non_member_discount 34
non_member_price 11.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 94248
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.61
ta_dealer_c_price 7.61
ta_price 11.51
text
array
1 94248
2 100515333
3 cadmium red light, 75 ml
timestamp 2015-03-26T14:52:26.039Z
vip_member_price 10

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289249
barcode_type EAN
col1 cadmium red medium
col1_sortorder 977
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 195-47-47.jpg
cost 7.02
deal_of_the_week NO
description cadmium red medium, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94251
list_price 17.7
map NO
mfr_num 100515336
net_weight 0.25
non_member_discount 34
non_member_price 11.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 94251
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.61
ta_dealer_c_price 7.61
ta_price 11.51
text
array
1 94251
2 100515336
3 cadmium red medium, 75 ml
timestamp 2015-03-26T14:52:26.046Z
vip_member_price 10

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289034
barcode_type EAN
col1 cadmium yellow deep
col1_sortorder 1001
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 240-186-92.jpg
cost 7.02
deal_of_the_week NO
description cadmium yellow deep, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94230
list_price 17.7
map NO
mfr_num 100515315
net_weight 0.25
non_member_discount 34
non_member_price 11.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 94230
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.61
ta_dealer_c_price 7.61
ta_price 11.51
text
array
1 94230
2 100515315
3 cadmium yellow deep, 75 ml
timestamp 2015-03-26T14:52:25.994Z
vip_member_price 10

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289010
barcode_type EAN
col1 cadmium yellow lemon
col1_sortorder 1009
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 255-223-0.jpg
cost 7.02
deal_of_the_week NO
description cadmium yellow lemon, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94228
list_price 17.7
map NO
mfr_num 100515313
net_weight 0.24
non_member_discount 34
non_member_price 11.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 94228
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.61
ta_dealer_c_price 7.61
ta_price 11.51
text
array
1 94228
2 100515313
3 cadmium yellow lemon, 75 ml
timestamp 2015-03-26T14:52:25.99Z
vip_member_price 10

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289027
barcode_type EAN
col1 cadmium yellow light
col1_sortorder 1010
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 255-230-77.jpg
cost 7.02
deal_of_the_week NO
description cadmium yellow light, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94229
list_price 17.7
map NO
mfr_num 100515314
net_weight 0.25
non_member_discount 34
non_member_price 11.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 94229
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.61
ta_dealer_c_price 7.61
ta_price 11.51
text
array
1 94229
2 100515314
3 cadmium yellow light, 75 ml
timestamp 2015-03-26T14:52:25.992Z
vip_member_price 10

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289140
barcode_type EAN
col1 cadmium yellow medium
col1_sortorder 1019
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 255-208-0.jpg
cost 7.02
deal_of_the_week NO
description cadmium yellow medium, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94241
list_price 17.7
map NO
mfr_num 100515326
net_weight 0.24
non_member_discount 34
non_member_price 11.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 94241
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.61
ta_dealer_c_price 7.61
ta_price 11.51
text
array
1 94241
2 100515326
3 cadmium yellow medium, 75 ml
timestamp 2015-03-26T14:52:26.02Z
vip_member_price 10

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289270
barcode_type EAN
col1 carmine
col1_sortorder 1110
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 164-0-62.jpg
cost 5.14
deal_of_the_week NO
description carmine, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94254
list_price 12.95
map NO
mfr_num 100515339
net_weight 0.21
non_member_discount 34
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 94254
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.57
ta_dealer_c_price 5.57
ta_price 8.42
text
array
1 94254
2 100515339
3 carmine, 75 ml
timestamp 2015-03-26T14:52:26.054Z
vip_member_price 7.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289287
barcode_type EAN
col1 carmine deep
col1_sortorder 1111
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 104-47-60.jpg
cost 5.14
deal_of_the_week NO
description carmine deep, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94255
list_price 12.95
map NO
mfr_num 100515340
net_weight 0.22
non_member_discount 34
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 94255
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.57
ta_dealer_c_price 5.57
ta_price 8.42
text
array
1 94255
2 100515340
3 carmine deep, 75 ml
timestamp 2015-03-26T14:52:26.056Z
vip_member_price 7.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289652
barcode_type EAN
col1 chromium oxide green
col1_sortorder 1263
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 83-119-0.jpg
cost 5.14
deal_of_the_week NO
description chromium oxide green, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94292
list_price 12.95
map NO
mfr_num 100515377
net_weight 0.27
non_member_discount 34
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 94292
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.57
ta_dealer_c_price 5.57
ta_price 8.42
text
array
1 94292
2 100515377
3 chromium oxide green, 75 ml
timestamp 2015-03-26T14:52:26.143Z
vip_member_price 7.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289416
barcode_type EAN
col1 cobalt blue
col1_sortorder 1352
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 47-47-240.jpg
cost 7.02
deal_of_the_week NO
description cobalt blue, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94268
list_price 17.7
map NO
mfr_num 100515353
net_weight 0.23
non_member_discount 34
non_member_price 11.77
prop65 NO
ship_rule_desc STD
shipping STD
sku 94268
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.61
ta_dealer_c_price 7.61
ta_price 11.51
text
array
1 94268
2 100515353
3 cobalt blue, 75 ml
timestamp 2015-03-26T14:52:26.088Z
vip_member_price 10

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289447
barcode_type EAN
col1 cobalt blue deep (ultramarine)
col1_sortorder 1354
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 47-47-104.jpg
cost 3.26
deal_of_the_week NO
description cobalt blue deep (ultramarine), 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94271
list_price 8.2
map NO
mfr_num 100515356
net_weight 0.23
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94271
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94271
2 100515356
3 cobalt blue deep (ultramarine), 75 ml
timestamp 2015-03-26T14:52:26.094Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289423
barcode_type EAN
col1 cobalt blue light (ultramarine)
col1_sortorder 1363
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 77-109-210.jpg
cost 3.26
deal_of_the_week NO
description cobalt blue light (ultramarine), 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94269
list_price 8.2
map NO
mfr_num 100515354
net_weight 0.23
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94269
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94269
2 100515354
3 cobalt blue light (ultramarine), 75 ml
timestamp 2015-03-26T14:52:26.09Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289072
barcode_type EAN
col1 greenish yellow light
col1_sortorder 2691
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 210-210-0.jpg
cost 3.26
deal_of_the_week NO
description greenish yellow light, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94234
list_price 8.2
map NO
mfr_num 100515319
net_weight 0.24
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94234
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94234
2 100515319
3 greenish yellow light, 75 ml
timestamp 2015-03-26T14:52:26.005Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289454
barcode_type EAN
col1 indanthrene blue (phthalo)
col1_sortorder 2929
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 47-68-104.jpg
cost 3.26
deal_of_the_week NO
description indanthrene blue (phthalo), 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94272
list_price 8.2
map NO
mfr_num 100515357
net_weight 0.22
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94272
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94272
2 100515357
3 indanthrene blue (phthalo), 75 ml
timestamp 2015-03-26T14:52:26.096Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289508
barcode_type EAN
col1 indigo
col1_sortorder 2945
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 0-47-74.jpg
cost 3.26
deal_of_the_week NO
description indigo, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94277
list_price 8.2
map NO
mfr_num 100515362
net_weight 0.23
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94277
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94277
2 100515362
3 indigo, 75 ml
timestamp 2015-03-26T14:52:26.106Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289669
barcode_type EAN
col1 ivory black
col1_sortorder 3120
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 30-30-30.jpg
cost 3.26
deal_of_the_week NO
description ivory black, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94293
list_price 8.2
map NO
mfr_num 100515378
net_weight 0.22
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94293
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94293
2 100515378
3 ivory black, 75 ml
timestamp 2015-03-26T14:52:26.146Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289430
barcode_type EAN
col1 king's blue
col1_sortorder 3205
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 47-102-195.jpg
cost 3.26
deal_of_the_week NO
description king's blue, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94270
list_price 8.2
map NO
mfr_num 100515355
net_weight 0.22
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94270
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94270
2 100515355
3 king's blue, 75 ml
timestamp 2015-03-26T14:52:26.092Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289300
barcode_type EAN
col1 light oxide red
col1_sortorder 3383
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 119-48-0.jpg
cost 5.14
deal_of_the_week NO
description light oxide red, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94257
list_price 12.95
map NO
mfr_num 100515342
net_weight 0.23
non_member_discount 34
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 94257
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.57
ta_dealer_c_price 5.57
ta_price 8.42
text
array
1 94257
2 100515342
3 light oxide red, 75 ml
timestamp 2015-03-26T14:52:26.062Z
vip_member_price 7.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289492
barcode_type EAN
col1 mauve
col1_sortorder 3634
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 139-92-149.jpg
cost 3.26
deal_of_the_week NO
description mauve, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94276
list_price 8.2
map NO
mfr_num 100515361
net_weight 0.23
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94276
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94276
2 100515361
3 mauve, 75 ml
timestamp 2015-03-26T14:52:26.104Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289201
barcode_type EAN
col1 Naples yellow red light
col1_sortorder 3912
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 210-151-122.jpg
cost 3.26
deal_of_the_week NO
description Naples yellow red light, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94247
list_price 8.2
map NO
mfr_num 100515332
net_weight 0.24
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94247
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94247
2 100515332
3 Naples yellow red light, 75 ml
timestamp 2015-03-26T14:52:26.037Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289621
barcode_type EAN
col1 olive green
col1_sortorder 4164
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 56-74-0.jpg
cost 5.14
deal_of_the_week NO
description olive green, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94289
list_price 12.95
map NO
mfr_num 100515374
net_weight 0.22
non_member_discount 34
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 94289
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.57
ta_dealer_c_price 5.57
ta_price 8.42
text
array
1 94289
2 100515374
3 olive green, 75 ml
timestamp 2015-03-26T14:52:26.136Z
vip_member_price 7.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289683
barcode_type EAN
col1 oxide black
col1_sortorder 4276
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 15-15-15.jpg
cost 3.26
deal_of_the_week NO
description oxide black, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94295
list_price 8.2
map NO
mfr_num 100515380
net_weight 0.23
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94295
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94295
2 100515380
3 oxide black, 75 ml
timestamp 2015-03-26T14:52:26.151Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289676
barcode_type EAN
col1 Payne's grey
col1_sortorder 4419
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 60-60-60.jpg
cost 3.26
deal_of_the_week NO
description Payne's grey, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94294
list_price 8.2
map NO
mfr_num 100515379
net_weight 0.22
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94294
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94294
2 100515379
3 Payne's grey, 75 ml
timestamp 2015-03-26T14:52:26.148Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289560
barcode_type EAN
col1 permanent blue violet opaque
col1_sortorder 4544
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 60-47-104.jpg
cost 5.14
deal_of_the_week NO
description permanent blue violet opaque, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94283
list_price 12.95
map NO
mfr_num 100515368
net_weight 0.23
non_member_discount 34
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 94283
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.57
ta_dealer_c_price 5.57
ta_price 8.42
text
array
1 94283
2 100515368
3 permanent blue violet opaque, 75 ml
timestamp 2015-03-26T14:52:26.122Z
vip_member_price 7.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289546
barcode_type EAN
col1 permanent blue violet
col1_sortorder 4545
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 60-47-104.jpg
cost 5.14
deal_of_the_week NO
description permanent blue violet, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94281
list_price 12.95
map NO
mfr_num 100515366
net_weight 0.21
non_member_discount 34
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 94281
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.57
ta_dealer_c_price 5.57
ta_price 8.42
text
array
1 94281
2 100515366
3 permanent blue violet, 75 ml
timestamp 2015-03-26T14:52:26.119Z
vip_member_price 7.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079292942
barcode_type EAN
col1 permanent green deep
col1_sortorder 4560
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 63-74-0.jpg
cost 5.14
deal_of_the_week NO
description permanent green deep, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94288
list_price 12.95
map NO
mfr_num 100515373
net_weight 0.22
non_member_discount 34
non_member_price 8.61
prop65 NO
ship_rule_desc STD
shipping STD
sku 94288
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.57
ta_dealer_c_price 5.57
ta_price 8.42
text
array
1 94288
2 100515373
3 permanent green deep, 75 ml
timestamp 2015-03-26T14:52:26.134Z
vip_member_price 7.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e030b47606869f81aed22d5050361e4d3e62
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=modeling-materials&CatC=sort~1~fb~x-acto~fp~4-91~&gr=x-acto-no-10-general-purpose-blades.html
urltoken CFID=29206049&CFTOKEN=20668701&jsessionid=e030b47606869f81aed22d5050361e4d3e62
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-26 18:13:28'}
sessionid e03089dc211f47b5ed0c4847123415a5b342
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=acrylics&CatC=paints&gr=amsterdam-expert-acrylic-tubes.html
urltoken CFID=29206050&CFTOKEN=44299911&jsessionid=e03089dc211f47b5ed0c4847123415a5b342
validationerror [empty string]


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

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

ItemIDList: 55355,78608
AvailQtyList: 42.000000000000,9.000000000000

struct
FLAGS 0
VIP_member_discount 44
barcode 8712079289614
barcode_type EAN
col1 permanent green light
col1_sortorder 4562
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 79-164-0.jpg
cost 3.26
deal_of_the_week NO
description permanent green light, 75 ml
group_id 9682
group_uname amsterdam-expert-acrylic-tubes
id 94287
list_price 8.2
map NO
mfr_num 100515372
net_weight 0.21
non_member_discount 34
non_member_price 5.45
prop65 NO
ship_rule_desc STD
shipping STD
sku 94287
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.53
ta_dealer_c_price 3.53
ta_price 5.33
text
array
1 94287
2 100515372
3 permanent green light, 75 ml
timestamp 2015-03-26T14:52:26.132Z
vip_member_price 4.63

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 42.000000000000 55355
2 9.000000000000 78608
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] = '2571' 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.211.19.213

URL: