Hotel Margun
SELECT
d.tid AS id_detail,
dl.title AS detail_title,
ol.title AS option_title,
ol.value AS option_value,
o.datatype,
i.id_column,
IF(o.datatype='string', (SELECT value FROM wct_point_service_item_language WHERE id_column=c.tid AND id_service_option=o.tid AND id_language=ol.id_language), i.value) AS item_value
FROM
wct_point_service_detail AS d,
wct_point_service_detail_language AS dl,
wct_point_service_detail_option AS o,
wct_point_service_detail_option_language AS ol,
wct_point_service_column AS c,
wct_point_service_item AS i
WHERE
d.id_service='2'
AND d.tid=dl.id_service_detail
AND dl.id_language='1'
AND d.visible='1'
AND o.id_service_detail=d.tid
AND o.visible=d.visible
AND o.tid=ol.id_service_option
AND ol.id_language=dl.id_language
AND i.id_service_option=o.tid
AND c.id_info='2392'
AND i.id_column=c.tid
ORDER BY
d.id_position ASC,
o.id_position ASC: Disk full (/tmp/#sql_4a8_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")