Table 'reddot_2025.ec_product' doesn't exist in this syntax
SELECT 'type' AS `category`, `ep`.`type` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
LEFT JOIN ec_product_detail epd
ON ep.product_id = epd.product_id
WHERE ep.path = '1,14,42' AND ep.status = 20 AND ep.`experimental_method` = 'sandwich' AND (ep.sku LIKE '%COL11a1%' OR epd.name LIKE '%COL11a1%' OR epd.content LIKE '%COL11a1%')
GROUP BY ep.`type`
UNION ALL
SELECT 'reactivity' AS `category`, `rt`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
LEFT JOIN ec_product_detail epd
ON ep.product_id = epd.product_id
CROSS JOIN (SELECT 'All Species Reactivity' AS `name`
UNION ALL SELECT 'Bovine/Cow/Cattle' AS `name`
UNION ALL SELECT 'Canine/Dog' AS `name`
UNION ALL SELECT 'Chicken' AS `name`
UNION ALL SELECT 'Equine/Horse' AS `name`
UNION ALL SELECT 'Fish' AS `name`
UNION ALL SELECT 'Food' AS `name`
UNION ALL SELECT 'General' AS `name`
UNION ALL SELECT 'Goat' AS `name`
UNION ALL SELECT 'Guinea Pig' AS `name`
UNION ALL SELECT 'Human' AS `name`
UNION ALL SELECT 'Mouse' AS `name`
UNION ALL SELECT 'Porcine/Pig' AS `name`
UNION ALL SELECT 'Rabbit' AS `name`
UNION ALL SELECT 'Rat' AS `name`
UNION ALL SELECT 'Sheep' AS `name`
UNION ALL SELECT 'Simian/Monkey' AS `name`) rt
WHERE ep.path = '1,14,42' AND ep.status = 20 AND ep.`type` = 'traditional' AND ep.`experimental_method` = 'sandwich' AND (ep.sku LIKE '%COL11a1%' OR epd.name LIKE '%COL11a1%' OR epd.content LIKE '%COL11a1%')
AND ep.reactivity LIKE CONCAT('%', rt.name, '%')
GROUP BY rt.name
UNION ALL
SELECT 'experimental_method' AS `category`, `ep`.`experimental_method` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
LEFT JOIN ec_product_detail epd
ON ep.product_id = epd.product_id
WHERE ep.path = '1,14,42' AND ep.status = 20 AND ep.`type` = 'traditional' AND (ep.sku LIKE '%COL11a1%' OR epd.name LIKE '%COL11a1%' OR epd.content LIKE '%COL11a1%')
GROUP BY ep.`experimental_method`
UNION ALL
SELECT 'research_areas' AS `category`, `ra`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
LEFT JOIN ec_product_detail epd
ON ep.product_id = epd.product_id
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 'Metabolism' AS `name`
UNION ALL SELECT 'Neuroscience' AS `name`
UNION ALL SELECT 'Signal Transduction' AS `name`) ra
WHERE ep.path = '1,14,42' AND ep.status = 20 AND ep.`type` = 'traditional' AND ep.`experimental_method` = 'sandwich' AND (ep.sku LIKE '%COL11a1%' OR epd.name LIKE '%COL11a1%' OR epd.content LIKE '%COL11a1%')
AND ep.research_areas LIKE CONCAT('%', ra.name, '%')
GROUP BY ra.name
Table 'reddot_2025.ec_product_detail' doesn't exist in this syntax
SELECT 'type' AS `category`, `ep`.`type` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
LEFT JOIN ec_product_detail epd
ON ep.product_id = epd.product_id
WHERE ep.path = '1,14,42' AND ep.status = 20 AND ep.`experimental_method` = 'sandwich' AND (ep.sku LIKE '%COL11a1%' OR epd.name LIKE '%COL11a1%' OR epd.content LIKE '%COL11a1%')
GROUP BY ep.`type`
UNION ALL
SELECT 'reactivity' AS `category`, `rt`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
LEFT JOIN ec_product_detail epd
ON ep.product_id = epd.product_id
CROSS JOIN (SELECT 'All Species Reactivity' AS `name`
UNION ALL SELECT 'Bovine/Cow/Cattle' AS `name`
UNION ALL SELECT 'Canine/Dog' AS `name`
UNION ALL SELECT 'Chicken' AS `name`
UNION ALL SELECT 'Equine/Horse' AS `name`
UNION ALL SELECT 'Fish' AS `name`
UNION ALL SELECT 'Food' AS `name`
UNION ALL SELECT 'General' AS `name`
UNION ALL SELECT 'Goat' AS `name`
UNION ALL SELECT 'Guinea Pig' AS `name`
UNION ALL SELECT 'Human' AS `name`
UNION ALL SELECT 'Mouse' AS `name`
UNION ALL SELECT 'Porcine/Pig' AS `name`
UNION ALL SELECT 'Rabbit' AS `name`
UNION ALL SELECT 'Rat' AS `name`
UNION ALL SELECT 'Sheep' AS `name`
UNION ALL SELECT 'Simian/Monkey' AS `name`) rt
WHERE ep.path = '1,14,42' AND ep.status = 20 AND ep.`type` = 'traditional' AND ep.`experimental_method` = 'sandwich' AND (ep.sku LIKE '%COL11a1%' OR epd.name LIKE '%COL11a1%' OR epd.content LIKE '%COL11a1%')
AND ep.reactivity LIKE CONCAT('%', rt.name, '%')
GROUP BY rt.name
UNION ALL
SELECT 'experimental_method' AS `category`, `ep`.`experimental_method` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
LEFT JOIN ec_product_detail epd
ON ep.product_id = epd.product_id
WHERE ep.path = '1,14,42' AND ep.status = 20 AND ep.`type` = 'traditional' AND (ep.sku LIKE '%COL11a1%' OR epd.name LIKE '%COL11a1%' OR epd.content LIKE '%COL11a1%')
GROUP BY ep.`experimental_method`
UNION ALL
SELECT 'research_areas' AS `category`, `ra`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count
FROM ec_product ep
LEFT JOIN ec_product_detail epd
ON ep.product_id = epd.product_id
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 'Metabolism' AS `name`
UNION ALL SELECT 'Neuroscience' AS `name`
UNION ALL SELECT 'Signal Transduction' AS `name`) ra
WHERE ep.path = '1,14,42' AND ep.status = 20 AND ep.`type` = 'traditional' AND ep.`experimental_method` = 'sandwich' AND (ep.sku LIKE '%COL11a1%' OR epd.name LIKE '%COL11a1%' OR epd.content LIKE '%COL11a1%')
AND ep.research_areas LIKE CONCAT('%', ra.name, '%')
GROUP BY ra.name
Search Results for "COL11a1" - ELISA Kits
0 Items Found In ELISA Kits / Page 0 - 0
Search No Result
We're sorry. We cannot find any matches for your search term.