Muga-2

		SELECT tx_akabaproductos_domain_model_variants.*, sys_file.storage, sys_file.identifier AS imagen, pages.slug, pages.hidden as oculto, tx_akabaproductos_collections_variants_mm.sorting AS sortingv, tx_akabaproductos_domain_model_variants.page as paginadestino
		FROM tx_akabaproductos_domain_model_collections
		LEFT JOIN tx_akabaproductos_collections_variants_mm
		ON tx_akabaproductos_domain_model_collections.uid = tx_akabaproductos_collections_variants_mm.uid_local
		LEFT JOIN tx_akabaproductos_domain_model_variants
		ON tx_akabaproductos_domain_model_variants.uid = tx_akabaproductos_collections_variants_mm.uid_foreign
		LEFT JOIN sys_file_reference
		ON tx_akabaproductos_domain_model_variants.uid = sys_file_reference.uid_foreign
		LEFT JOIN sys_file
		ON sys_file_reference.uid_local = sys_file.uid
		LEFT JOIN pages
		ON pages.uid = tx_akabaproductos_domain_model_variants.page
		WHERE tx_akabaproductos_domain_model_collections.page=100
		AND tx_akabaproductos_domain_model_variants.hidden=0
		AND tx_akabaproductos_domain_model_variants.deleted=0
		AND tx_akabaproductos_domain_model_variants.sys_language_uid=-1
		AND sys_file_reference.hidden=0
		AND sys_file_reference.deleted=0
		AND sys_file_reference.tablenames="tx_akabaproductos_domain_model_variants"	
		AND sys_file_reference.fieldname="image"
		UNION
		SELECT tx_akabaproductos_domain_model_variants2.*, sys_file2.storage, sys_file2.identifier AS imagen, pages2.slug, pages2.hidden as oculto, tx_akabaproductos_collections_variants_mm2.sorting AS sortingv, tx_akabaproductos_domain_model_variants2.page as paginadestino
		FROM tx_akabaproductos_domain_model_collections as tx_akabaproductos_domain_model_collections2
		LEFT JOIN tx_akabaproductos_collections_variants_mm as tx_akabaproductos_collections_variants_mm2
		ON tx_akabaproductos_domain_model_collections2.uid = tx_akabaproductos_collections_variants_mm2.uid_local
		LEFT JOIN tx_akabaproductos_domain_model_variants as tx_akabaproductos_domain_model_variants2
		ON tx_akabaproductos_domain_model_variants2.l10n_parent = tx_akabaproductos_collections_variants_mm2.uid_foreign
		LEFT JOIN sys_file_reference as sys_file_reference2
		ON tx_akabaproductos_domain_model_variants2.uid = sys_file_reference2.uid_foreign
		LEFT JOIN sys_file as sys_file2
		ON sys_file_reference2.uid_local = sys_file2.uid
		LEFT JOIN pages as pages2
		ON pages2.uid = tx_akabaproductos_domain_model_variants2.page
		WHERE tx_akabaproductos_domain_model_collections2.page=100
		AND tx_akabaproductos_domain_model_variants2.hidden=0
		AND tx_akabaproductos_domain_model_variants2.deleted=0
		AND tx_akabaproductos_domain_model_variants2.sys_language_uid=2
		AND sys_file_reference2.hidden=0
		AND sys_file_reference2.deleted=0
		AND sys_file_reference2.tablenames="tx_akabaproductos_domain_model_variants"	
		AND sys_file_reference2.fieldname="image"
		ORDER BY sortingv ASC

Variantes

Muga-2 >