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

Push Pins

by Moore


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228061057
barcode_type UPC
col1 5/8 in.
col2 aluminum
col2_sortorder 1
col3 pack of 100
col3_sortorder 491
cost 6.59
deal_of_the_week NO
description 5/8 in., aluminum, pack of 100
group_id 1145
group_uname moore-push-pins
id 30020
list_price 11.99
map NO
mfr_num 5-100
net_weight 0.32
non_member_discount 26
non_member_price 8.92
prop65 NO
ship_rule_desc STD
shipping STD
sku 30020
sku_pix YES
supplier_id 1
ta_dealer_a_price 7.19
ta_dealer_c_price 7.19
ta_price 10.79
text
array
1 30020
2 5-100
3 5/8 in., aluminum, pack of 100
timestamp 2015-03-26T14:50:54.524Z
vip_member_price 7.97

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228062016
barcode_type UPC
col1 3/8 in.
col2 aluminum
col2_sortorder 1
col3 pack of 20
col3_sortorder 425
cost 1.32
deal_of_the_week NO
description 3/8 in., aluminum, pack of 20
group_id 1145
group_uname moore-push-pins
id 46723
list_price 2.39
map NO
mfr_num 3-20
net_weight 0.04
non_member_discount 26
non_member_price 1.78
prop65 NO
ship_rule_desc STD
shipping STD
sku 46723
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.43
ta_dealer_c_price 1.43
ta_price 2.15
text
array
1 46723
2 3-20
3 3/8 in., aluminum, pack of 20
timestamp 2015-03-26T14:51:17.963Z
vip_member_price 1.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228061040
barcode_type UPC
col1 1/2 in.
col2 aluminum
col2_sortorder 1
col3 pack of 100
col3_sortorder 491
cost 6.37
deal_of_the_week NO
description 1/2 in., aluminum, pack of 100
group_id 1145
group_uname moore-push-pins
id 62668
list_price 11.59
map NO
mfr_num 4-100
net_weight 0.32
non_member_discount 26
non_member_price 8.62
prop65 NO
ship_rule_desc STD
shipping STD
sku 62668
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.95
ta_dealer_c_price 6.95
ta_price 10.43
text
array
1 62668
2 4-100
3 1/2 in., aluminum, pack of 100
timestamp 2015-03-26T14:51:43.144Z
vip_member_price 7.71

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228061033
barcode_type UPC
col1 3/8 in.
col2 aluminum
col2_sortorder 1
col3 pack of 100
col3_sortorder 491
cost 6.09
deal_of_the_week NO
description 3/8 in., aluminum, pack of 100
group_id 1145
group_uname moore-push-pins
id 62724
list_price 11.09
map NO
mfr_num 3-100
net_weight 0.32
non_member_discount 26
non_member_price 8.25
prop65 NO
ship_rule_desc STD
shipping STD
sku 62724
sku_pix YES
supplier_id 1
ta_dealer_a_price 6.65
ta_dealer_c_price 6.65
ta_price 9.98
text
array
1 62724
2 3-100
3 3/8 in., aluminum, pack of 100
timestamp 2015-03-26T14:51:43.248Z
vip_member_price 7.37

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228071988
barcode_type UPC
col1 assorted day-glo
col1_sortorder 230
col2 plastic
col2_sortorder 35
col3 pack of 100
col3_sortorder 491
cost 4
deal_of_the_week NO
description assorted day-glo, plastic, pack of 100
group_id 1145
group_uname moore-push-pins
id 94781
list_price 7.29
map NO
mfr_num 2P-100-ADG
net_weight 0.15
non_member_discount 26
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 94781
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.37
ta_dealer_c_price 4.37
ta_price 6.56
text
array
1 94781
2 2P-100-ADG
3 assorted day-glo, plastic, pack of 100
timestamp 2015-03-26T14:52:26.53Z
vip_member_price 4.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228072978
barcode_type UPC
col1 assorted gem stone
col1_sortorder 231
col2 plastic
col2_sortorder 35
col3 pack of 20
col3_sortorder 425
cost 1.1
deal_of_the_week NO
description assorted gem stone, plastic, pack of 20
group_id 1145
group_uname moore-push-pins
id 19403
list_price 1.99
map NO
mfr_num 2P-20-AGS
net_weight 0.04
non_member_discount 26
non_member_price 1.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 19403
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.19
ta_dealer_c_price 1.19
ta_price 1.79
text
array
1 19403
2 2P-20-AGS
3 assorted gem stone, plastic, pack of 20
timestamp 2015-03-26T14:50:40.71Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228071971
barcode_type UPC
col1 assorted gem stone
col1_sortorder 231
col2 plastic
col2_sortorder 35
col3 pack of 100
col3_sortorder 491
cost 4
deal_of_the_week NO
description assorted gem stone, plastic, pack of 100
group_id 1145
group_uname moore-push-pins
id 26154
list_price 7.29
map NO
mfr_num 2P-100-AGS
net_weight 0.14
non_member_discount 26
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 26154
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.37
ta_dealer_c_price 4.37
ta_price 6.56
text
array
1 26154
2 2P-100-AGS
3 assorted gem stone, plastic, pack of 100
timestamp 2015-03-26T14:50:49.442Z
vip_member_price 4.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228072961
barcode_type UPC
col1 assorted pastels
col1_sortorder 237
col2 plastic
col2_sortorder 35
col3 pack of 20
col3_sortorder 425
cost 1.1
deal_of_the_week NO
description assorted pastels, plastic, pack of 20
group_id 1145
group_uname moore-push-pins
id 30685
list_price 1.99
map NO
mfr_num 2P-20 AFP
net_weight 0.02
non_member_discount 26
non_member_price 1.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 30685
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.19
ta_dealer_c_price 1.19
ta_price 1.79
text
array
1 30685
2 2P-20 AFP
3 assorted pastels, plastic, pack of 20
timestamp 2015-03-26T14:50:56.358Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228072992
barcode_type UPC
col1 assorted regular
col1_sortorder 238
col2 plastic
col2_sortorder 35
col3 pack of 20
col3_sortorder 425
cost 1.1
deal_of_the_week NO
description assorted regular, plastic, pack of 20
group_id 1145
group_uname moore-push-pins
id 14247
list_price 1.99
map NO
mfr_num 2P-20-AR
net_weight 0.02
non_member_discount 26
non_member_price 1.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 14247
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.19
ta_dealer_c_price 1.19
ta_price 1.79
text
array
1 14247
2 2P-20-AR
3 assorted regular, plastic, pack of 20
timestamp 2015-03-26T14:50:32.821Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228071995
barcode_type UPC
col1 assorted regular
col1_sortorder 238
col2 plastic
col2_sortorder 35
col3 pack of 100
col3_sortorder 491
cost 4
deal_of_the_week NO
description assorted regular, plastic, pack of 100
group_id 1145
group_uname moore-push-pins
id 85728
list_price 7.29
map NO
mfr_num 2P-100-AR
net_weight 0.2
non_member_discount 26
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 85728
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.37
ta_dealer_c_price 4.37
ta_price 6.56
text
array
1 85728
2 2P-100-AR
3 assorted regular, plastic, pack of 100
timestamp 2015-03-26T14:52:17.63Z
vip_member_price 4.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228072077
barcode_type UPC
col1 black
col1_sortorder 402
col2 plastic
col2_sortorder 35
col3 pack of 20
col3_sortorder 425
cost 1.1
deal_of_the_week NO
description black, plastic, pack of 20
group_id 1145
group_uname moore-push-pins
id 94762
list_price 1.99
map NO
mfr_num 2P-20-BK
net_weight 0.04
non_member_discount 26
non_member_price 1.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 94762
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.19
ta_dealer_c_price 1.19
ta_price 1.79
text
array
1 94762
2 2P-20-BK
3 black, plastic, pack of 20
timestamp 2015-03-26T14:52:26.314Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228071070
barcode_type UPC
col1 black
col1_sortorder 402
col2 plastic
col2_sortorder 35
col3 pack of 100
col3_sortorder 491
cost 4
deal_of_the_week NO
description black, plastic, pack of 100
group_id 1145
group_uname moore-push-pins
id 94780
list_price 7.29
map NO
mfr_num 2P-100-BK
net_weight 0.15
non_member_discount 26
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 94780
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.37
ta_dealer_c_price 4.37
ta_price 6.56
text
array
1 94780
2 2P-100-BK
3 black, plastic, pack of 100
timestamp 2015-03-26T14:52:26.527Z
vip_member_price 4.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228072046
barcode_type UPC
col1 blue
col1_sortorder 542
col2 plastic
col2_sortorder 35
col3 pack of 20
col3_sortorder 425
cost 1.1
deal_of_the_week NO
description blue, plastic, pack of 20
group_id 1145
group_uname moore-push-pins
id 94761
list_price 1.99
map NO
mfr_num 2P-20-BE
net_weight 0.04
non_member_discount 26
non_member_price 1.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 94761
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.19
ta_dealer_c_price 1.19
ta_price 1.79
text
array
1 94761
2 2P-20-BE
3 blue, plastic, pack of 20
timestamp 2015-03-26T14:52:26.311Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228071049
barcode_type UPC
col1 blue
col1_sortorder 542
col2 plastic
col2_sortorder 35
col3 pack of 100
col3_sortorder 491
cost 4
deal_of_the_week NO
description blue, plastic, pack of 100
group_id 1145
group_uname moore-push-pins
id 94777
list_price 7.29
map NO
mfr_num 2P-100-BE
net_weight 0.15
non_member_discount 26
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 94777
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.37
ta_dealer_c_price 4.37
ta_price 6.56
text
array
1 94777
2 2P-100-BE
3 blue, plastic, pack of 100
timestamp 2015-03-26T14:52:26.519Z
vip_member_price 4.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228072008
barcode_type UPC
col1 clear
col1_sortorder 1318
col2 plastic
col2_sortorder 35
col3 pack of 20
col3_sortorder 425
cost 1.1
deal_of_the_week NO
description clear, plastic, pack of 20
group_id 1145
group_uname moore-push-pins
id 10207
list_price 1.99
map NO
mfr_num 2P-20-CR
net_weight 0.02
non_member_discount 26
non_member_price 1.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 10207
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.19
ta_dealer_c_price 1.19
ta_price 1.79
text
array
1 10207
2 2P-20-CR
3 clear, plastic, pack of 20
timestamp 2015-03-26T14:50:26.606Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228071001
barcode_type UPC
col1 clear
col1_sortorder 1318
col2 plastic
col2_sortorder 35
col3 pack of 100
col3_sortorder 491
cost 4
deal_of_the_week NO
description clear, plastic, pack of 100
group_id 1145
group_uname moore-push-pins
id 45677
list_price 7.29
map NO
mfr_num 2P-100-CR
net_weight 0.2
non_member_discount 26
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 45677
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.37
ta_dealer_c_price 4.37
ta_price 6.56
text
array
1 45677
2 2P-100-CR
3 clear, plastic, pack of 100
timestamp 2015-03-26T14:51:16.188Z
vip_member_price 4.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228073302
barcode_type UPC
col1 golden oak
col1_sortorder 2548
col2 wood
col2_sortorder 47
col3 pack of 20
col3_sortorder 425
cost 2.2
deal_of_the_week NO
description golden oak, wood, pack of 20
group_id 1145
group_uname moore-push-pins
id 39738
list_price 3.99
map NO
mfr_num 2W-20-GO
net_weight 0.1
non_member_discount 26
non_member_price 2.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 39738
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.39
ta_dealer_c_price 2.39
ta_price 3.59
text
array
1 39738
2 2W-20-GO
3 golden oak, wood, pack of 20
timestamp 2015-03-26T14:51:09.608Z
vip_member_price 2.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228072060
barcode_type UPC
col1 green
col1_sortorder 2621
col2 plastic
col2_sortorder 35
col3 pack of 20
col3_sortorder 425
cost 1.1
deal_of_the_week NO
description green, plastic, pack of 20
group_id 1145
group_uname moore-push-pins
id 94763
list_price 1.99
map NO
mfr_num 2P-20-GN
net_weight 0.04
non_member_discount 26
non_member_price 1.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 94763
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.19
ta_dealer_c_price 1.19
ta_price 1.79
text
array
1 94763
2 2P-20-GN
3 green, plastic, pack of 20
timestamp 2015-03-26T14:52:26.318Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228071063
barcode_type UPC
col1 green
col1_sortorder 2621
col2 plastic
col2_sortorder 35
col3 pack of 100
col3_sortorder 491
cost 4
deal_of_the_week NO
description green, plastic, pack of 100
group_id 1145
group_uname moore-push-pins
id 94779
list_price 7.29
map NO
mfr_num 2P-100-GN
net_weight 0.15
non_member_discount 26
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 94779
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.37
ta_dealer_c_price 4.37
ta_price 6.56
text
array
1 94779
2 2P-100-GN
3 green, plastic, pack of 100
timestamp 2015-03-26T14:52:26.526Z
vip_member_price 4.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228072022
barcode_type UPC
col1 red
col1_sortorder 5079
col2 plastic
col2_sortorder 35
col3 pack of 20
col3_sortorder 425
cost 1.1
deal_of_the_week NO
description red, plastic, pack of 20
group_id 1145
group_uname moore-push-pins
id 71011
list_price 1.99
map NO
mfr_num 2P-20R RED
net_weight 0.04
non_member_discount 26
non_member_price 1.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 71011
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.19
ta_dealer_c_price 1.19
ta_price 1.79
text
array
1 71011
2 2P-20R RED
3 red, plastic, pack of 20
timestamp 2015-03-26T14:51:59.2Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228071025
barcode_type UPC
col1 red
col1_sortorder 5079
col2 plastic
col2_sortorder 35
col3 pack of 100
col3_sortorder 491
cost 4
deal_of_the_week NO
description red, plastic, pack of 100
group_id 1145
group_uname moore-push-pins
id 94776
list_price 7.29
map NO
mfr_num 2P-100-RD
net_weight 0.15
non_member_discount 26
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 94776
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.37
ta_dealer_c_price 4.37
ta_price 6.56
text
array
1 94776
2 2P-100-RD
3 red, plastic, pack of 100
timestamp 2015-03-26T14:52:26.509Z
vip_member_price 4.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228071100
barcode_type UPC
col1 slate gray
col1_sortorder 5626
col2 plastic
col2_sortorder 35
col3 pack of 100
col3_sortorder 491
cost 4
deal_of_the_week NO
description slate gray, plastic, pack of 100
group_id 1145
group_uname moore-push-pins
id 38439
list_price 7.29
map NO
mfr_num 2P-100 SLG
net_weight 0.2
non_member_discount 26
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 38439
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.37
ta_dealer_c_price 4.37
ta_price 6.56
text
array
1 38439
2 2P-100 SLG
3 slate gray, plastic, pack of 100
timestamp 2015-03-26T14:51:08.36Z
vip_member_price 4.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228073319
barcode_type UPC
col1 warm walnut
col1_sortorder 6505
col2 wood
col2_sortorder 47
col3 pack of 20
col3_sortorder 425
cost 2.2
deal_of_the_week NO
description warm walnut, wood, pack of 20
group_id 1145
group_uname moore-push-pins
id 44719
list_price 3.99
map NO
mfr_num 2W-20-WW
net_weight 0.1
non_member_discount 26
non_member_price 2.97
prop65 NO
ship_rule_desc STD
shipping STD
sku 44719
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.39
ta_dealer_c_price 2.39
ta_price 3.59
text
array
1 44719
2 2W-20-WW
3 warm walnut, wood, pack of 20
timestamp 2015-03-26T14:51:14.779Z
vip_member_price 2.65

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228071032
barcode_type UPC
col1 white
col1_sortorder 6534
col2 plastic
col2_sortorder 35
col3 pack of 100
col3_sortorder 491
cost 4
deal_of_the_week NO
description white, plastic, pack of 100
group_id 1145
group_uname moore-push-pins
id 47668
list_price 7.29
map NO
mfr_num 2P-100-WE
net_weight 0.2
non_member_discount 26
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 47668
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.37
ta_dealer_c_price 4.37
ta_price 6.56
text
array
1 47668
2 2P-100-WE
3 white, plastic, pack of 100
timestamp 2015-03-26T14:51:19.672Z
vip_member_price 4.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228072039
barcode_type UPC
col1 white
col1_sortorder 6534
col2 plastic
col2_sortorder 35
col3 pack of 20
col3_sortorder 425
cost 1.1
deal_of_the_week NO
description white, plastic, pack of 20
group_id 1145
group_uname moore-push-pins
id 57989
list_price 1.99
map NO
mfr_num 2P-20W WHITE
net_weight 0.02
non_member_discount 26
non_member_price 1.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 57989
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.19
ta_dealer_c_price 1.19
ta_price 1.79
text
array
1 57989
2 2P-20W WHITE
3 white, plastic, pack of 20
timestamp 2015-03-26T14:51:34.386Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228072053
barcode_type UPC
col1 yellow
col1_sortorder 6670
col2 plastic
col2_sortorder 35
col3 pack of 20
col3_sortorder 425
cost 1.1
deal_of_the_week NO
description yellow, plastic, pack of 20
group_id 1145
group_uname moore-push-pins
id 94767
list_price 1.99
map NO
mfr_num 2P-20-YW
net_weight 0.04
non_member_discount 26
non_member_price 1.48
prop65 NO
ship_rule_desc STD
shipping STD
sku 94767
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.19
ta_dealer_c_price 1.19
ta_price 1.79
text
array
1 94767
2 2P-20-YW
3 yellow, plastic, pack of 20
timestamp 2015-03-26T14:52:26.32Z
vip_member_price 1.32

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


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

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

