Bitrix / Copy infoblock

INSERT INTO b_iblock(`IBLOCK_TYPE_ID`, `LID`, `CODE`, `NAME`, `ACTIVE`,
`SORT`, `LIST_PAGE_URL`, `DETAIL_PAGE_URL`, `SECTION_PAGE_URL`,
`PICTURE`, `DESCRIPTION`, `DESCRIPTION_TYPE`, `RSS_TTL`,
`RSS_ACTIVE`, `RSS_FILE_ACTIVE`, `RSS_FILE_LIMIT`, `RSS_FILE_DAYS`,
`RSS_YANDEX_ACTIVE`, `XML_ID`, `TMP_ID`, `INDEX_ELEMENT`, `INDEX_SECTION`,
`WORKFLOW`, `BIZPROC`, `SECTION_CHOOSER`, `VERSION`, `LAST_CONV_ELEMENT`,
`EDIT_FILE_BEFORE`, `EDIT_FILE_AFTER`, `SECTIONS_NAME`, `SECTION_NAME`,
`ELEMENTS_NAME`, `ELEMENT_NAME`)

SELECT '9', `LID`, `CODE`, `NAME`, `ACTIVE`, `SORT`, `LIST_PAGE_URL`,
`DETAIL_PAGE_URL`, `SECTION_PAGE_URL`, `PICTURE`, `DESCRIPTION`,
`DESCRIPTION_TYPE`, `RSS_TTL`, `RSS_ACTIVE`, `RSS_FILE_ACTIVE`,
`RSS_FILE_LIMIT`, `RSS_FILE_DAYS`, `RSS_YANDEX_ACTIVE`, `XML_ID`, `TMP_ID`,
`INDEX_ELEMENT`, `INDEX_SECTION`, `WORKFLOW`, `BIZPROC`, `SECTION_CHOOSER`,
`VERSION`, `LAST_CONV_ELEMENT`, `EDIT_FILE_BEFORE`, `EDIT_FILE_AFTER`,
`SECTIONS_NAME`, `SECTION_NAME`, `ELEMENTS_NAME`, `ELEMENT_NAME`

FROM `b_iblock` WHERE iblock_type_id='structure'

 AND id = [b]

-------------------------------
INSERT INTO b_iblock_site (iblock_id, site_id)
SELECT [a], site_id FROM b_iblock_site WHERE iblock_id= [b]
-------------------------------
INSERT INTO b_iblock_group (iblock_id, group_id, permission)
SELECT [a], group_id, permission FROM b_iblock_group WHERE iblock_id= [b]
-------------------------------

INSERT INTO b_iblock_fields(iblock_id, field_id, is_required, default_value)
SELECT [a] , field_id, is_required, default_value FROM b_iblock_fields WHERE iblock_id= [b]


-------------------------------

INSERT INTO b_iblock_property(
`IBLOCK_ID`, `NAME`, `ACTIVE`, `SORT`, `CODE`, `DEFAULT_VALUE`,
`PROPERTY_TYPE`, `ROW_COUNT`, `COL_COUNT`, `LIST_TYPE`,
`MULTIPLE`, `XML_ID`, `FILE_TYPE`, `MULTIPLE_CNT`,
`TMP_ID`,
`LINK_IBLOCK_ID`,
`WITH_DESCRIPTION`, `SEARCHABLE`, `FILTRABLE`, `IS_REQUIRED`, `VERSION`,
`USER_TYPE`, `USER_TYPE_SETTINGS`
)

SELECT [a], `NAME`, `ACTIVE`, `SORT`, `CODE`, `DEFAULT_VALUE`, `PROPERTY_TYPE`,
`ROW_COUNT`, `COL_COUNT`, `LIST_TYPE`, `MULTIPLE`, `XML_ID`,
`FILE_TYPE`, `MULTIPLE_CNT`,
id,
`LINK_IBLOCK_ID`,
`WITH_DESCRIPTION`, `SEARCHABLE`, `FILTRABLE`, `IS_REQUIRED`, `VERSION`, `USER_TYPE`,
`USER_TYPE_SETTINGS` FROM `b_iblock_property` WHERE iblock_id= [b]

-------------------------------

INSERT INTO b_iblock_section(
`MODIFIED_BY`, `DATE_CREATE`, `CREATED_BY`, `IBLOCK_ID`, `IBLOCK_SECTION_ID`, `ACTIVE`,
`GLOBAL_ACTIVE`, `SORT`, `NAME`, `PICTURE`, `LEFT_MARGIN`, `RIGHT_MARGIN`, `DEPTH_LEVEL`,
`DESCRIPTION`, `DESCRIPTION_TYPE`, `SEARCHABLE_CONTENT`,
`CODE`,
`XML_ID`, `TMP_ID`, `DETAIL_PICTURE`, `SOCNET_GROUP_ID`
)

