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=1
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