SELECT ast.company_id,
ast.job_title,
ast.job_location,
ast.bundesland_id,
ast.gender,
ast.id,
uc.company_name,
uc.user_id,
ast.timestamp_start,
ast.timestamp_position
FROM adv_standart AS ast
LEFT JOIN user_company AS uc ON uc.id = ast.company_id
WHERE
uc.delete_status = 'f' AND uc.blocked = 'f'
AND ast.timestamp_end >= '1337264833'AND ast.timestamp_start <= '1337264833'AND ast.status='active' AND ast.job_location LIKE '%Bremen%'
AND ast.delete_status = 'f' ORDER BY GREATEST(powerup_timestamp,timestamp_position) DESC
Jobs im Finanzen, Rechnungswesen, Marketing, Controlling, Wirtschaftsprüfung, Vertrieb - Jobs für Wirtschaftswissenschaftler - Jobwiwi.de
