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

Duo Aqua Artist Oil Color

by Holbein


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232018
barcode_type EAN
col1 alizarin crimson
col1_sortorder 81
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 149-47-47.jpg
cost 8.58
deal_of_the_week NO
description alizarin crimson, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97163
list_price 18.75
map NO
mfr_num DU201
net_weight 0.13
non_member_discount 40
non_member_price 11.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 97163
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.38
ta_dealer_c_price 9.38
ta_price 14.05
text
array
1 97163
2 DU201
3 alizarin crimson, 40 ml
timestamp 2015-03-31T17:54:52.008Z
vip_member_price 10.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232094
barcode_type EAN
col1 anthraquinone red
col1_sortorder 138
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 210-0-72.jpg
cost 8.58
deal_of_the_week NO
description anthraquinone red, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97164
list_price 18.75
map NO
mfr_num DU209
net_weight 0.15
non_member_discount 40
non_member_price 11.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 97164
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.38
ta_dealer_c_price 9.38
ta_price 14.05
text
array
1 97164
2 DU209
3 anthraquinone red, 40 ml
timestamp 2015-03-31T17:54:52.013Z
vip_member_price 10.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232308
barcode_type EAN
col1 aureolin hue
col1_sortorder 256
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 195-173-92.jpg
cost 11.42
deal_of_the_week NO
description aureolin hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97165
list_price 24.95
map NO
mfr_num DU230
net_weight 0.19
non_member_discount 40
non_member_price 14.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 97165
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.48
ta_dealer_c_price 12.48
ta_price 18.72
text
array
1 97165
2 DU230
3 aureolin hue, 40 ml
timestamp 2015-03-31T17:54:52.016Z
vip_member_price 13.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232391
barcode_type EAN
col1 benzidine yellow
col1_sortorder 372
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 240-184-47.jpg
cost 8.58
deal_of_the_week NO
description benzidine yellow, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97166
list_price 18.75
map NO
mfr_num DU239
net_weight 0.16
non_member_discount 40
non_member_price 11.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 97166
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.38
ta_dealer_c_price 9.38
ta_price 14.05
text
array
1 97166
2 DU239
3 benzidine yellow, 40 ml
timestamp 2015-03-31T17:54:52.018Z
vip_member_price 10.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232162
barcode_type EAN
col1 brilliant pink
col1_sortorder 760
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 240-138-182.jpg
cost 8.58
deal_of_the_week NO
description brilliant pink, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97167
list_price 18.75
map NO
mfr_num DU216
net_weight 0.17
non_member_discount 40
non_member_price 11.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 97167
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.38
ta_dealer_c_price 9.38
ta_price 14.05
text
array
1 97167
2 DU216
3 brilliant pink, 40 ml
timestamp 2015-03-31T17:54:52.021Z
vip_member_price 10.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669233206
barcode_type EAN
col1 brown pink
col1_sortorder 817
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 149-92-47.jpg
cost 11.42
deal_of_the_week NO
description brown pink, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97168
list_price 24.95
map NO
mfr_num DU320
net_weight 0.15
non_member_discount 40
non_member_price 14.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 97168
sku_pix YES
supplier_id 1
ta_dealer_a_price 12.48
ta_dealer_c_price 12.48
ta_price 18.72
text
array
1 97168
2 DU320
3 brown pink, 40 ml
timestamp 2015-03-31T17:54:52.025Z
vip_member_price 13.47

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669233183
barcode_type EAN
col1 burnt sienna
col1_sortorder 876
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 149-66-47.jpg
cost 6.38
deal_of_the_week NO
description burnt sienna, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97169
list_price 13.95
map NO
mfr_num DU318
net_weight 0.18
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97169
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97169
2 DU318
3 burnt sienna, 40 ml
timestamp 2015-03-31T17:54:52.029Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669233176
barcode_type EAN
col1 burnt umber
col1_sortorder 887
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 119-48-0.jpg
cost 6.38
deal_of_the_week NO
description burnt umber, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97170
list_price 13.95
map NO
mfr_num DU317
net_weight 0.17
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97170
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97170
2 DU317
3 burnt umber, 40 ml
timestamp 2015-03-31T17:54:52.035Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232575
barcode_type EAN
col1 cadmium green
col1_sortorder 928
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 0-164-101.jpg
cost 15.85
deal_of_the_week NO
description cadmium green, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97180
list_price 34.65
map NO
mfr_num DU257
net_weight 0.17
non_member_discount 40
non_member_price 20.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 97180
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.33
ta_dealer_c_price 17.33
ta_price 26
text
array
1 97180
2 DU257
3 cadmium green, 40 ml
timestamp 2015-03-31T17:54:52.067Z
vip_member_price 18.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232476
barcode_type EAN
col1 cadmium green deep hue
col1_sortorder 930
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 0-74-60.jpg
cost 6.38
deal_of_the_week NO
description cadmium green deep hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97171
list_price 13.95
map NO
mfr_num DU247
net_weight 0.16
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97171
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97171
2 DU247
3 cadmium green deep hue, 40 ml
timestamp 2015-03-31T17:54:52.038Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232469
barcode_type EAN
col1 cadmium green hue
col1_sortorder 931
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 0-164-73.jpg
cost 6.38
deal_of_the_week NO
description cadmium green hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97172
list_price 13.95
map NO
mfr_num DU246
net_weight 0.16
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97172
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97172
2 DU246
3 cadmium green hue, 40 ml
timestamp 2015-03-31T17:54:52.04Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232568
barcode_type EAN
col1 cadmium green light
col1_sortorder 932
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 0-210-87.jpg
cost 15.85
deal_of_the_week NO
description cadmium green light, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97181
list_price 34.65
map NO
mfr_num DU256
net_weight 0.19
non_member_discount 40
non_member_price 20.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 97181
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.33
ta_dealer_c_price 17.33
ta_price 26
text
array
1 97181
2 DU256
3 cadmium green light, 40 ml
timestamp 2015-03-31T17:54:52.074Z
vip_member_price 18.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232452
barcode_type EAN
col1 cadmium green light hue
col1_sortorder 933
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 0-164-0.jpg
cost 6.38
deal_of_the_week NO
description cadmium green light hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97173
list_price 13.95
map NO
mfr_num DU245
net_weight 0.17
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97173
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97173
2 DU245
3 cadmium green light hue, 40 ml
timestamp 2015-03-31T17:54:52.042Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232186
barcode_type EAN
col1 cadmium orange
col1_sortorder 939
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 210-90-0.jpg
cost 19.95
deal_of_the_week NO
description cadmium orange, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97182
list_price 43.6
map NO
mfr_num DU218
net_weight 0.2
non_member_discount 40
non_member_price 26.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 97182
sku_pix YES
supplier_id 1
ta_dealer_a_price 21.8
ta_dealer_c_price 21.8
ta_price 32.69
text
array
1 97182
2 DU218
3 cadmium orange, 40 ml
timestamp 2015-03-31T17:54:52.267Z
vip_member_price 23.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232131
barcode_type EAN
col1 cadmium red
col1_sortorder 955
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 210-65-0.jpg
cost 19.95
deal_of_the_week NO
description cadmium red, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97183
list_price 43.6
map NO
mfr_num DU213
net_weight 0.2
non_member_discount 40
non_member_price 26.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 97183
sku_pix YES
supplier_id 1
ta_dealer_a_price 21.8
ta_dealer_c_price 21.8
ta_price 32.69
text
array
1 97183
2 DU213
3 cadmium red, 40 ml
timestamp 2015-03-31T17:54:52.274Z
vip_member_price 23.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232148
barcode_type EAN
col1 cadmium red deep
col1_sortorder 960
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 195-47-47.jpg
cost 19.95
deal_of_the_week NO
description cadmium red deep, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97184
list_price 43.6
map NO
mfr_num DU214
net_weight 0.21
non_member_discount 40
non_member_price 26.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 97184
sku_pix YES
supplier_id 1
ta_dealer_a_price 21.8
ta_dealer_c_price 21.8
ta_price 32.69
text
array
1 97184
2 DU214
3 cadmium red deep, 40 ml
timestamp 2015-03-31T17:54:52.276Z
vip_member_price 23.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232063
barcode_type EAN
col1 cadmium red deep hue
col1_sortorder 962
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 195-47-47.jpg
cost 6.38
deal_of_the_week NO
description cadmium red deep hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97174
list_price 13.95
map NO
mfr_num DU206
net_weight 0.15
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97174
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97174
2 DU206
3 cadmium red deep hue, 40 ml
timestamp 2015-03-31T17:54:52.045Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232056
barcode_type EAN
col1 cadmium red hue
col1_sortorder 969
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 195-47-80.jpg
cost 6.38
deal_of_the_week NO
description cadmium red hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97175
list_price 13.95
map NO
mfr_num DU205
net_weight 0.16
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97175
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97175
2 DU205
3 cadmium red hue, 40 ml
timestamp 2015-03-31T17:54:52.05Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232070
barcode_type EAN
col1 cadmium red purple hue
col1_sortorder 991
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 149-47-47.jpg
cost 6.38
deal_of_the_week NO
description cadmium red purple hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97176
list_price 13.95
map NO
mfr_num DU207
net_weight 0.17
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97176
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97176
2 DU207
3 cadmium red purple hue, 40 ml
timestamp 2015-03-31T17:54:52.056Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232377
barcode_type EAN
col1 cadmium yellow
col1_sortorder 997
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 240-213-47.jpg
cost 15.85
deal_of_the_week NO
description cadmium yellow, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97185
list_price 34.65
map NO
mfr_num DU237
net_weight 0.19
non_member_discount 40
non_member_price 20.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 97185
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.33
ta_dealer_c_price 17.33
ta_price 26
text
array
1 97185
2 DU237
3 cadmium yellow, 40 ml
timestamp 2015-03-31T17:54:52.278Z
vip_member_price 18.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232384
barcode_type EAN
col1 cadmium yellow deep
col1_sortorder 1002
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 240-184-47.jpg
cost 15.85
deal_of_the_week NO
description cadmium yellow deep, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97186
list_price 34.65
map NO
mfr_num DU238
net_weight 0.2
non_member_discount 40
non_member_price 20.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 97186
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.33
ta_dealer_c_price 17.33
ta_price 26
text
array
1 97186
2 DU238
3 cadmium yellow deep, 40 ml
timestamp 2015-03-31T17:54:52.28Z
vip_member_price 18.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232339
barcode_type EAN
col1 cadmium yellow deep hue
col1_sortorder 1004
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 240-169-47.jpg
cost 6.38
deal_of_the_week NO
description cadmium yellow deep hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97177
list_price 13.95
map NO
mfr_num DU233
net_weight 0.16
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97177
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97177
2 DU233
3 cadmium yellow deep hue, 40 ml
timestamp 2015-03-31T17:54:52.058Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232322
barcode_type EAN
col1 cadmium yellow hue
col1_sortorder 1009
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 240-184-47.jpg
cost 6.38
deal_of_the_week NO
description cadmium yellow hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97178
list_price 13.95
map NO
mfr_num DU232
net_weight 0.16
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97178
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97178
2 DU232
3 cadmium yellow hue, 40 ml
timestamp 2015-03-31T17:54:52.06Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232360
barcode_type EAN
col1 cadmium yellow lemon
col1_sortorder 1010
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 240-240-92.jpg
cost 15.85
deal_of_the_week NO
description cadmium yellow lemon, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97187
list_price 34.65
map NO
mfr_num DU236
net_weight 0.19
non_member_discount 40
non_member_price 20.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 97187
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.33
ta_dealer_c_price 17.33
ta_price 26
text
array
1 97187
2 DU236
3 cadmium yellow lemon, 40 ml
timestamp 2015-03-31T17:54:52.282Z
vip_member_price 18.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232315
barcode_type EAN
col1 cadmium yellow light hue
col1_sortorder 1015
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 240-229-92.jpg
cost 6.38
deal_of_the_week NO
description cadmium yellow light hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97179
list_price 13.95
map NO
mfr_num DU231
net_weight 0.16
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97179
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97179
2 DU231
3 cadmium yellow light hue, 40 ml
timestamp 2015-03-31T17:54:52.063Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669234623
barcode_type EAN
col1 ceramic white
col1_sortorder 1152
col2 50 ml
col2_sortorder 2028
col3 [empty string]
color_swatch 255-255-255.jpg
cost 13.49
deal_of_the_week NO
description ceramic white, 50 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97217
list_price 29.5
map NO
mfr_num DU462
net_weight 0.26
non_member_discount 40
non_member_price 17.7
prop65 NO
ship_rule_desc STD
shipping STD
sku 97217
sku_pix YES
supplier_id 1
ta_dealer_a_price 14.75
ta_dealer_c_price 14.75
ta_price 22.12
text
array
1 97217
2 DU462
3 ceramic white, 50 ml
timestamp 2015-03-31T17:54:52.607Z
vip_member_price 15.93

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669235620
barcode_type EAN
col1 ceramic white
col1_sortorder 1152
col2 110 ml
col2_sortorder 813
col3 [empty string]
color_swatch 255-255-255.jpg
cost 26.06
deal_of_the_week NO
description ceramic white, 110 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97220
list_price 56.95
map NO
mfr_num DU562
net_weight 0.68
non_member_discount 40
non_member_price 34.17
prop65 NO
ship_rule_desc STD
shipping STD
sku 97220
sku_pix YES
supplier_id 1
ta_dealer_a_price 28.48
ta_dealer_c_price 28.48
ta_price 42.71
text
array
1 97220
2 DU562
3 ceramic white, 110 ml
timestamp 2015-03-31T17:54:52.618Z
vip_member_price 30.75

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232803
barcode_type EAN
col1 cerulean blue
col1_sortorder 1155
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 0-98-210.jpg
cost 19.95
deal_of_the_week NO
description cerulean blue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97188
list_price 43.6
map NO
mfr_num DU280
net_weight 0.19
non_member_discount 40
non_member_price 26.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 97188
sku_pix YES
supplier_id 1
ta_dealer_a_price 21.8
ta_dealer_c_price 21.8
ta_price 32.69
text
array
1 97188
2 DU280
3 cerulean blue, 40 ml
timestamp 2015-03-31T17:54:52.283Z
vip_member_price 23.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232711
barcode_type EAN
col1 cerulean blue hue
col1_sortorder 1164
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 122-166-210.jpg
cost 8.58
deal_of_the_week NO
description cerulean blue hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97189
list_price 18.75
map NO
mfr_num DU271
net_weight 0.2
non_member_discount 40
non_member_price 11.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 97189
sku_pix YES
supplier_id 1
ta_dealer_a_price 9.38
ta_dealer_c_price 9.38
ta_price 14.06
text
array
1 97189
2 DU271
3 cerulean blue hue, 40 ml
timestamp 2015-03-31T17:54:52.286Z
vip_member_price 10.13

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232810
barcode_type EAN
col1 cobalt blue
col1_sortorder 1353
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 0-81-164.jpg
cost 19.95
deal_of_the_week NO
description cobalt blue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97190
list_price 43.6
map NO
mfr_num DU281
net_weight 0.18
non_member_discount 40
non_member_price 26.16
prop65 NO
ship_rule_desc STD
shipping STD
sku 97190
sku_pix YES
supplier_id 1
ta_dealer_a_price 21.8
ta_dealer_c_price 21.8
ta_price 32.69
text
array
1 97190
2 DU281
3 cobalt blue, 40 ml
timestamp 2015-03-31T17:54:52.288Z
vip_member_price 23.54

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232759
barcode_type EAN
col1 cobalt blue hue
col1_sortorder 1358
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 0-64-164.jpg
cost 6.38
deal_of_the_week NO
description cobalt blue hue, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97191
list_price 13.95
map NO
mfr_num DU275
net_weight 0.17
non_member_discount 40
non_member_price 8.37
prop65 NO
ship_rule_desc STD
shipping STD
sku 97191
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.98
ta_dealer_c_price 6.98
ta_price 10.46
text
array
1 97191
2 DU275
3 cobalt blue hue, 40 ml
timestamp 2015-03-31T17:54:52.292Z
vip_member_price 7.53

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:44'}
sessionid e030409237fc081f4326117ce353a712e6d4
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html
urltoken CFID=30599337&CFTOKEN=85260192&jsessionid=e030409237fc081f4326117ce353a712e6d4
validationerror [empty string]


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

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

