query error User 'conchylinet' has exceeded the 'max_questions' resource (current value: 1081)
try again later
SELECT DISTINCTROW tbl602_conchylinet_taxons.taxonID, tbl602_conchylinet_taxons.taxonName, tbl602_conchylinet_taxons.Specie, tbl602_conchylinet_taxons.MaxSize, tbl602_conchylinet_taxons.Family, tbl602_conchylinet_taxons.taxonOrder, tbl602_conchylinet_taxons.Class, tbl602_conchylinet_taxons.taxonShape2,
tbl602_conchylinet_taxons.MaxSize, tbl602_conchylinet_taxons.taxonHasPhoto, min(tbl606_conchylinet_sites.Province) as Province, min(tbl606_conchylinet_sites.str_ProvinceBackColorCode) as str_ProvinceBackColorCode, min(tbl606_conchylinet_sites.str_ProvinceFontColorCode) as str_ProvinceFontColorCode
FROM (tbl602_conchylinet_taxons
INNER JOIN tbl604_conchylinet_shells ON tbl602_conchylinet_taxons.taxonID = tbl604_conchylinet_shells.TaxonId)
INNER JOIN tbl606_conchylinet_sites ON tbl604_conchylinet_shells.SiteId = tbl606_conchylinet_sites.ID_Location WHERE ((tbl602_conchylinet_taxons.Family)="Chromodorididae" AND (tbl606_conchylinet_sites.Province)="IndoPacific" AND (tbl602_conchylinet_taxons.MaxSize) BETWEEN 0 AND 500 AND ((tbl602_conchylinet_taxons.taxonHasPhoto)=1))
GROUP BY taxonID, taxonName, Specie, MaxSize, Family, taxonOrder, Class, MaxSize, taxonHasPhoto, taxonShape2
ORDER BY Family, Specie;