Ordering duplicates,... help!

[Flippuh]

Hoe kan ik ervoor zorgen dat de weergegeven duplicates geordered worden bij het credentials.id? Dus niet het totaal result orderen, maar het orderen van de keuze uit welke rij weer te geven uit de verschillende duplicates

Wat er nmlk gebeurt is dat de results van deze query niet altijd de juiste duplicate entry uit de database haalt.

SELECT 
	*,
	CONCAT('
			SELECT * 
		 		FROM credentials 
	 		WHERE email=\'', email, '\'
	 ') AS query,
	CONCAT('
			INSERT INTO credentials ( 
					`first_name`, 
					`name_suffix`, 
					`last_name`, 
					`street`, 
					`house_number`, 
					`zip_code`, 
					`city`, 
					`phone`, 
					`email`
				)VALUES(
					\'', first_name, '\',
					\'',name_suffix, '\',
					\'', last_name, '\',
					\'',	street, '\',
					\'', house_number, '\',
					\'',	zip_code, '\',
					\'', city, '\',
					\'', phone, '\',
					\'',email, '\'
				)
	') AS insert_credentials, 
	CONCAT('
			INSERT INTO images (
				`credential_id`, 
				`rating`, 
				`title`, 
				`image_path`, 
				`status`, 
				`date_added`
			)VALUES(
				(
					SELECT `credentials`.`id` 
						FROM `credentials` 
					WHERE `email`=\'', email, '\' 
					ORDER BY credentials.id ASC
					LIMIT 0, 1
				),
				\'', rating+50, '\', 
				\'', title, '\', 
				\'', image_path, '\', 
				\'', status, '\', 
				\'', date_added, 
				'\')
			') AS insert_images,
	 COUNT(*) as 'Number Duplicates'
FROM credentials 
	JOIN images 
		ON credentials.id=images.credential_id
	GROUP BY credentials.email
	HAVING COUNT(*) > 1

Het resultaat ziet er uit als:

[id] => 1034
            [first_name] => *Naam*
            [name_suffix] => 
            [last_name] => *AchterNaam*
            [street] => Staat
            [house_number] => 48
            [zip_code] => *PostCode*
            [city] => *stad*
            [phone] => *phone*
            [email] => *email*
            [credential_id] => 642
            [rating] => 54
            [title] => stoer
            [image_path] => Image_1034.jpg
            [status] => 0
            [date_added] => 2008-04-02 00:22:32
            [query] => 
			SELECT * 
		 		FROM credentials 
	 		WHERE email='*email*'
	 
            [insert_credentials] => 
			INSERT INTO credentials ( 
					`first_name`, 
					`name_suffix`, 
					`last_name`, 
					`street`, 
					`house_number`, 
					`zip_code`, 
					`city`, 
					`phone`, 
					`email`
				)VALUES(
					'*naam*',
					'',
					'*achternaam*',
					'*straat*',
					'48',
					'*postcode*',
					'*stad*',
					'*phone*',
					'*email*'
				)
	
            [insert_images] => 
			INSERT INTO images (
				`credential_id`, 
				`rating`, 
				`title`, 
				`image_path`, 
				`status`, 
				`date_added`
			)VALUES(
				(
					SELECT `credentials`.`id` 
						FROM `credentials` 
					WHERE `email`='*email*' 
					ORDER BY credentials.id ASC
					LIMIT 0, 1
				),
				'104', 
				'stoer', 
				'Image_1034.jpg', 
				'0', 
				'2008-04-02 00:22:32')
			
            [Number Duplicates] => 2

Alvast bedankt

 

[Flippuh]

Niemand????