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

Indoor/Outdoor Spray Paint

by Krylon


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504016021
barcode_type UPC
col1 flat black
col1_sortorder 2177
col2 [empty string]
col3 [empty string]
color_swatch 0-0-0.jpg
cost 3.93
deal_of_the_week NO
description flat black
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 46726
list_price 11.5
map NO
mfr_num 51602
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 46726
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 46726
2 51602
3 flat black
timestamp 2015-03-27T14:47:20.801Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504015024
barcode_type UPC
col1 flat white
col1_sortorder 2186
col2 [empty string]
col3 [empty string]
color_swatch 255-255-255.jpg
cost 3.93
deal_of_the_week NO
description flat white
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 48638
list_price 11.5
map NO
mfr_num K01502
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 48638
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 48638
2 K01502
3 flat white
timestamp 2015-03-27T14:47:23.056Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504015062
barcode_type UPC
col1 gloss almond
col1_sortorder 2451
col2 [empty string]
col3 [empty string]
color_swatch 238-231-205.jpg
cost 3.93
deal_of_the_week NO
description gloss almond
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 48846
list_price 11.5
map NO
mfr_num 51506
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 48846
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 48846
2 51506
3 gloss almond
timestamp 2015-03-27T14:47:23.371Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504035497
barcode_type UPC
col1 gloss Bahamas sea
col1_sortorder 2452
col2 [empty string]
col3 [empty string]
color_swatch 60-130-147.jpg
cost 3.93
deal_of_the_week NO
description gloss Bahamas sea
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 42127
list_price 11.5
map NO
mfr_num 53549
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 42127
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 42127
2 53549
3 gloss Bahamas sea
timestamp 2015-03-27T14:47:14.592Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504021087
barcode_type UPC
col1 gloss banner red
col1_sortorder 2453
col2 [empty string]
col3 [empty string]
color_swatch 207-29-36.jpg
cost 3.93
deal_of_the_week NO
description gloss banner red
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 26560
list_price 11.5
map NO
mfr_num 52108
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 26560
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 26560
2 52108
3 gloss banner red
timestamp 2015-03-27T14:46:49.497Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504016014
barcode_type UPC
col1 gloss black
col1_sortorder 2455
col2 [empty string]
col3 [empty string]
color_swatch 0-0-0.jpg
cost 3.93
deal_of_the_week NO
description gloss black
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 42571
list_price 11.5
map NO
mfr_num 51601
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 42571
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 42571
2 51601
3 gloss black
timestamp 2015-03-27T14:47:15.047Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504035435
barcode_type UPC
col1 gloss celery
col1_sortorder 2456
col2 [empty string]
col3 [empty string]
color_swatch 190-213-164.jpg
cost 3.93
deal_of_the_week NO
description gloss celery
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 65049
list_price 11.5
map NO
mfr_num 3543
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 65049
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 65049
2 3543
3 gloss celery
timestamp 2015-03-27T14:47:46.436Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504021018
barcode_type UPC
col1 gloss cherry red
col1_sortorder 2457
col2 [empty string]
col3 [empty string]
color_swatch 159-27-30.jpg
cost 3.93
deal_of_the_week NO
description gloss cherry red
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 43012
list_price 11.5
map NO
mfr_num 52101
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 43012
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 43012
2 52101
3 gloss cherry red
timestamp 2015-03-27T14:47:15.649Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504020165
barcode_type UPC
col1 gloss emerald green
col1_sortorder 2458
col2 [empty string]
col3 [empty string]
color_swatch 0-121-79.jpg
cost 3.93
deal_of_the_week NO
description gloss emerald green
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 13283
list_price 11.5
map NO
mfr_num 52016
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 13283
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 13283
2 52016
3 gloss emerald green
timestamp 2015-03-27T14:46:28.63Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504020011
barcode_type UPC
col1 gloss hunter green
col1_sortorder 2460
col2 [empty string]
col3 [empty string]
color_swatch 17-86-74.jpg
cost 3.93
deal_of_the_week NO
description gloss hunter green
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 77065
list_price 11.5
map NO
mfr_num 52001
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 77065
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 77065
2 52001
3 gloss hunter green
timestamp 2015-03-27T14:48:06.941Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504015048
barcode_type UPC
col1 gloss ivory
col1_sortorder 2461
col2 [empty string]
col3 [empty string]
color_swatch 252-251-237.jpg
cost 3.93
deal_of_the_week NO
description gloss ivory
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 65552
list_price 11.5
map NO
mfr_num 51504
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 65552
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 65552
2 51504
3 gloss ivory
timestamp 2015-03-27T14:47:47.165Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504015154
barcode_type UPC
col1 gloss ivy leaf
col1_sortorder 2462
col2 [empty string]
col3 [empty string]
color_swatch 159-166-21.jpg
cost 3.93
deal_of_the_week NO
description gloss ivy leaf
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 56216
list_price 11.5
map NO
mfr_num 51515
net_weight 0.99
non_member_discount 43
non_member_price 6.56
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 56216
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 56216
2 51515
3 gloss ivy leaf
timestamp 2015-03-27T14:47:31.251Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504025047
barcode_type UPC
col1 gloss khaki
col1_sortorder 2463
col2 [empty string]
col3 [empty string]
color_swatch 197-171-134.jpg
cost 3.93
deal_of_the_week NO
description gloss khaki
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 52464
list_price 11.5
map NO
mfr_num 52504
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 52464
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 52464
2 52504
3 gloss khaki
timestamp 2015-03-27T14:47:27.843Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504025016
barcode_type UPC
col1 gloss leather brown
col1_sortorder 2464
col2 [empty string]
col3 [empty string]
color_swatch 110-74-45.jpg
cost 3.93
deal_of_the_week NO
description gloss leather brown
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 53641
list_price 11.5
map NO
mfr_num 52501
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 53641
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 53641
2 52501
3 gloss leather brown
timestamp 2015-03-27T14:47:28.607Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504035480
barcode_type UPC
col1 gloss mountain view
col1_sortorder 2465
col2 [empty string]
col3 [empty string]
color_swatch 122-122-210.jpg
cost 3.93
deal_of_the_week NO
description gloss mountain view
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 82508
list_price 11.5
map NO
mfr_num 3548
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 82508
sku_pix NO
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 82508
2 3548
3 gloss mountain view
timestamp 2015-03-27T14:48:13.207Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504016069
barcode_type UPC
col1 gloss pewter gray
col1_sortorder 2466
col2 [empty string]
col3 [empty string]
color_swatch 203-208-212.jpg
cost 3.93
deal_of_the_week NO
description gloss pewter gray
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 20348
list_price 11.5
map NO
mfr_num 51606
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 20348
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 20348
2 51606
3 gloss pewter gray
timestamp 2015-03-27T14:46:40.534Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504019138
barcode_type UPC
col1 gloss purple
col1_sortorder 2467
col2 [empty string]
col3 [empty string]
color_swatch 83-77-125.jpg
cost 3.93
deal_of_the_week NO
description gloss purple
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 14597
list_price 11.5
map NO
mfr_num 51913
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 14597
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 14597
2 51913
3 gloss purple
timestamp 2015-03-27T14:46:31.136Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504019015
barcode_type UPC
col1 gloss regal blue
col1_sortorder 2468
col2 [empty string]
col3 [empty string]
color_swatch 0-52-97.jpg
cost 3.93
deal_of_the_week NO
description gloss regal blue
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 38406
list_price 11.5
map NO
mfr_num 51901
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 38406
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 38406
2 51901
3 gloss regal blue
timestamp 2015-03-27T14:47:10.631Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504019145
barcode_type UPC
col1 gloss rich plum
col1_sortorder 2469
col2 [empty string]
col3 [empty string]
color_swatch 92-45-145.jpg
cost 3.93
deal_of_the_week NO
description gloss rich plum
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 56217
list_price 11.5
map NO
mfr_num 51914
net_weight 0.99
non_member_discount 43
non_member_price 6.56
prop65 NO
ship_rule_desc ORMD
shipping ORMD
sku 56217
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 56217
2 51914
3 gloss rich plum
timestamp 2015-03-27T14:47:31.253Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504035541
barcode_type UPC
col1 gloss saddle tan
col1_sortorder 2470
col2 [empty string]
col3 [empty string]
color_swatch 166-139-117.jpg
cost 3.93
deal_of_the_week NO
description gloss saddle tan
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 24189
list_price 11.5
map NO
mfr_num 53554
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 24189
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 24189
2 53554
3 gloss saddle tan
timestamp 2015-03-27T14:46:45.469Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504018063
barcode_type UPC
col1 gloss sun yellow
col1_sortorder 2471
col2 [empty string]
col3 [empty string]
color_swatch 255-229-0.jpg
cost 3.93
deal_of_the_week NO
description gloss sun yellow
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 59909
list_price 11.5
map NO
mfr_num 51806
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 59909
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 59909
2 51806
3 gloss sun yellow
timestamp 2015-03-27T14:47:37.357Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504019107
barcode_type UPC
col1 gloss true blue
col1_sortorder 2472
col2 [empty string]
col3 [empty string]
color_swatch 0-97-172.jpg
cost 3.93
deal_of_the_week NO
description gloss true blue
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 41034
list_price 11.5
map NO
mfr_num 51910
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 41034
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 41034
2 51910
3 gloss true blue
timestamp 2015-03-27T14:47:13.149Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504035350
barcode_type UPC
col1 gloss Tuscan sunset
col1_sortorder 2473
col2 [empty string]
col3 [empty string]
color_swatch 149-92-47.jpg
cost 3.93
deal_of_the_week NO
description gloss Tuscan sunset
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 65500
list_price 11.5
map NO
mfr_num 3535
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 65500
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 65500
2 3535
3 gloss Tuscan sunset
timestamp 2015-03-27T14:47:47.068Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504015017
barcode_type UPC
col1 gloss white
col1_sortorder 2474
col2 [empty string]
col3 [empty string]
color_swatch 255-255-255.jpg
cost 3.93
deal_of_the_week NO
description gloss white
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 16766
list_price 11.5
map NO
mfr_num 51501
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 16766
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 16766
2 51501
3 gloss white
timestamp 2015-03-27T14:46:36.322Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


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

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

