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

Paper Dolls

by Dover


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
col1 Woodstock: 40th Anniversary Flashback Edition
col2 [empty string]
col3 [empty string]
cost 4.39
deal_of_the_week NO
description Woodstock: 40th Anniversary Flashback Edition
group_id 13481
group_uname dover-paper-dolls
id 42725
list_price 7.99
map NO
mfr_num 9780486473956
net_weight 0.33
non_member_discount 10
non_member_price 7.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 42725
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.79
ta_dealer_c_price 4.79
ta_price 7.19
text
array
1 42725
2 9780486473956
3 Woodstock: 40th Anniversary Flashback Edition
timestamp 2015-03-27T14:47:15.201Z
vip_member_price 6.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 800759476060
barcode_type UPC
col1 Action Stars
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Action Stars
group_id 13481
group_uname dover-paper-dolls
id 43895
list_price 9.99
map NO
mfr_num 9780486476063
net_weight 0.45
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 43895
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 43895
2 9780486476063
3 Action Stars
timestamp 2015-03-27T14:47:16.453Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 800759477197
barcode_type UPC
col1 Vampire
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Vampire
group_id 13481
group_uname dover-paper-dolls
id 43897
list_price 9.99
map NO
mfr_num 9780486477190
net_weight 0.46
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 43897
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 5.99
text
array
1 43897
2 9780486477190
3 Vampire
timestamp 2015-03-27T14:47:16.455Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
col1 Voodoo
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Voodoo
group_id 13481
group_uname dover-paper-dolls
id 44673
list_price 9.99
map NO
mfr_num 9780486477855
net_weight 0.47
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 44673
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 5.99
text
array
1 44673
2 9780486477855
3 Voodoo
timestamp 2015-03-27T14:47:17.385Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 800759479207
barcode_type UPC
col1 Ballet Dancers
col2 [empty string]
col3 [empty string]
cost 3.84
deal_of_the_week NO
description Ballet Dancers
group_id 13481
group_uname dover-paper-dolls
id 44678
list_price 6.99
map NO
mfr_num 9780486479200
net_weight 0.35
non_member_discount 10
non_member_price 6.29
prop65 NO
ship_rule_desc STD
shipping STD
sku 44678
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.19
ta_dealer_c_price 4.19
ta_price 6.29
text
array
1 44678
2 9780486479200
3 Ballet Dancers
timestamp 2015-03-27T14:47:17.387Z
vip_member_price 5.59

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 800759483785
barcode_type UPC
col1 William & Kate
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description William & Kate
group_id 13481
group_uname dover-paper-dolls
id 45487
list_price 9.99
map NO
mfr_num 9780486483788
net_weight 0.36
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 45487
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 45487
2 9780486483788
3 William & Kate
timestamp 2015-03-27T14:47:18.558Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
col1 Teen Pop Stars
col2 [empty string]
col3 [empty string]
cost 4.39
deal_of_the_week NO
description Teen Pop Stars
group_id 13481
group_uname dover-paper-dolls
id 45493
list_price 7.99
map NO
mfr_num 9780486480961
net_weight 0.35
non_member_discount 10
non_member_price 7.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 45493
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.79
ta_dealer_c_price 4.79
ta_price 7.19
text
array
1 45493
2 9780486480961
3 Teen Pop Stars
timestamp 2015-03-27T14:47:18.566Z
vip_member_price 6.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 800759481781
barcode_type UPC
col1 Alexander McQueen Fashions
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Alexander McQueen Fashions
group_id 13481
group_uname dover-paper-dolls
id 45519
list_price 9.99
map NO
mfr_num 9780486481784
net_weight 0.46
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 45519
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 45519
2 9780486481784
3 Alexander McQueen Fashions
timestamp 2015-03-27T14:47:18.615Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9780486482316
barcode_type EAN
col1 Peter Pan
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Peter Pan
group_id 13481
group_uname dover-paper-dolls
id 45521
list_price 9.99
map NO
mfr_num 9780486482316
net_weight 0.45
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 45521
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 45521
2 9780486482316
3 Peter Pan
timestamp 2015-03-27T14:47:18.617Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9780486483139
barcode_type EAN
col1 Life's a Drag
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Life's a Drag
group_id 13481
group_uname dover-paper-dolls
id 46257
list_price 9.99
map NO
mfr_num 9780486483139
net_weight 0.47
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 46257
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 46257
2 9780486483139
3 Life's a Drag
timestamp 2015-03-27T14:47:20.155Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9780486484419
barcode_type EAN
col1 Twisted Fairy Tales
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Twisted Fairy Tales
group_id 13481
group_uname dover-paper-dolls
id 46259
list_price 9.99
map NO
mfr_num 9780486484419
net_weight 0.48
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 46259
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 46259
2 9780486484419
3 Twisted Fairy Tales
timestamp 2015-03-27T14:47:20.162Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 800759479214
barcode_type UPC
col1 In the Style of Mucha
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description In the Style of Mucha
group_id 13481
group_uname dover-paper-dolls
id 46261
list_price 9.99
map NO
mfr_num 9780486479217
net_weight 0.46
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 46261
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 46261
2 9780486479217
3 In the Style of Mucha
timestamp 2015-03-27T14:47:20.167Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
col1 Glow-in-the-Dark Ghouls
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Glow-in-the-Dark Ghouls
group_id 13481
group_uname dover-paper-dolls
id 46342
list_price 9.99
map NO
mfr_num 9780486483641
net_weight 0.5
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 46342
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 46342
2 9780486483641
3 Glow-in-the-Dark Ghouls
timestamp 2015-03-27T14:47:20.249Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 800759487813
barcode_type uPC
col1 Robot Battle
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Robot Battle
group_id 13481
group_uname dover-paper-dolls
id 47473
list_price 9.99
map NO
mfr_num 9780486487816
net_weight 0.33
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 47473
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 47473
2 9780486487816
3 Robot Battle
timestamp 2015-03-27T14:47:21.648Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 800759487042
barcode_type uPC
col1 Fashion Fads
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Fashion Fads
group_id 13481
group_uname dover-paper-dolls
id 47523
list_price 9.99
map NO
mfr_num 9780486487045
net_weight 0.47
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 47523
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 47523
2 9780486487045
3 Fashion Fads
timestamp 2015-03-27T14:47:21.704Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9780486490090
barcode_type EAN
col1 Corset Couture
col1_sortorder 764
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Corset Couture
group_id 13481
group_uname dover-paper-dolls
id 00373
list_price 9.99
map NO
mfr_num 9780486490090
net_weight 0.46
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 00373
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 00373
2 9780486490090
3 Corset Couture
timestamp 2015-03-27T14:45:59.611Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
col1 Day of the Dead
col1_sortorder 842
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Day of the Dead
group_id 13481
group_uname dover-paper-dolls
id 42722
list_price 9.99
map NO
mfr_num 9780486472850
net_weight 0.52
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 42722
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 42722
2 9780486472850
3 Day of the Dead
timestamp 2015-03-27T14:47:15.195Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
col1 Fairy
col1_sortorder 1121
col2 [empty string]
col3 [empty string]
cost 2.75
deal_of_the_week NO
description Fairy
group_id 13481
group_uname dover-paper-dolls
id 43840
list_price 4.99
map NO
mfr_num 9780486476803
net_weight 0.22
non_member_discount 10
non_member_price 4.49
prop65 NO
ship_rule_desc STD
shipping STD
sku 43840
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.99
ta_dealer_c_price 2.99
ta_price 4.49
text
array
1 43840
2 9780486476803
3 Fairy
timestamp 2015-03-27T14:47:16.407Z
vip_member_price 3.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9780486489902
barcode_type EAN
col1 Fairy Tale Princesses
col1_sortorder 1127
col2 [empty string]
col3 [empty string]
cost 4.39
deal_of_the_week NO
description Fairy Tale Princesses
group_id 13481
group_uname dover-paper-dolls
id 00362
list_price 7.99
map NO
mfr_num 9780486489902
net_weight 0.35
non_member_discount 10
non_member_price 7.19
prop65 NO
ship_rule_desc STD
shipping STD
sku 00362
sku_pix YES
supplier_id 1
ta_dealer_a_price 4.79
ta_dealer_c_price 4.79
ta_price 7.19
text
array
1 00362
2 9780486489902
3 Fairy Tale Princesses
timestamp 2015-03-27T14:45:59.601Z
vip_member_price 6.39

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9780486490434
barcode_type EAN
col1 Golden Age of Hollywood
col1_sortorder 1401
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Golden Age of Hollywood
group_id 13481
group_uname dover-paper-dolls
id 00374
list_price 9.99
map NO
mfr_num 9780486490434
net_weight 0.47
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 00374
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 00374
2 9780486490434
3 Golden Age of Hollywood
timestamp 2015-03-27T14:45:59.613Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 800759474813
barcode_type UPC
col1 Sherlock Holmes
col1_sortorder 2450
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Sherlock Holmes
group_id 13481
group_uname dover-paper-dolls
id 42723
list_price 9.99
map NO
mfr_num 9780486474816
net_weight 0.45
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 42723
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 5.99
text
array
1 42723
2 9780486474816
3 Sherlock Holmes
timestamp 2015-03-27T14:47:15.197Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


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

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

