SELECT d.*,cdf.* from dogs d LEFT JOIN dogs_components dc ON d.id=dc.dog_id LEFT JOIN components_dog_friendly cdf ON dc.component_id=cdf.id LEFT JOIN components_dog_adaptation cda ON dc.component_id=cda.id LEFT JOIN components_dog_care cdc ON dc.component_id=cdc.id LEFT JOIN components_dog_teachability cdt ON dc.component_id=cdt.id WHERE d.status='1' and ( cdf.dogs='5,0' or cdf.family='5,0' ) and ( cdf.dogs='5,0' or cdf.family='5,0' ) and ( cda.sensitivity='5,0' or cda.left_alone='5,0' or cda.tolerates_cold='5,0' or cda.kept_flat='5,0' or cda.tolerates_heat='5,0' ) and ( cdt.intelligent='5,0' ) group BY d.id ORDER BY d.name asc Haziallat.hu | Kutyafajták

Kutyafajták - 1. oldal

88 db találat

Összesen 88 találat