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

Big Kid's Choice Script Brushes

by Royal & Langnickel


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

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

ItemIDList: 63097
AvailQtyList: 4.000000000000

struct
VIP_member_discount 50
barcode 090672011039
barcode_type UPC
col1 10/0
col1_sortorder 80
col2 [empty string]
col3 [empty string]
cost 0.73
deal_of_the_week NO
description 10/0
flags
array
1 1
group_id 7218
group_uname royal-langnickel-big-kid-s-choice-script-brushes
id 44010
list_price 1.99
map NO
mfr_num BK61-10/0
net_weight 0.01
non_member_discount 26
non_member_price 1.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 44010
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.8
ta_dealer_c_price 0.8
ta_price 1.39
text
array
1 44010
2 BK61-10/0
3 10/0
timestamp 2015-03-27T14:47:16.517Z
vip_member_price 0.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 63097
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] = '6049' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=brushes&catB=kid-s-brushes&CatC=sort~1~&gr=royal-langnickel-big-kid-s-choice-script-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:13:59'}
sessionid e0306cecdb42af0c6a7c6265c421e2575625
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fb~dover~fp~4-13~&gr=dover-fantastic-ornament-110-designs-motifs.html
urltoken CFID=30229394&CFTOKEN=60699208&jsessionid=e0306cecdb42af0c6a7c6265c421e2575625
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:13:59'}
sessionid e03037312dd9b8c2cdb92c31262c70262544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=kid-s-brushes&CatC=sort~1~&gr=royal-langnickel-big-kid-s-choice-script-brushes.html
urltoken CFID=30229393&CFTOKEN=54262434&jsessionid=e03037312dd9b8c2cdb92c31262c70262544
validationerror [empty string]


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

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

ItemIDList: 63097
AvailQtyList: 4.000000000000

struct
VIP_member_discount 50
barcode 090672011046
barcode_type UPC
col1 size 1
col1_sortorder 2575
col2 [empty string]
col3 [empty string]
cost 0.73
deal_of_the_week NO
description size 1
flags
array
1 1
group_id 7218
group_uname royal-langnickel-big-kid-s-choice-script-brushes
id 85009
list_price 1.99
map NO
mfr_num BK61-1
net_weight 0.01
non_member_discount 26
non_member_price 1.47
prop65 NO
ship_rule_desc STD
shipping STD
sku 85009
sku_pix NO
supplier_id 1
ta_dealer_a_price 0.8
ta_dealer_c_price 0.8
ta_price 1.39
text
array
1 85009
2 BK61-1
3 size 1
timestamp 2015-03-27T14:48:15.025Z
vip_member_price 0.99

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 4.000000000000 63097
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] = '6049' 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.89.36.189

URL: www.misterart.com:/index.cfm:module=brushes&catB=kid-s-brushes&CatC=sort~1~&gr=royal-langnickel-big-kid-s-choice-script-brushes.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:13:59'}
sessionid e0306cecdb42af0c6a7c6265c421e2575625
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=sort~1~fb~dover~fp~4-13~&gr=dover-fantastic-ornament-110-designs-motifs.html
urltoken CFID=30229394&CFTOKEN=60699208&jsessionid=e0306cecdb42af0c6a7c6265c421e2575625
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-30 11:13:59'}
sessionid e03037312dd9b8c2cdb92c31262c70262544
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=brushes&catB=kid-s-brushes&CatC=sort~1~&gr=royal-langnickel-big-kid-s-choice-script-brushes.html
urltoken CFID=30229393&CFTOKEN=54262434&jsessionid=e03037312dd9b8c2cdb92c31262c70262544
validationerror [empty string]


Big Kid's Choice brushes and sets are for the kid in all of us! Features include brightly colored translucent acrylic handles which are short and thick for a comfortable and easy grip, and color coding to show distinctive head shapes. Better quality taklon means fine points, sharp edges and resilient spring; no paint to chip off handles!

Share on Facebook Twitter Pinterest

Ask a question about Big Kid's Choice Script Brushes Ask a question about this product

Big Kid's Choice Script Brushes

by Royal & Langnickel









  Item# Image size
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
44010
Big Kid's Choice Script Brushes 10/0
Zoom Image
10/0 BK61-10/0 $1.99 $1.47 26% Off $0.99 50% Off Email When In Stock
Add to Favorites
85009
  size 1 BK61-1 $1.99 $1.47 26% Off $0.99 50% Off Email When In Stock

Click the to add item to your Favorites.



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

From $4.50

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 Big Kid's Choice Script Brushes

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 Big Kid's Choice Script Brushes

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