Shop

SELECT
            amenities.id, amenities.title, amenities.code, amenities.icon, amenities.status, ordering, amenities.group_id, amenities.input, amenities.for
            , amenities_groups.title AS group_title
            , amenities_groups.icon AS group_icon , property_amenities.amenity_value AS `value` FROM amenities
            LEFT JOIN amenities_groups ON (amenities.group_id = amenities_groups.id) LEFT JOIN property_amenities ON (amenities.id = property_amenities.amenity_id  AND property_amenities.property_id='5197' ) WHERE 1 
         AND `for` IN('Property', 'All')
         
        GROUP BY amenities.id
        ORDER BY amenities.input, amenities.ordering, amenities.group_id ASC