ItemIDList: 74097
AvailQtyList: 4.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 072228071056
barcode_type UPC
col1 yellow
col1_sortorder 6670
col2 plastic
col2_sortorder 35
col3 pack of 100
col3_sortorder 491
cost 4
deal_of_the_week NO
description yellow, plastic, pack of 100
group_id 1145
group_uname moore-push-pins
id 94778
list_price 7.29
map NO
mfr_num 2P-100-YW
net_weight 0.15
non_member_discount 26
non_member_price 5.42
prop65 NO
ship_rule_desc STD
shipping STD
sku 94778
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.37
ta_dealer_c_price 4.37
ta_price 6.56
text
array
1 94778
2 2P-100-YW
3 yellow, plastic, pack of 100
timestamp 2015-03-26T14:52:26.524Z
vip_member_price 4.85

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 74097
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] = '9912' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.227.9.98

URL: www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030f06bbd8a2627d61738741d2d205be464
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=airbrush&CatC=sort~1~fp~19-9999.99~c2~painting~&gr=airbrush-action-illustration-cheap-tricks-special-f-x-dvd.html
urltoken CFID=29336020&CFTOKEN=15684367&jsessionid=e030f06bbd8a2627d61738741d2d205be464
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 07:31:43'}
sessionid e030c756ab805c639d9b2775f305a2d22531
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=display-presentation&catB=sort~1~fp~0-38~&gr=moore-push-pins.html
urltoken CFID=29336021&CFTOKEN=73217735&jsessionid=e030c756ab805c639d9b2775f305a2d22531
validationerror [empty string]


