SELECT SQL_CACHE u.user_text,u.user_phone_pre,u.user_phone,u.user_phone1_pre,u.user_phone1,a.*, c.model FROM sed_users u INNER JOIN sed_zautos a USING(user_id) INNER JOIN sed_zcars c ON (a.auto_model = c.id) WHERE ( a.valid_before>NOW() OR u.user_maingrp=12 ) AND a.visible=1 ORDER BY a.auto_id DESC;