SELECT exc_list.seller_id, exc_list.exc_id, exc_name, exc_time, exc_cost, exc_cost_ch, exc_cost_econom, exc_cost_ch_econom, child_age, exc_days, town_name, exc_length, on_foot, tour_program, exc_type, hide_exc, exc_short_text, exc_text, main_foto, route_id, show_banner, individual_exc, individual_cost, escort_only, exc_lang, exc_md_file, exc_attention, not_include, hide_in_timetable, 0 AS show_hidden, IF( exc_list.exc_id=0, 0, IF(exc_list.show_banner=1, 1, 2) ) AS pos FROM exc_list WHERE seller_id IN (1) AND hide_exc=0 AND ( ( individual_exc=0 AND LOCATE('transelbrus', exc_type) ) OR exc_list.exc_id=0 ) ORDER BY pos, exc_cost;