SELECT
	test1.id,
	show_child.show_code,
	show_child.start_time,
	show_child.end_time,
	show_child.main_show_id
	
FROM
	(
		SELECT
				group_test.id,
				SUBSTRING_INDEX(
					SUBSTRING_INDEX(group_test.show_code, ',', jack.id),
					',' ,- 1
				) as show_code,
				group_test.dog_owner_name_cn,
				group_test.dog_owner_member_code
			FROM
				(
					SELECT
						mysql.help_topic.help_topic_id as id
					FROM
						mysql.help_topic
					LIMIT 20
				)
					jack
			CROSS JOIN 
		(


		SELECT
			id,
			show_code,
			show_apply.dog_owner_name_cn,
			show_apply.dog_owner_member_code
		FROM
			show_apply
		WHERE
			show_code !=''
		) as group_test
			WHERE
				jack.id BETWEEN 1
			AND (
				SELECT
					1 + LENGTH(group_test.show_code) - LENGTH(REPLACE(group_test.show_code, ',', ''))
			)
			ORDER BY
				id,
				show_code
	) as test1
LEFT JOIN
	show_child
ON
	trim(test1.show_code) = show_child.show_code