- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
SELECT
P.ID PROPERTY_ID,
V.VALUE ARTNUMBER,
B.NAME IBLOCK_NAME,
GROUP_CONCAT(V.IBLOCK_ELEMENT_ID SEPARATOR "\n") ELEMENTS_ID,
GROUP_CONCAT(E.NAME SEPARATOR "\n") ELEMENTS_NAME,
GROUP_CONCAT(E.ACTIVE SEPARATOR "\n") ELEMENTS_ACTIVE,
COUNT( * ) COUNT
FROM
b_iblock_element_property V
LEFT JOIN b_iblock B
ON
B.IBLOCK_TYPE_ID = 'xmlcatalog'
AND
-- Каталог рус
B.CODE = ''
-- Каталог укр
-- B.CODE = 'catalog_ua'
LEFT JOIN b_iblock_property P
ON
P.CODE = 'ARTICLE'
AND
P.IBLOCK_ID = B.ID
LEFT JOIN b_iblock_element E
ON
E.ID = V.IBLOCK_ELEMENT_ID
WHERE
V.VALUE != ''
AND
V.IBLOCK_PROPERTY_ID = P.ID
GROUP BY
V.VALUE
HAVING
COUNT( * ) > 1
ORDER BY
IBLOCK_NAME ASC,
ARTNUMBER ASC;