SELECT `id`, `default_value`, `is_required`, `entity_type_id`, `attribute_code`, `frontend_input`, frontend_label, `is_user_defined` FROM `eav_attribute` WHERE (`company_id` = :company_id OR `company_id` = :zero_company_id) AND `id` IN(100,102,101,142,234,110,240,227,228,229) ORDER BY order_by ASC