JetEngine. Query builder. SQL query to get related items with related metadata

query.sql

-- Please note! in m1.rel_id = 16 row, you need to replace 16 with your actual relation ID
-- and instead of 'walk_time', 'drive_time' and 'public_transport' use your actual meta keys

SELECT 
	m1._ID, 
	m1.parent_object_id, 
	m1.child_object_id, 
	m1.meta_value AS walk_time, 
	m2.meta_value AS drive_time, 
	m3.meta_value AS public_time 
FROM {prefix}jet_rel_default_meta AS m1 
INNER JOIN {prefix}jet_rel_default_meta AS m2 
	ON m1.parent_object_id = m2.parent_object_id AND m1.child_object_id = m2.child_object_id 
INNER JOIN {prefix}jet_rel_default_meta AS m3 
	ON m1.parent_object_id = m3.parent_object_id AND m1.child_object_id = m3.child_object_id  
WHERE 
	m1.rel_id = 16 
	AND m1.meta_key = 'walk_time' 
	AND m2.meta_key = 'drive_time' 
	AND m3.meta_key = 'public_transport' 
	AND m1.parent_object_id = %jsf_filter_query|meta|property||%{"fallback":"4153","context":""} 
	AND m1.child_object_id = %jsf_filter_query|meta|attraction||%{"fallback":"4145","context":""};