SELECT `MODIFIED_BY`, `DATE_CREATE`, `CREATED_BY`, [a] , `IBLOCK_SECTION_ID`, `ACTIVE`,
`GLOBAL_ACTIVE`, `SORT`, `NAME`, `PICTURE`, `LEFT_MARGIN`, `RIGHT_MARGIN`, `DEPTH_LEVEL`,
`DESCRIPTION`, `DESCRIPTION_TYPE`, `SEARCHABLE_CONTENT`,
id ,
`XML_ID`, `TMP_ID`, `DETAIL_PICTURE`,
`SOCNET_GROUP_ID` FROM `b_iblock_section` WHERE iblock_id = [b]

-------------------------------

INSERT INTO b_iblock_element(

`TIMESTAMP_X`, `MODIFIED_BY`, `DATE_CREATE`, `CREATED_BY`, `IBLOCK_ID`, `IBLOCK_SECTION_ID`,
`ACTIVE`, `ACTIVE_FROM`, `ACTIVE_TO`, `SORT`, `NAME`, `PREVIEW_PICTURE`, `PREVIEW_TEXT`,
`PREVIEW_TEXT_TYPE`, `DETAIL_PICTURE`, `DETAIL_TEXT`, `DETAIL_TEXT_TYPE`, `SEARCHABLE_CONTENT`,
`WF_STATUS_ID`, `WF_PARENT_ELEMENT_ID`, `WF_NEW`, `WF_LOCKED_BY`, `WF_DATE_LOCK`, `WF_COMMENTS`,
`IN_SECTIONS`, `XML_ID`,
`CODE`,
`TAGS`, `TMP_ID`, `WF_LAST_HISTORY_ID`, `SHOW_COUNTER`, `SHOW_COUNTER_START`
)

SELECT a.`TIMESTAMP_X`, a.`MODIFIED_BY`, a.`DATE_CREATE`, a.`CREATED_BY`, [a] ,
b.id,
a.`ACTIVE`, a.`ACTIVE_FROM`, a.`ACTIVE_TO`, a.`SORT`, a.`NAME`,
a.`PREVIEW_PICTURE`, a.`PREVIEW_TEXT`, a.`PREVIEW_TEXT_TYPE`, a.`DETAIL_PICTURE`,
a.`DETAIL_TEXT`, a.`DETAIL_TEXT_TYPE`, a.`SEARCHABLE_CONTENT`, a.`WF_STATUS_ID`,
a.`WF_PARENT_ELEMENT_ID`, a.`WF_NEW`, a.`WF_LOCKED_BY`, a.`WF_DATE_LOCK`,
a.`WF_COMMENTS`, a.`IN_SECTIONS`, a.`XML_ID`,
a.id,
a.`TAGS`, a.`TMP_ID`, a.`WF_LAST_HISTORY_ID`, a.`SHOW_COUNTER`, a.`SHOW_COUNTER_START`
FROM `b_iblock_element` a LEFT OUTER JOIN b_iblock_section b
 ON  a.iblock_section_id = b.code
 WHERE  a.iblock_id= [b]


-------------------------------

INSERT INTO b_iblock_element_property (
`IBLOCK_PROPERTY_ID`, `IBLOCK_ELEMENT_ID`, `VALUE`, `VALUE_TYPE`,
`VALUE_ENUM`, `VALUE_NUM`, `DESCRIPTION`
)

SELECT a1.id,
b.id ,
a.VALUE, a.VALUE_TYPE, a.VALUE_ENUM, a.VALUE_NUM, a.DESCRIPTION

FROM b_iblock_element_property a, b_iblock_property a1,
b_iblock_element b

WHERE
a.iblock_property_id = a1.tmp_id AND
a.iblock_element_id=b.code

AND a.iblock_element_id IN (SELECT id FROM b_iblock_element WHERE iblock_id=[a])

-------------------------------

INSERT INTO b_iblock_section_element (
iblock_section_id, iblock_element_id, additional_property_id)

SELECT b.id, c.id, a.additional_property_id
FROM b_iblock_section_element a, b_iblock_section b, b_iblock_element c
WHERE a.iblock_section_id = b.code AND
a.iblock_element_id = c.code AND
a.iblock_element_id IN (SELECT id FROM b_iblock_element WHERE iblock_id= [a]) AND
a.iblock_section_id IN (SELECT id FROM b_iblock_section WHERE iblock_id=[a])


-------------------------------