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

Graduate Acrylic Paint

by Daler-Rowney


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386020471
barcode_type EAN
col1 black
col1_sortorder 402
col2 120 ml
col2_sortorder 888
col3 [empty string]
cost 2.7
deal_of_the_week NO
description black, 120 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 03187
list_price 6.3
map NO
mfr_num 123120026
net_weight 0.16
non_member_discount 35
non_member_price 4.1
prop65 NO
ship_rule_desc STD
shipping STD
sku 03187
sku_pix NO
supplier_id 1
ta_dealer_a_price 3.15
ta_dealer_c_price 2.96
ta_price 4.41
text
array
1 03187
2 123120026
3 black, 120 ml
timestamp 2015-03-31T17:52:19.857Z
vip_member_price 3.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084107
barcode_type EAN
col1 black
col1_sortorder 402
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 0-0-0.jpg
cost 2.11
deal_of_the_week NO
description black, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99666
list_price 4.95
map NO
mfr_num 123075026
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99666
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99666
2 123075026
3 black, 75 ml
timestamp 2015-03-31T17:54:58.29Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084008
barcode_type EAN
col1 buff titanium
col1_sortorder 847
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 255-237-168.jpg
cost 2.11
deal_of_the_week NO
description buff titanium, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99665
list_price 4.95
map NO
mfr_num 123075024
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99665
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99665
2 123075024
3 buff titanium, 75 ml
timestamp 2015-03-31T17:54:58.285Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084046
barcode_type EAN
col1 burnt sienna
col1_sortorder 876
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 119-60-0.jpg
cost 2.11
deal_of_the_week NO
description burnt sienna, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99677
list_price 4.95
map NO
mfr_num 123075201
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99677
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99677
2 123075201
3 burnt sienna, 75 ml
timestamp 2015-03-31T17:54:58.33Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084060
barcode_type EAN
col1 burnt umber
col1_sortorder 887
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 74-40-0.jpg
cost 2.11
deal_of_the_week NO
description burnt umber, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99678
list_price 4.95
map NO
mfr_num 123075225
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99678
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99678
2 123075225
3 burnt umber, 75 ml
timestamp 2015-03-31T17:54:58.335Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083797
barcode_type EAN
col1 cadmium orange hue
col1_sortorder 948
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 255-153-0.jpg
cost 2.11
deal_of_the_week NO
description cadmium orange hue, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99698
list_price 4.95
map NO
mfr_num 123075619
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99698
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99698
2 123075619
3 cadmium orange hue, 75 ml
timestamp 2015-03-31T17:54:58.402Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083827
barcode_type EAN
col1 cadmium red deep hue
col1_sortorder 962
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 195-47-47.jpg
cost 2.11
deal_of_the_week NO
description cadmium red deep hue, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99688
list_price 4.95
map NO
mfr_num 123075504
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99688
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99688
2 123075504
3 cadmium red deep hue, 75 ml
timestamp 2015-03-31T17:54:58.365Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083810
barcode_type EAN
col1 cadmium red hue
col1_sortorder 969
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 210-0-0.jpg
cost 2.11
deal_of_the_week NO
description cadmium red hue, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99687
list_price 4.95
map NO
mfr_num 123075500
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99687
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99687
2 123075500
3 cadmium red hue, 75 ml
timestamp 2015-03-31T17:54:58.36Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083780
barcode_type EAN
col1 cadmium yellow deep
col1_sortorder 1002
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 255-173-0.jpg
cost 2.11
deal_of_the_week NO
description cadmium yellow deep, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99697
list_price 4.95
map NO
mfr_num 123075618
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99697
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99697
2 123075618
3 cadmium yellow deep, 75 ml
timestamp 2015-03-31T17:54:58.397Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083773
barcode_type EAN
col1 cadmium yellow hue
col1_sortorder 1009
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 255-223-0.jpg
cost 2.11
deal_of_the_week NO
description cadmium yellow hue, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99696
list_price 4.95
map NO
mfr_num 123075605
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99696
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99696
2 123075605
3 cadmium yellow hue, 75 ml
timestamp 2015-03-31T17:54:58.391Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083919
barcode_type EAN
col1 cobalt blue hue
col1_sortorder 1358
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 47-47-195.jpg
cost 2.11
deal_of_the_week NO
description cobalt blue hue, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99670
list_price 4.95
map NO
mfr_num 123075110
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99670
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99670
2 123075110
3 cobalt blue hue, 75 ml
timestamp 2015-03-31T17:54:58.302Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083926
barcode_type EAN
col1 coeruleum blue
col1_sortorder 1416
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 47-102-195.jpg
cost 2.11
deal_of_the_week NO
description coeruleum blue, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99673
list_price 4.95
map NO
mfr_num 123075130
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99673
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99673
2 123075130
3 coeruleum blue, 75 ml
timestamp 2015-03-31T17:54:58.316Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083834
barcode_type EAN
col1 crimson
col1_sortorder 1609
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 164-0-0.jpg
cost 2.11
deal_of_the_week NO
description crimson, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99691
list_price 4.95
map NO
mfr_num 123075542
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99691
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99691
2 123075542
3 crimson, 75 ml
timestamp 2015-03-31T17:54:58.374Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083964
barcode_type EAN
col1 emerald
col1_sortorder 2031
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 0-119-0.jpg
cost 2.11
deal_of_the_week NO
description emerald, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99680
list_price 4.95
map NO
mfr_num 123075335
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99680
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99680
2 123075335
3 emerald, 75 ml
timestamp 2015-03-31T17:54:58.34Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083995
barcode_type EAN
col1 hooker's green
col1_sortorder 2846
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 63-119-0.jpg
cost 2.11
deal_of_the_week NO
description hooker's green, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99681
list_price 4.95
map NO
mfr_num 123075343
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99681
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99681
2 123075343
3 hooker's green, 75 ml
timestamp 2015-03-31T17:54:58.342Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084145
barcode_type EAN
col1 imitation gold
col1_sortorder 2922
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 164-136-0.jpg
cost 2.11
deal_of_the_week NO
description imitation gold, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99702
list_price 4.95
map NO
mfr_num 123075701
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99702
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99702
2 123075701
3 imitation gold, 75 ml
timestamp 2015-03-31T17:54:58.415Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084138
barcode_type EAN
col1 imitation silver
col1_sortorder 2924
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 165-165-165.jpg
cost 2.11
deal_of_the_week NO
description imitation silver, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99703
list_price 4.95
map NO
mfr_num 123075702
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99703
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99703
2 123075702
3 imitation silver, 75 ml
timestamp 2015-03-31T17:54:58.42Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083889
barcode_type EAN
col1 indigo
col1_sortorder 2951
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 0-42-74.jpg
cost 2.11
deal_of_the_week NO
description indigo, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99672
list_price 4.95
map NO
mfr_num 123075127
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99672
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99672
2 123075127
3 indigo, 75 ml
timestamp 2015-03-31T17:54:58.314Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083971
barcode_type EAN
col1 leaf green
col1_sortorder 3260
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 134-195-47.jpg
cost 2.11
deal_of_the_week NO
description leaf green, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99682
list_price 4.95
map NO
mfr_num 123075355
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99682
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99682
2 123075355
3 leaf green, 75 ml
timestamp 2015-03-31T17:54:58.346Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386083759
barcode_type EAN
col1 lemon yellow
col1_sortorder 3283
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 255-242-77.jpg
cost 2.11
deal_of_the_week NO
description lemon yellow, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99700
list_price 4.95
map NO
mfr_num 123075651
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99700
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99700
2 123075651
3 lemon yellow, 75 ml
timestamp 2015-03-31T17:54:58.406Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084206
barcode_type EAN
col1 metallic blue
col1_sortorder 3698
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 0-75-210.jpg
cost 2.11
deal_of_the_week NO
description metallic blue, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99704
list_price 4.95
map NO
mfr_num 123075718
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99704
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99704
2 123075718
3 metallic blue, 75 ml
timestamp 2015-03-31T17:54:58.422Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084220
barcode_type EAN
col1 metallic brown
col1_sortorder 3701
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 195-95-47.jpg
cost 2.11
deal_of_the_week NO
description metallic brown, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99707
list_price 4.95
map NO
mfr_num 123075721
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99707
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99707
2 123075721
3 metallic brown, 75 ml
timestamp 2015-03-31T17:54:58.43Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084213
barcode_type EAN
col1 metallic green
col1_sortorder 3716
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 0-164-144.jpg
cost 2.11
deal_of_the_week NO
description metallic green, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99705
list_price 4.95
map NO
mfr_num 123075719
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99705
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99705
2 123075719
3 metallic green, 75 ml
timestamp 2015-03-31T17:54:58.424Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084190
barcode_type EAN
col1 metallic pink
col1_sortorder 3723
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 210-0-139.jpg
cost 2.11
deal_of_the_week NO
description metallic pink, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99708
list_price 4.95
map NO
mfr_num 123075722
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99708
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99708
2 123075722
3 metallic pink, 75 ml
timestamp 2015-03-31T17:54:58.435Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084183
barcode_type EAN
col1 metallic red
col1_sortorder 3726
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 210-0-0.jpg
cost 2.11
deal_of_the_week NO
description metallic red, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99706
list_price 4.95
map NO
mfr_num 123075720
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99706
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99706
2 123075720
3 metallic red, 75 ml
timestamp 2015-03-31T17:54:58.427Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084176
barcode_type EAN
col1 metallic yellow
col1_sortorder 3746
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 255-208-0.jpg
cost 2.11
deal_of_the_week NO
description metallic yellow, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99709
list_price 4.95
map NO
mfr_num 123075723
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99709
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99709
2 123075723
3 metallic yellow, 75 ml
timestamp 2015-03-31T17:54:58.44Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084114
barcode_type EAN
col1 mixing white
col1_sortorder 3812
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 255-255-255.jpg
cost 2.11
deal_of_the_week NO
description mixing white, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99662
list_price 4.95
map NO
mfr_num 123075006
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99662
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99662
2 123075006
3 mixing white, 75 ml
timestamp 2015-03-31T17:54:58.274Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084022
barcode_type EAN
col1 Naples yellow
col1_sortorder 3907
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 240-226-47.jpg
cost 2.11
deal_of_the_week NO
description Naples yellow, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99699
list_price 4.95
map NO
mfr_num 123075634
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99699
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99699
2 123075634
3 Naples yellow, 75 ml
timestamp 2015-03-31T17:54:58.404Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084084
barcode_type EAN
col1 neutral grey
col1_sortorder 4049
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 165-165-165.jpg
cost 2.11
deal_of_the_week NO
description neutral grey, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99669
list_price 4.95
map NO
mfr_num 123075084
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99669
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99669
2 123075084
3 neutral grey, 75 ml
timestamp 2015-03-31T17:54:58.299Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084091
barcode_type EAN
col1 Payne's grey
col1_sortorder 4427
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 45-45-45.jpg
cost 2.11
deal_of_the_week NO
description Payne's grey, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99668
list_price 4.95
map NO
mfr_num 123075065
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99668
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99668
2 123075065
3 Payne's grey, 75 ml
timestamp 2015-03-31T17:54:58.295Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084152
barcode_type EAN
col1 pearl black
col1_sortorder 4458
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 15-15-15.jpg
cost 2.11
deal_of_the_week NO
description pearl black, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99667
list_price 4.95
map NO
mfr_num 123075032
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99667
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99667
2 123075032
3 pearl black, 75 ml
timestamp 2015-03-31T17:54:58.292Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


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

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

