SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '41' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,15Array ( [298] => Array ( [product_id] => 298 [name] => Aromex 25mg - 30 tabs Alpha-Pharma [description] => [meta_description] => [meta_keyword] => [tag] => [model] => ar25 [sku] => [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 295 [stock_status] => Out Of Stock [image] => data/aromex-alpha-500x500.jpg [manufacturer_id] => 41 [manufacturer] => Alpha-Pharma [price] => 69.0000 [special] => [reward] => 0 [points] => 0 [tax_class_id] => 0 [date_available] => 2017-03-06 [weight] => 0.00000000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [rating] => 0 [reviews] => 0 [minimum] => 1 [sort_order] => 1 [status] => 1 [date_added] => 2017-03-07 13:18:33 [date_modified] => 0000-00-00 00:00:00 [viewed] => 1447 ) [299] => Array ( [product_id] => 299 [name] => Boldebolin 250 Alpha-Pharma 10 Ampoules 1ml [description] => <p>LE INFORMAZIONI GENERALI<br /> Produttore: Alpha Pharma<br /> Sostanza: Boldenone Undecylenate<br /> Nomi Comuni: Equipoise, EQ, Boldenon, Boldenox, Boldebolic<br /> Vita Attiva: 2 settimane<br /> Tempo di scoperta: 5 mesi<br /> Dosaggio diffuso: 400mg settimanale<br /> Pressione sanguigna: Rischio basso<br /> Acne: Se é incline, possibile<br /> Ritenzione idrica: Basso<br /> Aromatizzazione: Basso<br /> Trasformazione di DHT: Basso<br /> Funzione di diminuzione HPTA: Si<br /> Pacchetto: 10 ml fiala (250 mg/ml)</p> <p>Boldenone, il suo altro nome é Equipose, che puo’ usarsi anche nel ciclo di massa e dieta, é un prodotto piu’ forte. Ha gli effetti anabolici e androgenici. Boldenone ha alcuni compiti come l’aumento della ritenzione dell’azoto, la sintesi proteica, l’aumento e la stimolazione del rilascio di eritropoietina nei reni.</p> <p>Boldenone non fornisce uno sviluppo del muscolo veloce, questo sviluppo non viene aspettato da Boldenone. Perché una potenza perfetta e una massa di buona qualita` é ottenuto da Boldenone undecylenate in un lungo tempo. &nbsp;Negli usi per lungo tempo questo farmaco mostra i suoi effetti piu’ positivi. Inoltre, nelle prove di steroidi il suo tempo di scopterta é piu’ lungo, fino a 5 mesi.</p> <p>Se combinate Boldenone con Deca e Testo Enanthate per 15 settimane, potete ottenere i risultati perfetti. Entrambi Deca e Boldenone sono le sostanze anaboliche. Accumulandosi l’acqua nel sottocutaneo Deca costruisce la massa. Questo é un famaco piu’ forte. Gli effetti collaterali di Deca sono piu’ alti di Boldenone. Deca deve usarsi per 12 settimane. Boldenone ha gli effetti collaterali un po’. &nbsp;E Boldenone blocca gli effetti negativi di Deca.</p> <p>Testo Enanthate e Boldenone (Equipoise) si usano per 12 settimane e invece Deca si usa per 10 settimane. Testo Enanthate deve usarsi minimo 250 mg alla settimana, Boldenone minimo 300 mg alla settimana e Deca 200 mg alla settimana. Con questa combinazione splendida, voi avrete un corpo perfetto.</p> <p>A causa della aromatizzazione bassa a della ritenzione idrica, Boldenone é un buono farmaco per pre-gara. Esso fornisce un buon aumento nelle pompe con l'aumento nei globuli rossi.</p> <p>&nbsp; EFFETTI COLLATERALI<br /> Gli effetti collaterali visti di Boldenone sono la pelle grassa, acne, perdita di capelli, cambiamenti di umore - aggressione, paranoia, depressione, ritenzione dell’acqua, gonfiore, edema, ipertensione, affaticamento, ginecomastia in alto dosagio, atrofia testicolare e cancro del fegato possibile.</p> [meta_description] => [meta_keyword] => [tag] => [model] => bold-alp [sku] => [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 294 [stock_status] => In Stock [image] => data/Boldebolin.jpg [manufacturer_id] => 41 [manufacturer] => Alpha-Pharma [price] => 74.0000 [special] => [reward] => 0 [points] => 0 [tax_class_id] => 0 [date_available] => 2017-03-06 [weight] => 0.00000000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [rating] => 0 [reviews] => 0 [minimum] => 1 [sort_order] => 1 [status] => 1 [date_added] => 2017-03-07 13:22:03 [date_modified] => 2017-04-12 11:21:33 [viewed] => 1743 ) [300] => Array ( [product_id] => 300 [name] => Halobol 5mg - 50 tabs Alpha-Pharma [description] => [meta_description] => [meta_keyword] => [tag] => [model] => halo-alp [sku] => [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 299 [stock_status] => In Stock [image] => data/alpha-phama Halobol-500x500.jpg [manufacturer_id] => 41 [manufacturer] => Alpha-Pharma [price] => 118.0000 [special] => [reward] => 0 [points] => 0 [tax_class_id] => 0 [date_available] => 2017-03-06 [weight] => 0.00000000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [rating] => 0 [reviews] => 0 [minimum] => 1 [sort_order] => 1 [status] => 1 [date_added] => 2017-03-07 13:26:05 [date_modified] => 2017-04-12 11:37:15 [viewed] => 1079 ) [301] => Array ( [product_id] => 301 [name] => Letromina 2.5mg - 30 tabs Alpha-Pharma [description] => [meta_description] => [meta_keyword] => [tag] => [model] => letalp [sku] => [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 300 [stock_status] => Out Of Stock [image] => data/alpha-phama Letromina-625x794.jpg [manufacturer_id] => 41 [manufacturer] => Alpha-Pharma [price] => 46.0000 [special] => [reward] => 0 [points] => 0 [tax_class_id] => 0 [date_available] => 2017-03-06 [weight] => 0.00000000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [rating] => 0 [reviews] => 0 [minimum] => 1 [sort_order] => 1 [status] => 1 [date_added] => 2017-03-07 13:30:37 [date_modified] => 2017-04-12 11:37:30 [viewed] => 1122 ) [302] => Array ( [product_id] => 302 [name] => NandroRapid 100 Alpha-Pharma 10 Ampoules 1ml [description] => [meta_description] => [meta_keyword] => [tag] => [model] => nandr10x1 [sku] => [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 300 [stock_status] => Out Of Stock [image] => data/nandrorapid-100-10-ampul-1-600x600.jpg [manufacturer_id] => 41 [manufacturer] => Alpha-Pharma [price] => 68.0000 [special] => [reward] => 0 [points] => 0 [tax_class_id] => 0 [date_available] => 2017-03-06 [weight] => 0.00000000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [rating] => 0 [reviews] => 0 [minimum] => 1 [sort_order] => 1 [status] => 1 [date_added] => 2017-03-07 13:32:33 [date_modified] => 0000-00-00 00:00:00 [viewed] => 1281 ) [303] => Array ( [product_id] => 303 [name] => Oxanabol 10mg - 50 tabs Alpha-Pharma [description] => [meta_description] => [meta_keyword] => [tag] => [model] => oxalp [sku] => [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 297 [stock_status] => Out Of Stock [image] => data/oxanabol_anavar_10mg_oxandrolone_alpha_pharma.jpg [manufacturer_id] => 41 [manufacturer] => Alpha-Pharma [price] => 70.0000 [special] => [reward] => 0 [points] => 0 [tax_class_id] => 0 [date_available] => 2017-03-06 [weight] => 0.00000000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [rating] => 0 [reviews] => 0 [minimum] => 1 [sort_order] => 1 [status] => 1 [date_added] => 2017-03-07 13:34:49 [date_modified] => 2017-04-12 11:38:56 [viewed] => 1432 ) [304] => Array ( [product_id] => 304 [name] => Oxydrolone 50mg - 50 tabs Alpha-Pharma [description] => [meta_description] => [meta_keyword] => [tag] => [model] => oxy-alp [sku] => [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 290 [stock_status] => Out Of Stock [image] => data/oxymeyholone-alpha.jpg [manufacturer_id] => 41 [manufacturer] => Alpha-Pharma [price] => 66.0000 [special] => [reward] => 0 [points] => 0 [tax_class_id] => 0 [date_available] => 2017-03-06 [weight] => 0.00000000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [rating] => 0 [reviews] => 0 [minimum] => 1 [sort_order] => 1 [status] => 1 [date_added] => 2017-03-07 13:36:20 [date_modified] => 2017-04-12 11:39:10 [viewed] => 1842 ) [305] => Array ( [product_id] => 305 [name] => Rexobol-50 - 50mg - 50 tabs Alpha-Pharma [description] => [meta_description] => [meta_keyword] => [tag] => [model] => rexapl [sku] => [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 282 [stock_status] => Out Of Stock [image] => data/Rexobol_50_Stanozolol_Winstrol_50mg_50Tablets_Alpha_Pharma.jpg [manufacturer_id] => 41 [manufacturer] => Alpha-Pharma [price] => 81.0000 [special] => [reward] => 0 [points] => 0 [tax_class_id] => 0 [date_available] => 2017-03-06 [weight] => 0.00000000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [rating] => 0 [reviews] => 0 [minimum] => 1 [sort_order] => 1 [status] => 1 [date_added] => 2017-03-07 13:39:35 [date_modified] => 2017-04-12 11:41:47 [viewed] => 1928 ) [306] => Array ( [product_id] => 306 [name] => Rexogin 50 Alpha-Pharma 10 Ampoules 1ml [description] => [meta_description] => [meta_keyword] => [tag] => [model] => wins-al [sku] => [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 289 [stock_status] => In Stock [image] => data/rexogin.jpg [manufacturer_id] => 41 [manufacturer] => Alpha-Pharma [price] => 55.0000 [special] => [reward] => 0 [points] => 0 [tax_class_id] => 0 [date_available] => 2017-03-06 [weight] => 0.00000000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [rating] => 0 [reviews] => 0 [minimum] => 1 [sort_order] => 1 [status] => 1 [date_added] => 2017-03-07 13:43:55 [date_modified] => 2017-04-12 11:41:56 [viewed] => 1325 ) [307] => Array ( [product_id] => 307 [name] => Testobase - Alpha-Pharma - 10 Amps - 2ml [description] => [meta_description] => [meta_keyword] => [tag] => [model] => TS-BAS [sku] => [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 295 [stock_status] => Out Of Stock [image] => data/testobase-alpha-pharma-10-amps-10x100mg2ml-.jpg [manufacturer_id] => 41 [manufacturer] => Alpha-Pharma [price] => 48.0000 [special] => [reward] => 0 [points] => 0 [tax_class_id] => 0 [date_available] => 2017-03-06 [weight] => 0.00000000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [rating] => 0 [reviews] => 0 [minimum] => 1 [sort_order] => 1 [status] => 1 [date_added] => 2017-03-07 14:17:14 [date_modified] => 2017-04-12 11:45:48 [viewed] => 973 ) [308] => Array ( [product_id] => 308 [name] => Trenbolin - Alpha-Pharma - 10 Amps - 1ml [description] => [meta_description] => [meta_keyword] => [tag] => [model] => trnbln-al [sku] => [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 1 [stock_status] => Out Of Stock [image] => data/trenbolin.jpg [manufacturer_id] => 41 [manufacturer] => Alpha-Pharma [price] => 195.0000 [special] => [reward] => 0 [points] => 0 [tax_class_id] => 0 [date_available] => 2017-03-06 [weight] => 0.00000000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [rating] => 0 [reviews] => 0 [minimum] => 1 [sort_order] => 1 [status] => 1 [date_added] => 2017-03-07 14:24:07 [date_modified] => 2017-04-12 11:52:01 [viewed] => 888 ) )
Alpha-Pharma
ContattateCi Commenti


Abito a Roma. Dopo 3 giorni del pagamento, ho ricevuto il mio pacco. Avevo ordinato Testosterone Enantato. Grazie.

   --By Roberto Cagliari


Il mio ordine di Danabol é stato cosegnato dopo 4 giorni dal mio pagamento. Ho usato i farmaci, sono abbastanza buoni..

   --By Luigi Salvatore


Fiano ad ordinare, la linea dello supporto del cliente é perfetta, loro aiutano molto. Anche il mio ordine é arrivato. Tutto a posto. Grazie...

   --By Manuele Tinelli


il mio ordine e stato consegnato nei termini.ottima serietà

   --By luigi


Alpha-Pharma

Mostra: Lista / Griglia
Mostra:
Ordina per: