|
SELECT latin_name.id,
CONCAT(IF(common_name.cname3="", "", CONCAT(common_name.cname3, " ")),
IF(common_name.cname2="", "", CONCAT(common_name.cname2, " ")),
common_name.cname1) as c_name,
CONCAT(latin_name.genus, " ", latin_name.lspecies) AS l_name
FROM latin_name
LEFT JOIN common_name ON latin_name.id = common_name.id
LEFT JOIN species_websites ON latin_name.id = species_websites.id
LEFT JOIN species_active ON latin_name.id = species_active.id
WHERE (common_name.primary_flag=1
AND species_active.active_flag=2 AND species_websites.OT=1)
ORDER BY l_name A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
|