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

State Birds and Flowers Coloring Book

by Dover


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

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

ItemIDList: 72097,72099,72118,72182,72183,72184
AvailQtyList: 10.000000000000,5.000000000000,5.000000000000,10.000000000000,4.000000000000,6.000000000000

struct
AVAILABLEQTY 5
FLAGS 0
HIGHLIGHTEDSKU 72118
VIP_member_discount 40
barcode 789541034728
barcode_type UPC
col1 mod circles
col1_sortorder 3944
col2 [empty string]
col3 [empty string]
cost 3.42
deal_of_the_week NO
description mod circles
group_id 11022
group_uname ranger-melt-art-texture-treads
id 72118
list_price 8
map NO
mfr_num SUT34728
net_weight 0.11
non_member_discount 30
non_member_price 5.6
prop65 NO
ship_rule_desc STD
shipping 0
sku 72118
sku_pix YES
supplier_id 1
ta_dealer_a_price 4
ta_dealer_c_price 4
ta_price 6
text
array
1 72118
2 SUT34728
3 mod circles
timestamp 2015-03-30T16:21:33.128Z
vip_member_price 4.8

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 6.000000000000 04484
2 10.000000000000 04485
3 7.000000000000 04486
4 7.000000000000 04487
5 5.000000000000 12392
6 15.000000000000 15034
7 0E-12 17118
8 0E-12 20269
9 1.000000000000 22182
10 3.000000000000 23943
11 8.000000000000 26130
12 4.000000000000 27946
13 12.000000000000 29846
14 5.000000000000 30238
15 3.000000000000 33295
16 14.000000000000 37561
17 5.000000000000 38526
18 0E-12 63578
19 11.000000000000 63586
20 6.000000000000 67246
21 2.000000000000 69348
22 2.000000000000 69350
23 5.000000000000 69351
24 4.000000000000 69353
25 3.000000000000 69358
26 2.000000000000 69362
27 5.000000000000 69363
28 6.000000000000 69364
29 0E-12 70716
30 8.000000000000 72236
31 19.000000000000 77833
32 6.000000000000 78518
33 13.000000000000 78519
34 7.000000000000 78520
35 5.000000000000 78521
36 3.000000000000 83034
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] = '4939' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 174.129.167.207

URL: www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=animals&gr=dover-state-birds-and-flowers-coloring-book.html

StartSessionVariables:
struct
cart
struct
CART_SUBTOTAL 0
FDTOTAL 0
GCINCART 0
MESSAGE [empty string]
ONEDAY_AMT 37.98
ONEDAY_SHIP ONEDAY
ONEDAY_SUR 0
STANDARD_AMT 11.98
STANDARD_SHIP GROUNDFDX
STANDARD_SUR 0
TWODAY_AMT 24.98
TWODAY_SHIP TWODAY
TWODAY_SUR 0
VIPINCART 0
checkout
struct
ITEMLIST 21954
NOSHIP 0
ORDER_TOTAL 13.8899998474
SAVED_LIST_PRICE 0.89
SAVED_VIP_PRICE 1.63
SHIPPINGTOTAL 7.48
SHIPPING_OPTION
struct
COST 7.48
DESC 4 - 6 business days
NOOPTIONS 3
SURCHARGE 0
TYPE Ground
Subtotal 6.41
country US
loggedin 1
nongcsubtotal 6.40999984741
nongcvipsubtotal 6.40999984741
ordernumber 696653
page checkout-step4
pgname checkout-step1
requeststarttime {ts '2015-03-30 21:43:00'}
savedquery embossing enamel
selshipping DISPLAY_STD
sessionid e0306a71217d218f8d5c6d58492e613146b3
ship_to_zip 62249
state IL
stformdata
struct [empty]
sub_order_number 0
tax 0.0
thispageurl www.misterart.com:/index.cfm:module=browse&pg=searchResult&paramOpts=query~embossing%20enamel~
urltoken CFID=11996906&CFTOKEN=11142623&jsessionid=e0306a71217d218f8d5c6d58492e613146b3
user
struct
COOKIEID 11996906:11142623
CUSTOMER_ID 10630123
EMAIL sarahviliocco@gmail.com
FIRST_NAME Sarah
ISVIP 1
LAST_NAME Viliocco
NET_30_COMPANY_ID 0
validationerror [empty string]
ziperror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 21:43:00'}
sessionid e030ff6920fe5f24e04d345e4051472d272c
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=coloring-books&CatC=animals&gr=dover-state-birds-and-flowers-coloring-book.html
urltoken CFID=30352945&CFTOKEN=53285702&jsessionid=e030ff6920fe5f24e04d345e4051472d272c
validationerror [empty string]