ItemIDList: 54349,58916
AvailQtyList: 26.000000000000,18.000000000000

struct
FLAGS 0
VIP_member_discount 53
barcode 724504016137
barcode_type UPC
col1 satin black
col1_sortorder 5373
col2 [empty string]
col3 [empty string]
color_swatch 0-0-0.jpg
cost 3.93
deal_of_the_week NO
description satin black
group_id 973
group_uname krylon-indoor-outdoor-spray-paint
id 15575
list_price 11.5
map NO
mfr_num 51613
net_weight 1
non_member_discount 43
non_member_price 6.56
prop65 YES
ship_rule_desc ORMD
shipping ORMD
sku 15575
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.26
ta_dealer_c_price 4.26
ta_price 6.56
text
array
1 15575
2 51613
3 satin black
timestamp 2015-03-27T14:46:34.485Z
vip_member_price 5.41

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 26.000000000000 54349
2 18.000000000000 58916
CACHED false
EXECUTIONTIME 4
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] = '1545' 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.82.230.178

URL: www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 02:24:43'}
sessionid e030f4a5f616117082cc2628a43d5575654d
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=decorative-painting&CatC=sort~1~&gr=krylon-indoor-outdoor-spray-paint.html
urltoken CFID=30129479&CFTOKEN=34477531&jsessionid=e030f4a5f616117082cc2628a43d5575654d
validationerror [empty string]


