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

Synchromatic Transparent Watercolors 1/2 oz.

by Dr. Ph. Martin's


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385408508
barcode_type UPC
col1 burnt sienna
col1_sortorder 875
col2 [empty string]
col3 [empty string]
color_swatch 119-60-0.jpg
cost 3.55
deal_of_the_week NO
description burnt sienna
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 38123
list_price 7.75
map NO
mfr_num 8-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 38123
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 38123
2 8-1/2Z
3 burnt sienna
timestamp 2015-03-27T14:47:10.385Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385402506
barcode_type UPC
col1 cadmium
col1_sortorder 914
col2 [empty string]
col3 [empty string]
color_swatch 195-47-80.jpg
cost 3.55
deal_of_the_week NO
description cadmium
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 55993
list_price 7.75
map NO
mfr_num 2-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 55993
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 55993
2 2-1/2Z
3 cadmium
timestamp 2015-03-27T14:47:30.878Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385426502
barcode_type UPC
col1 carmine
col1_sortorder 1110
col2 [empty string]
col3 [empty string]
color_swatch 164-0-62.jpg
cost 3.55
deal_of_the_week NO
description carmine
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 44294
list_price 7.75
map NO
mfr_num 26-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 44294
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 44294
2 26-1/2Z
3 carmine
timestamp 2015-03-27T14:47:17.011Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385439502
barcode_type UPC
col1 cerulean blue
col1_sortorder 1154
col2 [empty string]
col3 [empty string]
color_swatch 173-122-255.jpg
cost 3.55
deal_of_the_week NO
description cerulean blue
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 35944
list_price 7.75
map NO
mfr_num 39-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 35944
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 35944
2 39-1/2Z
3 cerulean blue
timestamp 2015-03-27T14:47:06.873Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385427509
barcode_type UPC
col1 magenta
col1_sortorder 3529
col2 [empty string]
col3 [empty string]
color_swatch 240-47-132.jpg
cost 3.55
deal_of_the_week NO
description magenta
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 66514
list_price 7.75
map NO
mfr_num 27-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 66514
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 66514
2 27-1/2Z
3 magenta
timestamp 2015-03-27T14:47:49.021Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385420500
barcode_type UPC
col1 Nile green
col1_sortorder 4095
col2 [empty string]
col3 [empty string]
color_swatch 77-210-119.jpg
cost 3.55
deal_of_the_week NO
description Nile green
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 53024
list_price 7.75
map NO
mfr_num 20-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 53024
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 53024
2 20-1/2Z
3 Nile green
timestamp 2015-03-27T14:47:28.251Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385417500
barcode_type UPC
col1 Prussian blue
col1_sortorder 4895
col2 [empty string]
col3 [empty string]
color_swatch 0-53-119.jpg
cost 3.55
deal_of_the_week NO
description Prussian blue
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 52189
list_price 7.75
map NO
mfr_num 17-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 52189
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 52189
2 17-1/2Z
3 Prussian blue
timestamp 2015-03-27T14:47:26.432Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385430509
barcode_type UPC
col1 purple
col1_sortorder 4930
col2 [empty string]
col3 [empty string]
color_swatch 119-0-107.jpg
cost 3.55
deal_of_the_week NO
description purple
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 33070
list_price 7.75
map NO
mfr_num 30-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 33070
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 33070
2 30-1/2Z
3 purple
timestamp 2015-03-27T14:47:00.993Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385407501
barcode_type UPC
col1 reddish brown
col1_sortorder 5154
col2 [empty string]
col3 [empty string]
color_swatch 149-92-47.jpg
cost 3.55
deal_of_the_week NO
description reddish brown
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 37425
list_price 7.75
map NO
mfr_num 7-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 37425
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 37425
2 7-1/2Z
3 reddish brown
timestamp 2015-03-27T14:47:09.245Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385416503
barcode_type UPC
col1 turquoise blue
col1_sortorder 6207
col2 [empty string]
col3 [empty string]
color_swatch 0-178-210.jpg
cost 3.55
deal_of_the_week NO
description turquoise blue
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 32791
list_price 7.75
map NO
mfr_num 16-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 32791
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 32791
2 16-1/2Z
3 turquoise blue
timestamp 2015-03-27T14:46:58.898Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385418507
barcode_type UPC
col1 ultramarine
col1_sortorder 6246
col2 [empty string]
col3 [empty string]
color_swatch 0-0-119.jpg
cost 3.55
deal_of_the_week NO
description ultramarine
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 40636
list_price 7.75
map NO
mfr_num 18-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 40636
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 40636
2 18-1/2Z
3 ultramarine
timestamp 2015-03-27T14:47:12.72Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


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

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

ItemIDList: 01862
AvailQtyList: 2.000000000000

struct
FLAGS 0
VIP_member_discount 34
barcode 090385409505
barcode_type UPC
col1 van dyke brown
col1_sortorder 6303
col2 [empty string]
col3 [empty string]
color_swatch 104-83-47.jpg
cost 3.55
deal_of_the_week NO
description van dyke brown
group_id 748
group_uname dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-
id 89461
list_price 7.75
map NO
mfr_num 9-1/2Z
net_weight 0.1
non_member_discount 24
non_member_price 5.89
prop65 NO
ship_rule_desc STD
shipping STD
sku 89461
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.88
ta_dealer_c_price 3.88
ta_price 6.2
text
array
1 89461
2 9-1/2Z
3 van dyke brown
timestamp 2015-03-27T14:48:23.892Z
vip_member_price 5.12

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 2.000000000000 01862
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] = '11199' 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=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e0305117ad271510b1dd59496c526e6d7a7a
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=books-media&catB=drawing&CatC=sort~1~fp~3-22~&gr=walter-foster-the-art-of-drawing-manga-and-comic-book-characters.html
urltoken CFID=29514413&CFTOKEN=79817964&jsessionid=e0305117ad271510b1dd59496c526e6d7a7a
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-27 23:10:56'}
sessionid e030bf17f0917c86cd6956f27a53327a41a1
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=painting&catB=fb~dr-ph-martin-s~&gr=dr-ph-martin-s-synchromatic-transparent-watercolors-1-2-oz-.html
urltoken CFID=29514416&CFTOKEN=95475956&jsessionid=e030bf17f0917c86cd6956f27a53327a41a1
validationerror [empty string]


Synchromatic colors are easy to handle and give ultimate transparency. Ideal for use in airbrushes. Preferred for photographic surfaces and flat washes on illustration paper or layout tissue. Many may need to be diluted with water when used on photo surfaces. Synchromatic Transparent Watercolors come in 1/2 oz. (15 ml) bottles.

Share on Facebook Twitter Pinterest

Ask a question about Synchromatic Transparent Watercolors 1/2 oz. Ask a question about this product  |  See all questions & answers (1)

Synchromatic Transparent Watercolors 1/2 oz.

by Dr. Ph. Martin's

Average User Rating: Based on (4 Reviews)

5 4

John M. from Prairie du Chien, WI says:

I have used a "student set" of these for twenty years now, and I love them! I use them to paint directly onto cardstock photocopies of my linework, and the black always shows through like it was printed...[more]

[Read All Reviews] [Write a Review]









  Item# Swatch Image color
Ascending
Manufacturer Number List Price
Non-Member
Price
VIP Member
Club Price
Quantity
Add to Favorites
38123
Synchromatic Transparent Watercolors 1/2 oz. burnt sienna
Zoom Image
burnt sienna 8-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock
Add to Favorites
55993
Synchromatic Transparent Watercolors 1/2 oz. cadmium
Zoom Image
cadmium 2-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock
Add to Favorites
44294
Synchromatic Transparent Watercolors 1/2 oz. carmine
Zoom Image
carmine 26-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock
Add to Favorites
35944
Synchromatic Transparent Watercolors 1/2 oz. cerulean blue
Zoom Image
cerulean blue 39-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock
Add to Favorites
66514
Synchromatic Transparent Watercolors 1/2 oz. magenta
Zoom Image
magenta 27-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock
Add to Favorites
53024
Synchromatic Transparent Watercolors 1/2 oz. Nile green
Zoom Image
Nile green 20-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock
Add to Favorites
52189
Synchromatic Transparent Watercolors 1/2 oz. Prussian blue
Zoom Image
Prussian blue 17-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock
Add to Favorites
33070
Synchromatic Transparent Watercolors 1/2 oz. purple
Zoom Image
purple 30-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock
Add to Favorites
37425
Synchromatic Transparent Watercolors 1/2 oz. reddish brown
Zoom Image
reddish brown 7-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock
Add to Favorites
32791
Synchromatic Transparent Watercolors 1/2 oz. turquoise blue
Zoom Image
turquoise blue 16-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock
Add to Favorites
40636
Synchromatic Transparent Watercolors 1/2 oz. ultramarine
Zoom Image
ultramarine 18-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock
Add to Favorites
89461
Synchromatic Transparent Watercolors 1/2 oz. van dyke brown
Zoom Image
van dyke brown 9-1/2Z $7.75 $5.89 24% Off $5.12 34% Off Email When In Stock

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

Click the to add item to your Favorites.



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

Premier Double-Ended Art Markers

by Prismacolor

Chisel tip on one end and fine tip on the other

From $2.73

Radiant Concentrated Watercolor Sets

by Dr. Ph. Martin's

Must-have sets for graphic artists

Up to 41% Off

From $1.46

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 »

Product Questions and Answers

Ask a Question
Ask a Question

Are these inks considered light-fast?

- Asked by Janice RM. on 03-Dec-12
Answer

The Synchromatic Transparent Watercolors by Dr. Ph. Martin's are not considered light-fast.

- Answered by MisterArt on 03-Dec-12

Ask a Question About Synchromatic Transparent Watercolors 1/2 oz.


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
I have used a "student set" of these for twenty years now, and I love them! I use them to paint directly onto cardstock photocopies of my linework, and the black always shows through like it was printed OVER the color! The best part is that a tiny, tiny amount of the paint (like a single drop), mixed with water, is enough to do entire sections. In addition, they don't fade over time!
Rated by: Alinda S. in Norridgewock, ME
These watercolors are the best and are my favorite! They are far superior to any other watercolor as they can be used as an ink wash, in technical pens (even the very fine points), and in airbrushes. They hold their color well and are very easy to work with.
Rated by: mark b. in novato, CA
excellent for a variety of water based applications
Rated by: Lee B. in Seattle, WA
These are fantastic for bright, clear color. I use these watercolors when I am working on background washes.

Write a Product Review for Synchromatic Transparent Watercolors 1/2 oz.

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