Made in America to the highest standards of quality, millions of Moore Push-Pins are used yearly by those who know the best. The fine point is tool-tempered steel, an exclusive Moore Push-Pin feature, and provides lasting strength and durability. All plastic head, aluminum head, and solid wood push-pins are available in a 3/8 in. point and 1/2 in. head. The aluminum push-pins are also available in 1/2 in. and 5/8 in. points.

You can use a push-pin anytime you would use a thumbtack, with less wear and tear on your fingers. A simple twist of the wrist places or removes the push-pin.

Moore Push-Pins are available with aluminum or plastic heads in packages of 20 or 100 pins.

Share on Facebook Twitter Pinterest

Ask a question about Push Pins Ask a question about this product

Push Pins

by Moore

Average User Rating: Based on (2 Reviews)

5 2

John M. from Prairie du Chien, WI says:

Oh, yes...these are the best pushpins ever made! I've used them for pinning large loose charcoal paper to work easels (ten at a time), for mounting display items in a museum (very stylish), and for making...[more]

[Read All Reviews] [Write a Review]









  Item# Image color
Ascending
material unit Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
30020
Push Pins 5/8 in. aluminum pack of 100
Zoom Image
5/8 in. aluminum pack of 100 5-100 $11.99 $8.92 26% Off $7.97 34% Off Email When In Stock
Add to Favorites
46723
Push Pins 3/8 in. aluminum pack of 20
Zoom Image
3/8 in. aluminum pack of 20 3-20 $2.39 $1.78 26% Off $1.59 34% Off Email When In Stock
Add to Favorites
62668
Push Pins 1/2 in. aluminum pack of 100
Zoom Image
1/2 in. aluminum pack of 100 4-100 $11.59 $8.62 26% Off $7.71 34% Off Email When In Stock
Add to Favorites
62724
Push Pins 3/8 in. aluminum pack of 100
Zoom Image
3/8 in. aluminum pack of 100 3-100 $11.09 $8.25 26% Off $7.37 34% Off Email When In Stock
Add to Favorites
94781
Push Pins assorted day-glo plastic pack of 100
Zoom Image
assorted day-glo plastic pack of 100 2P-100-ADG $7.29 $5.42 26% Off $4.85 34% Off Email When In Stock
Add to Favorites
19403
Push Pins assorted gem stone plastic pack of 20
Zoom Image
assorted gem stone plastic pack of 20 2P-20-AGS $1.99 $1.48 26% Off $1.32 34% Off Email When In Stock
Add to Favorites
26154
Push Pins assorted gem stone plastic pack of 100
Zoom Image
assorted gem stone plastic pack of 100 2P-100-AGS $7.29 $5.42 26% Off $4.85 34% Off Email When In Stock
Add to Favorites
30685
Push Pins assorted pastels plastic pack of 20
Zoom Image
assorted pastels plastic pack of 20 2P-20 AFP $1.99 $1.48 26% Off $1.32 34% Off Email When In Stock
Add to Favorites
14247
Push Pins assorted regular plastic pack of 20
Zoom Image
assorted regular plastic pack of 20 2P-20-AR $1.99 $1.48 26% Off $1.32 34% Off Email When In Stock
Add to Favorites
85728
Push Pins assorted regular plastic pack of 100
Zoom Image
assorted regular plastic pack of 100 2P-100-AR $7.29 $5.42 26% Off $4.85 34% Off Email When In Stock
Add to Favorites
94762
Push Pins black plastic pack of 20
Zoom Image
black plastic pack of 20 2P-20-BK $1.99 $1.48 26% Off $1.32 34% Off Email When In Stock
Add to Favorites
94780
Push Pins black plastic pack of 100
Zoom Image
black plastic pack of 100 2P-100-BK $7.29 $5.42 26% Off $4.85 34% Off Email When In Stock
Add to Favorites
94761
Push Pins blue plastic pack of 20
Zoom Image
blue plastic pack of 20 2P-20-BE $1.99 $1.48 26% Off $1.32 34% Off Email When In Stock
Add to Favorites
94777
Push Pins blue plastic pack of 100
Zoom Image
blue plastic pack of 100 2P-100-BE $7.29 $5.42 26% Off $4.85 34% Off Email When In Stock
Add to Favorites
10207
Push Pins clear plastic pack of 20
Zoom Image
clear plastic pack of 20 2P-20-CR $1.99 $1.48 26% Off $1.32 34% Off Email When In Stock
Add to Favorites
45677
Push Pins clear plastic pack of 100
Zoom Image
clear plastic pack of 100 2P-100-CR $7.29 $5.42 26% Off $4.85 34% Off Email When In Stock
Add to Favorites
39738
Push Pins golden oak wood pack of 20
Zoom Image
golden oak wood pack of 20 2W-20-GO $3.99 $2.97 26% Off $2.65 34% Off Email When In Stock
Add to Favorites
94763
Push Pins green plastic pack of 20
Zoom Image
green plastic pack of 20 2P-20-GN $1.99 $1.48 26% Off $1.32 34% Off Email When In Stock
Add to Favorites
94779
Push Pins green plastic pack of 100
Zoom Image
green plastic pack of 100 2P-100-GN $7.29 $5.42 26% Off $4.85 34% Off Email When In Stock
Add to Favorites
71011
Push Pins red plastic pack of 20
Zoom Image
red plastic pack of 20 2P-20R RED $1.99 $1.48 26% Off $1.32 34% Off Email When In Stock
Add to Favorites
94776
Push Pins red plastic pack of 100
Zoom Image
red plastic pack of 100 2P-100-RD $7.29 $5.42 26% Off $4.85 34% Off Email When In Stock
Add to Favorites
38439
Push Pins slate gray plastic pack of 100
Zoom Image
slate gray plastic pack of 100 2P-100 SLG $7.29 $5.42 26% Off $4.85 34% Off Email When In Stock
Add to Favorites
44719
Push Pins warm walnut wood pack of 20
Zoom Image
warm walnut wood pack of 20 2W-20-WW $3.99 $2.97 26% Off $2.65 34% Off Email When In Stock
Add to Favorites
47668
Push Pins white plastic pack of 100
Zoom Image
white plastic pack of 100 2P-100-WE $7.29 $5.42 26% Off $4.85 34% Off Email When In Stock
Add to Favorites
57989
Push Pins white plastic pack of 20
Zoom Image
white plastic pack of 20 2P-20W WHITE $1.99 $1.48 26% Off $1.32 34% Off Email When In Stock
Add to Favorites
94767
Push Pins yellow plastic pack of 20
Zoom Image
yellow plastic pack of 20 2P-20-YW $1.99 $1.48 26% Off $1.32 34% Off Email When In Stock
Add to Favorites
94778
Push Pins yellow plastic pack of 100
Zoom Image
yellow plastic pack of 100 2P-100-YW $7.29 $5.42 26% Off $4.85 34% Off Email When In Stock

Click the to add item to your Favorites.



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

From $1.49

Glue-All

by Elmer's

The only school glue you've ever needed

Up to 46% Off

Transparent Triangles

by C-Thru

Professional grade tools

From $0.81

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 Push Pins

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: John M. in Prairie du Chien, WI
Oh, yes...these are the best pushpins ever made! I've used them for pinning large loose charcoal paper to work easels (ten at a time), for mounting display items in a museum (very stylish), and for making a changeable peg-system for clipboards and hangable art supplies. Worth their weight in silver!
Rated by: Steve R. in San diego, CA
These are the greatest push pins ever made... Pure metal, might as well be a nail for hammering. If u really need to put something on the wall, these are the ticket.

Write a Product Review for Push Pins

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...