Antibodies for Hamster,mouse,yeast,rat,dog in Signal Transduction
Table 'reddot_2025.ec_product' doesn't exist in this syntax
SELECT 'category_type' AS `category`, `ep`.`category_type` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
WHERE ep.path = '1,14,41' AND ep.status = 20 AND (ep.`reactivity` LIKE '%hamster%' AND ep.`reactivity` LIKE '%mouse%' AND ep.`reactivity` LIKE '%yeast%' AND ep.`reactivity` LIKE '%rat%' AND ep.`reactivity` LIKE '%dog%') AND ep.`research_areas` LIKE '%signal transduction%'
GROUP BY ep.`category_type`
UNION ALL
SELECT 'host' AS `category`, `ep`.`host` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
WHERE ep.path = '1,14,41' AND ep.status = 20 AND (ep.`reactivity` LIKE '%hamster%' AND ep.`reactivity` LIKE '%mouse%' AND ep.`reactivity` LIKE '%yeast%' AND ep.`reactivity` LIKE '%rat%' AND ep.`reactivity` LIKE '%dog%') AND ep.`research_areas` LIKE '%signal transduction%'
GROUP BY ep.`host`
UNION ALL
SELECT 'reactivity' AS `category`, `rt`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
CROSS JOIN (SELECT 'All' AS `name`
UNION ALL SELECT 'AcMNPV' AS `name`
UNION ALL SELECT 'Bovine' AS `name`
UNION ALL SELECT 'Caprine' AS `name`
UNION ALL SELECT 'Chicken' AS `name`
UNION ALL SELECT 'Cow' AS `name`
UNION ALL SELECT 'Cytomegalovirus' AS `name`
UNION ALL SELECT 'Dengue Virus' AS `name`
UNION ALL SELECT 'Dog' AS `name`
UNION ALL SELECT 'Drosophila Melanogaster' AS `name`
UNION ALL SELECT 'E.coli' AS `name`
UNION ALL SELECT 'Ebola Virus' AS `name`
UNION ALL SELECT 'Enterovirus 7' AS `name`
UNION ALL SELECT 'Epstein-Barr Virus' AS `name`
UNION ALL SELECT 'Escherichia Coli' AS `name`
UNION ALL SELECT 'Firefly' AS `name`
UNION ALL SELECT 'Fish' AS `name`
UNION ALL SELECT 'Fruitfly' AS `name`
UNION ALL SELECT 'Gibel Carp' AS `name`
UNION ALL SELECT 'Goat' AS `name`
UNION ALL SELECT 'Guinea Pig' AS `name`
UNION ALL SELECT 'Hamster' AS `name`
UNION ALL SELECT 'HCoV-HKU1' AS `name`
UNION ALL SELECT 'Hepatitis C Virus' AS `name`
UNION ALL SELECT 'HIV' AS `name`
UNION ALL SELECT 'HPV' AS `name`
UNION ALL SELECT 'Human' AS `name`
UNION ALL SELECT 'Human Recombinant Protein' AS `name`
UNION ALL SELECT 'Insect' AS `name`
UNION ALL SELECT 'MERS-CoV' AS `name`
UNION ALL SELECT 'Monkey' AS `name`
UNION ALL SELECT 'Mouse' AS `name`
UNION ALL SELECT 'Mouse Mab' AS `name`
UNION ALL SELECT 'Nematode' AS `name`
UNION ALL SELECT 'P.gingivalis' AS `name`
UNION ALL SELECT 'Pig' AS `name`
UNION ALL SELECT 'Plants' AS `name`
UNION ALL SELECT 'Porcine' AS `name`
UNION ALL SELECT 'Rabbit' AS `name`
UNION ALL SELECT 'Rat' AS `name`
UNION ALL SELECT 'Recombinant Protein' AS `name`
UNION ALL SELECT 'Renilla Luciferase' AS `name`
UNION ALL SELECT 'RSV' AS `name`
UNION ALL SELECT 'RVFV' AS `name`
UNION ALL SELECT 'SARS' AS `name`
UNION ALL SELECT 'SARS-COV2' AS `name`
UNION ALL SELECT 'SARS-COV2 Spike S2' AS `name`
UNION ALL SELECT 'Scallop' AS `name`
UNION ALL SELECT 'Sheep' AS `name`
UNION ALL SELECT 'Staphylococcus Aureus' AS `name`
UNION ALL SELECT 'Streptococcus Pyogenes' AS `name`
UNION ALL SELECT 'WNV' AS `name`
UNION ALL SELECT 'Xenopus Tropicalis' AS `name`
UNION ALL SELECT 'Yeast' AS `name`
UNION ALL SELECT 'Zebra' AS `name`
UNION ALL SELECT 'Zebrafish' AS `name`
UNION ALL SELECT 'Zika Virus' AS `name`) rt
WHERE ep.path = '1,14,41' AND ep.status = 20 AND (ep.`reactivity` LIKE '%hamster%' AND ep.`reactivity` LIKE '%mouse%' AND ep.`reactivity` LIKE '%yeast%' AND ep.`reactivity` LIKE '%rat%' AND ep.`reactivity` LIKE '%dog%') AND ep.`research_areas` LIKE '%signal transduction%'
AND ep.reactivity LIKE CONCAT('%', rt.name, '%')
GROUP BY rt.name
UNION ALL
SELECT 'applications' AS `category`, `at`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
CROSS JOIN (SELECT 'All Applications' AS `name`
UNION ALL SELECT 'Activ' AS `name`
UNION ALL SELECT 'Apoptosis' AS `name`
UNION ALL SELECT 'Binding' AS `name`
UNION ALL SELECT 'Block' AS `name`
UNION ALL SELECT 'Cell Sep-Neg' AS `name`
UNION ALL SELECT 'ChIP' AS `name`
UNION ALL SELECT 'Depletion' AS `name`
UNION ALL SELECT 'Dot Blot' AS `name`
UNION ALL SELECT 'ELISA' AS `name`
UNION ALL SELECT 'FA' AS `name`
UNION ALL SELECT 'FC' AS `name`
UNION ALL SELECT 'ICC' AS `name`
UNION ALL SELECT 'ICC/IF' AS `name`
UNION ALL SELECT 'ICFC' AS `name`
UNION ALL SELECT 'IF' AS `name`
UNION ALL SELECT 'IHC' AS `name`
UNION ALL SELECT 'IHC-p' AS `name`
UNION ALL SELECT 'Inhibition' AS `name`
UNION ALL SELECT 'IP' AS `name`
UNION ALL SELECT 'Microneutralization' AS `name`
UNION ALL SELECT 'Neut' AS `name`
UNION ALL SELECT 'Neutralization' AS `name`
UNION ALL SELECT 'Ready To Use For IHC-P' AS `name`
UNION ALL SELECT 'Stim' AS `name`
UNION ALL SELECT 'WB' AS `name`) at
WHERE ep.path = '1,14,41' AND ep.status = 20 AND (ep.`reactivity` LIKE '%hamster%' AND ep.`reactivity` LIKE '%mouse%' AND ep.`reactivity` LIKE '%yeast%' AND ep.`reactivity` LIKE '%rat%' AND ep.`reactivity` LIKE '%dog%') AND ep.`research_areas` LIKE '%signal transduction%'
AND ep.applications LIKE CONCAT('%', at.name, '%')
GROUP BY at.name
UNION ALL
SELECT 'research_areas' AS `category`, `ra`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
CROSS JOIN (SELECT 'All Research Areas' AS `name`
UNION ALL SELECT 'Cancer' AS `name`
UNION ALL SELECT 'Cardiovascular' AS `name`
UNION ALL SELECT 'Cell Biology' AS `name`
UNION ALL SELECT 'Developmental Biology' AS `name`
UNION ALL SELECT 'Epigenetics And Nuclear Signaling' AS `name`
UNION ALL SELECT 'Immunology' AS `name`
UNION ALL SELECT 'Isotype' AS `name`
UNION ALL SELECT 'Loading Controls' AS `name`
UNION ALL SELECT 'Metabolism' AS `name`
UNION ALL SELECT 'Microbiology' AS `name`
UNION ALL SELECT 'Neuroscience' AS `name`
UNION ALL SELECT 'Signal Transduction' AS `name`
UNION ALL SELECT 'Stem Cells' AS `name`
UNION ALL SELECT 'Tags & Cell Markers' AS `name`
UNION ALL SELECT 'Others' AS `name`) ra
WHERE ep.path = '1,14,41' AND ep.status = 20 AND (ep.`reactivity` LIKE '%hamster%' AND ep.`reactivity` LIKE '%mouse%' AND ep.`reactivity` LIKE '%yeast%' AND ep.`reactivity` LIKE '%rat%' AND ep.`reactivity` LIKE '%dog%')
AND ep.research_areas LIKE CONCAT('%', ra.name, '%')
GROUP BY ra.name