ItemIDList: 16661
AvailQtyList: 11.000000000000

struct
FLAGS 0
VIP_member_discount 45
barcode 5011386084169
barcode_type EAN
col1 pearl white
col1_sortorder 4488
col2 75 ml
col2_sortorder 2245
col3 [empty string]
color_swatch 240-240-240.jpg
cost 2.11
deal_of_the_week NO
description pearl white, 75 ml
group_id 10518
group_uname daler-rowney-graduate-acrylic-paint
id 99664
list_price 4.95
map NO
mfr_num 123075020
net_weight 0.16
non_member_discount 35
non_member_price 3.22
prop65 NO
ship_rule_desc STD
shipping STD
sku 99664
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.48
ta_dealer_c_price 2.33
ta_price 3.47
text
array
1 99664
2 123075020
3 pearl white, 75 ml
timestamp 2015-03-31T17:54:58.28Z
vip_member_price 2.72

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 11.000000000000 16661
CACHED false
EXECUTIONTIME 171
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] = '9030' 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.90.251.197

URL: www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-04-01 10:08:32'}
sessionid e0306f71d04f65663f505a194a20d92229b1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~daler-rowney~fp~2-4~&gr=daler-rowney-graduate-acrylic-paint.html
urltoken CFID=30765507&CFTOKEN=76384643&jsessionid=e0306f71d04f65663f505a194a20d92229b1
validationerror [empty string]


EndSessionVariables: