{snippet:notices} {snippet:breadcrumbs}

Dryad Arbor

Dryad Arbor

8.90zł
Najtańsza wysyłka od 11zł
Stan magazynowy: wyprzedany


Nazwa karty: Dryad Arbor
Typ: Land Creature — Forest Dryad
Tekst karty : (Dryad Arbor isn't a spell, it's affected by summoning sickness, and it has "Tap: Add Green.")
"Touch no tree, break no branch, and speak only the question you wish answered." —Von Yomm, elder druid, to her initiates
Dodatek: The List
Rarity: uncommon
Numer karty w secie: 285
Artysta: Eric Fortune
Fatal error: 2006 - MySQL server has gone away select p.*, pi.name, pi.short_description, m.id as manufacturer_id, m.name as manufacturer_name, pp.price, pc.campaign_price, if(pc.campaign_price, pc.campaign_price, pp.price) as final_price, (0 + if(pi.name like '%Dryad Arbor%', 1, 0) + if(find_in_set('2115', categories), 1, 0) ) as occurrences from ( select p.id, p.sold_out_status_id, p.code, p.sku, p.mpn, p.gtin, p.manufacturer_id, group_concat(ptc.category_id separator ',') as categories, p.keywords, p.product_groups, p.image, p.tax_class_id, p.quantity, p.views, p.purchases, p.date_created from `morigal2_new`.`lc_products` p left join `morigal2_new`.`lc_products_to_categories` ptc on (p.id = ptc.product_id) left join `morigal2_new`.`lc_sold_out_statuses` ss on (p.sold_out_status_id = ss.id) where p.status and (p.id or ptc.category_id in (2115) ) and (p.quantity > 0 or ss.hidden != 1) and (p.date_valid_from <= '2024-03-29 07:29:59') and (year(p.date_valid_to) < '1971' or p.date_valid_to >= '2024-03-29 07:29:59') and p.id not in ('20791') group by ptc.product_id ) p left join `morigal2_new`.`lc_products_info` pi on (pi.product_id = p.id and pi.language_code = 'pl') left join `morigal2_new`.`lc_manufacturers` m on (m.id = p.manufacturer_id) left join ( select product_id, if(`PLN`, `PLN` * 1, `PLN`) as price from `morigal2_new`.`lc_products_prices` ) pp on (pp.product_id = p.id) left join ( select product_id, if(`PLN`, `PLN` * 1, `PLN`) as campaign_price from `morigal2_new`.`lc_products_campaigns` where start_date <= '2024-03-29 07:29:59' and (year(end_date) < '1971' or end_date >= '2024-03-29 07:29:59') order by end_date asc ) pc on (pc.product_id = p.id) where (p.id or pi.name like '%Dryad Arbor%' ) order by occurrences desc limit 8; in ~/includes/library/lib_database.inc.php on line 251