Coloring-book fans and nature lovers will delight in this kaleidoscopic collection. Fifty-one full-page illustrations offer accurately detailed renderings of the national bird (eagle) and flower (rose), as well as 50 state birds and flowers. Identifying captions. All illustrations copyright-free. 51 black-and-white illustrations. 51 color illustrations on covers. Paperback, 64 pages.
ISBN:486264564. DOVER


Share on Facebook Twitter Pinterest

Ask a question about State Birds and Flowers Coloring Book Ask a question about this product

State Birds and Flowers Coloring Book

by Dover

Average User Rating: Based on (2 Reviews)

5 2

W. G. from Brownstown, IN says:

I am really enjoying this great book. The illustrations are so very realistic. I am in a art class and everyone that has seen this book is enjoying it very much.

[Read All Reviews] [Write a Review]









  Item# Image title
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
63546
State Birds and Flowers Coloring Book aged patina
Zoom Image
aged patina PPP21803 $15.00 $10.65 29% Off $9.15 39% Off
Add to Favorites
78523
State Birds and Flowers Coloring Book cafe
Zoom Image
cafe PPP27430 $15.00 $10.65 29% Off $9.15 39% Off
Add to Favorites
04488
State Birds and Flowers Coloring Book celebration
Zoom Image
celebration PPP36791 $15.00 $10.65 29% Off $9.15 39% Off
Add to Favorites
69365
State Birds and Flowers Coloring Book confections
Zoom Image
confections PPP27447 $15.00 $10.65 29% Off $9.15 39% Off Email When In Stock
Add to Favorites
56817
State Birds and Flowers Coloring Book interference
Zoom Image
interference PPP15970 $15.00 $10.65 29% Off $9.15 39% Off
Add to Favorites
58063
State Birds and Flowers Coloring Book jewels
Zoom Image
jewels PPP16007 $15.00 $10.65 29% Off $9.15 39% Off
Add to Favorites
58603
State Birds and Flowers Coloring Book metallics
Zoom Image
metallics PPP15963 $15.00 $10.65 29% Off $9.15 39% Off
Add to Favorites
86927
State Birds and Flowers Coloring Book naturals
Zoom Image
naturals PPP15987 $15.00 $10.65 29% Off $9.15 39% Off Email When In Stock
Add to Favorites
89522
State Birds and Flowers Coloring Book pastels
Zoom Image
pastels PPP15994 $15.00 $10.65 29% Off $9.15 39% Off Email When In Stock

Click the to add item to your Favorites.

Add to Cart


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

Butterflies Coloring Book

by Dover

Experiment with color

From $3.99

Botanical Gardens

by Dover

Great gift for all ages

From $3.31

From $3.30

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 State Birds and Flowers Coloring Book

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: W. G. in Brownstown, IN
I am really enjoying this great book. The illustrations are so very realistic. I am in a art class and everyone that has seen this book is enjoying it very much.
Rated by: Chris W. in Pleasant Hill, MO
One of the most beautiful books I've ever had. The pictures are spectacular and the information was great. We sometimes forget in our busy lives how beautiful our world really is and this book certainly did a wonderful job of reminding me.

Write a Product Review for State Birds and Flowers Coloring Book

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