ItemIDList: 23886
AvailQtyList: 20.000000000000

struct
FLAGS 0
VIP_member_discount 20
barcode 9780486489483
barcode_type EAN
col1 Steampunk
col1_sortorder 2516
col2 [empty string]
col3 [empty string]
cost 5.49
deal_of_the_week NO
description Steampunk
group_id 13481
group_uname dover-paper-dolls
id 00375
list_price 9.99
map NO
mfr_num 9780486489483
net_weight 0.69
non_member_discount 10
non_member_price 8.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 00375
sku_pix YES
supplier_id 1
ta_dealer_a_price 5.99
ta_dealer_c_price 5.99
ta_price 8.99
text
array
1 00375
2 9780486489483
3 Steampunk
timestamp 2015-03-27T14:45:59.615Z
vip_member_price 7.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 20.000000000000 23886
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] = '6491' 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.161.146.154

URL: www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e030df5fc1f6bc0c4210372d5d34133d6a6c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=fp~5-9999.99~&gr=tacro-engineering-flat-scale.html
urltoken CFID=29541184&CFTOKEN=82373494&jsessionid=e030df5fc1f6bc0c4210372d5d34133d6a6c
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 00:49:31'}
sessionid e0308381edea811cc22c7d2b106225b6b1b7
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=kids-korner&catB=books&CatC=sort~1~&gr=dover-paper-dolls.html
urltoken CFID=29541185&CFTOKEN=20040014&jsessionid=e0308381edea811cc22c7d2b106225b6b1b7
validationerror [empty string]


There are hundreds of paper dolls that are artfully illustrated and historically accurate in every sense. Browse our collection both for children and collectors. Each book is 32 pages and sized 8.5x11.

Share on Facebook Twitter Pinterest

Ask a question about Paper Dolls Ask a question about this product

Paper Dolls

by Dover









  Item# Image title
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
42725
Paper Dolls Woodstock: 40th Anniversary Flashback Edition
Zoom Image
Woodstock: 40th Anniversary Flashback Edition 9780486473956 $7.99 $7.19 10% Off $6.39 20% Off Email When In Stock
Add to Favorites
43895
Paper Dolls Action Stars
Zoom Image
Action Stars 9780486476063 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
43897
Paper Dolls Vampire
Zoom Image
Vampire 9780486477190 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
44673
Paper Dolls Voodoo
Zoom Image
Voodoo 9780486477855 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
44678
Paper Dolls Ballet Dancers
Zoom Image
Ballet Dancers 9780486479200 $6.99 $6.29 10% Off $5.59 20% Off Email When In Stock
Add to Favorites
45487
Paper Dolls William & Kate
Zoom Image
William & Kate 9780486483788 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
45493
Paper Dolls Teen Pop Stars
Zoom Image
Teen Pop Stars 9780486480961 $7.99 $7.19 10% Off $6.39 20% Off Email When In Stock
Add to Favorites
45519
Paper Dolls Alexander McQueen Fashions
Zoom Image
Alexander McQueen Fashions 9780486481784 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
45521
Paper Dolls Peter Pan
Zoom Image
Peter Pan 9780486482316 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
46257
Paper Dolls Life's a Drag
Zoom Image
Life's a Drag 9780486483139 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
46259
Paper Dolls Twisted Fairy Tales
Zoom Image
Twisted Fairy Tales 9780486484419 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
46261
Paper Dolls In the Style of Mucha
Zoom Image
In the Style of Mucha 9780486479217 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
46342
Paper Dolls Glow-in-the-Dark Ghouls
Zoom Image
Glow-in-the-Dark Ghouls 9780486483641 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
47473
Paper Dolls Robot Battle
Zoom Image
Robot Battle 9780486487816 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
47523
Paper Dolls Fashion Fads
Zoom Image
Fashion Fads 9780486487045 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
00373
Paper Dolls Corset Couture
Zoom Image
Corset Couture 9780486490090 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
42722
Paper Dolls Day of the Dead
Zoom Image
Day of the Dead 9780486472850 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
43840
Paper Dolls Fairy
Zoom Image
Fairy 9780486476803 $4.99 $4.49 10% Off $3.99 20% Off Email When In Stock
Add to Favorites
00362
Paper Dolls Fairy Tale Princesses
Zoom Image
Fairy Tale Princesses 9780486489902 $7.99 $7.19 10% Off $6.39 20% Off Email When In Stock
Add to Favorites
00374
Paper Dolls Golden Age of Hollywood
Zoom Image
Golden Age of Hollywood 9780486490434 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
42723
Paper Dolls Sherlock Holmes
Zoom Image
Sherlock Holmes 9780486474816 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock
Add to Favorites
00375
Paper Dolls Steampunk
Zoom Image
Steampunk 9780486489483 $9.99 $8.99 10% Off $7.99 20% Off Email When In Stock

Click the to add item to your Favorites.



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

Tom Lynch Watercolor Palette

by Speedball

Large and versatile for prolonged use

Up to 30% Off

Up to 30% Off

Artist Style Palette

by Loew Cornell

Durable and functional

From $1.25

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 Paper Dolls

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.

Write a Product Review for Paper Dolls

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