ItemIDList: 59160
AvailQtyList: 14.000000000000

struct
FLAGS 0
VIP_member_discount 46
barcode 4900669232551
barcode_type EAN
col1 cobalt green deep
col1_sortorder 1373
col2 40 ml
col2_sortorder 1850
col3 [empty string]
color_swatch 0-119-77.jpg
cost 15.85
deal_of_the_week NO
description cobalt green deep, 40 ml
group_id 10193
group_uname holbein-duo-aqua-artist-oil-color
id 97192
list_price 34.65
map NO
mfr_num DU255
net_weight 0.23
non_member_discount 40
non_member_price 20.79
prop65 YES
ship_rule_desc STD
shipping STD
sku 97192
sku_pix YES
supplier_id 1
ta_dealer_a_price 17.33
ta_dealer_c_price 17.33
ta_price 26
text
array
1 97192
2 DU255
3 cobalt green deep, 40 ml
timestamp 2015-03-31T17:54:52.298Z
vip_member_price 18.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 14.000000000000 59160
CACHED false
EXECUTIONTIME 2
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] = '13504' 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.204.246.41

URL: www.misterart.com:/index.cfm:module=painting&catB=oil-paints&CatC=sort~1~&gr=holbein-duo-aqua-artist-oil-color.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-31 19:24:45'}
sessionid e030d9009a5372838a04a3d2a53f77f1d264
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=sculpting&catB=sort~1~fp~8-17~&gr=walnut-hollow-creative-woodburner-detailer-tool.html
urltoken CFID=30599338&CFTOKEN=66701533&jsessionid=e030d9009a5372838a04a3d2a53f77f1d264
validationerror [empty string]


EndSessionVariables: