Swab with Transport Medium
SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1352'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1352'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1350'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1350'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1354'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1354'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '2642'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '2642'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1353'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1353'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1351'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1351'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1358'SELECT p.*,sp.scheda_tecnica_id,p.id as idp FROM crm_prodotti as p
LEFT JOIN media
ON
media.prodotto_id = p.id
LEFT JOIN crm_schede_tecniche_prodotti as sp ON sp.prodotto_id = p.id
WHERE p.id = '1358'
AMIES WITH CARBON - Swab with transport medium
AMIES WITHOUT CARBON - Swab with transport medium
CARY BLAIR - Swabs
HP TRANSPORT MEDIUM
STUART CON CARBONE
STUART SENZA CARBONE
TAMPONI STERILI CON ASTA IN ALLUMINIO (PER PRELIEVO URETRALE)
AMIES WITH CARBON - Swab with transport medium
Pack. with 400 swabs
AMIES WITHOUT CARBON - Swab with transport medium
Pack. with 400 swabs
CARY BLAIR - Swabs
Pack. 400 pads
HP TRANSPORT MEDIUM
Medium for the preservation and transport of endoscopic and biopsy material for the research of Helicobacter pylori.
STUART CON CARBONE
Pack. 400 tamponi
STUART SENZA CARBONE
Pack. 400 tamponi
TAMPONI STERILI CON ASTA IN ALLUMINIO (PER PRELIEVO URETRALE)
Pack. 500 pezzi in blister singolo