<cfquery name="results">
	SELECT
		l.id,
		l.assetID,
		l.jobID,
		l.status,
		l.errorMessage,
		l.createdAt,
		l.updatedAt,
		l.version,
		l.type
	FROM
		layer_sync_log l
	WHERE
		TRUE

	<cfif id>
		AND
			id = <cfqueryparam value="#id#" sqltype="integer" />
	</cfif>

	<cfif jobID.len()>
		AND
			jobID = <cfqueryparam value="#jobID#" sqltype="varchar" />
	</cfif>

	<cfif assetID>
		AND
			assetID = <cfqueryparam value="#assetID#" sqltype="integer" />
	</cfif>
</cfquery>