No runs, no drips, no errors. A gloss or flat quality enamel. Sprays evenly and covers well. For use inside and out on wood, metal, plastic, wicker, and more. Dries to the touch in 15 minutes and cures in approximately 12 hours.

Krylon Spray Enamels come in 12 oz. spray cans.



Share on Facebook Twitter Pinterest

Ask a question about Indoor/Outdoor Spray Paint Ask a question about this product

Indoor/Outdoor Spray Paint

by Krylon

Average User Rating: Based on (6 Reviews)

5 6

Jude from Longbow Lake, Ontario, Canada says:

Sprayed a sanded antique table twice(sanding lightly with 0000 steel wool in between coats. Cannot find any more cans unless they contain primer. Tried a small amount for a final coat - the pain bubbled....[more]

[Read All Reviews] [Write a Review]









  Item# Swatch Image color
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
Indoor/Outdoor Spray Paint flat black
Zoom Image
flat black 51602 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint flat white
Zoom Image
flat white K01502 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss almond
Zoom Image
gloss almond 51506 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss Bahamas sea
Zoom Image
gloss Bahamas sea 53549 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss banner red
Zoom Image
gloss banner red 52108 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss black
Zoom Image
gloss black 51601 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss celery
Zoom Image
gloss celery 3543 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss cherry red
Zoom Image
gloss cherry red 52101 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss emerald green
Zoom Image
gloss emerald green 52016 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss hunter green
Zoom Image
gloss hunter green 52001 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss ivory
Zoom Image
gloss ivory 51504 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss ivy leaf
Zoom Image
gloss ivy leaf 51515 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss khaki
Zoom Image
gloss khaki 52504 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss leather brown
Zoom Image
gloss leather brown 52501 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
  gloss mountain view 3548 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss pewter gray
Zoom Image
gloss pewter gray 51606 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss purple
Zoom Image
gloss purple 51913 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss regal blue
Zoom Image
gloss regal blue 51901 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss rich plum
Zoom Image
gloss rich plum 51914 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss saddle tan
Zoom Image
gloss saddle tan 53554 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss sun yellow
Zoom Image
gloss sun yellow 51806 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss true blue
Zoom Image
gloss true blue 51910 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss Tuscan sunset
Zoom Image
gloss Tuscan sunset 3535 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint gloss white
Zoom Image
gloss white 51501 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock
Add to Favorites
Indoor/Outdoor Spray Paint satin black
Zoom Image
satin black 51613 $11.50 $6.56 43% Off $5.41 53% Off Email When In Stock

Use color swatches as a general guide. Actual colors may vary.

Click the to add item to your Favorites.



Please wait...
You May Also Like...

All Purpose Primers

by Krylon

Perfect for auto bodies and metal surfaces

From $6.34

Short Cuts

by Krylon

For those with small painting projects in mind.

From $2.43

Fluorescent Spray Paint

by Krylon

Maximum visibility

From $6.10

How to get VIP Club Prices
Anyone can be a VIP Member with:
  • Additional savings on all products
  • Express order handling
  • Exclusive promotions
  • Priority customer service
Only $25/year

Learn More »

Ask a Question About Indoor/Outdoor Spray Paint

Your email will not be shared. We will only use your email address to respond to your question. When asking your question, please be as descriptive as possible, it will allow us to give you the most accurate answer possible.

Customer Product Reviews
Write a Review
Write a Review
Rated by: Jude in Longbow Lake, Ontario, Canada
Sprayed a sanded antique table twice(sanding lightly with 0000 steel wool in between coats. Cannot find any more cans unless they contain primer. Tried a small amount for a final coat - the pain bubbled. I re sanded that section & am wondering what I can use since I can't get the original paint anywhere. p.s. I have used this paint on other pieces with perfect results.
Rated by: Pat Kerbs in Bartlesville, OK
I have been using it in my frameshop for years and it works perfectly for me everytime. Good coverage, fast drying, perfect.
Rated by: Komei N. in Chicago, IL
This products are good quality and the color was what I want to. I will buy the same products when I need spary for my products!!
Rated by: Belinda B. in Port Republic, MD
I'm painting small wood treasure chests.The paint has brillant color from a can.I spray several light layers to get a even vivid color.
Rated by: Dee W. in Baton Rouge, LA
I love this product. I spray painted an ice chest purple and gold (LSU colors) and it looks great. It dries evenly and doesn't look like it's spray paint.
Rated by: BRASS m. in los Angeles, CA
A clean, smooth finish & deep hue! I have been systematically spray-painting all my furniture and electronic appliances using these paints, with very professional results! One thing, each 12 oz. can covers apprx. one two-drawer file cabinet.

Write a Product Review for Indoor/Outdoor Spray Paint

Add Your Review

Tell us what you think. We appreciate you taking the time to share your opinion with other artists and crafters. Please keep your review detailed and specific.

Product reviews are intended to be a resource for artists interested in product quality and use. MisterArt.com reserves the right not to post any product review or to remove any published product review at any time without notice. Published reviews must conform to MisterArt.com guidelines. Your review may be posted on this page within five to ten business days.

Tips on Writing Reviews
Rating Scale
  • (5-Star) Excellent
  • (4-Star) Good
  • (3-Star) Average
  • (2-Star) Fair
  • (1-Star) Poor
Do:
  • Give your perspective on how you used the product and why you liked or disliked it.
  • Keep your reviews short enough to hold the audience's attention.
  • Be honest and mindful of others when providing editorial commentary.
Don't:
  • Include phone numbers, addresses, URLs, or HTML tags.
  • Write profanity, obscenities, vulgarities, or spiteful comments.
  • Make defamatory comments.
Please wait...
Please wait...