tmpstored|1|275| ---------------------------------------------------------------------------- ------- -- Get the current allocation record into local variables ---------------------------------------------------------------------------- ------- SELECT product_id, min_stay, max_stay, TRIM(room_type), sale_start, sale_end_time, sale_end_days, extra_bed_price, description, no_of_people, sun_price, mon_price, tue_price, wed_price, thu_price, fri_price, sat_price, commission_val, commission_type, vat_rate, smoking, room_type_id, ism_merchant.currency_code, drs_product.operating_entity, inf_sun_quantity, inf_mon_quantity, inf_tue_quantity, inf_wed_quantity, inf_thu_quantity, inf_fri_quantity, inf_sat_quantity, ivr_room_type, fixed_stay, self_catering, number_of_nights, set_price, pon_sunprice, pon_monprice, pon_tueprice, pon_wedprice, pon_thuprice, pon_friprice, pon_satprice, no_of_children, subject_to_avail INTO l_product_id, l_min_stay, l_max_stay, l_room_type, l_available_date, l_sale_end_time, l_sale_end_days, l_extra_bed_price, l_lmntsku_descrip, l_no_of_people, l_sun_price, l_mon_price, l_tue_price, l_wed_price, l_thu_price, l_fri_price, l_sat_price, l_commission_val, l_commission_type, l_vat_code, l_smoking, l_room_type_id, l_currency_code, l_operating_entity, l_inf_sun_quantity, l_inf_mon_quantity, l_inf_tue_quantity, l_inf_wed_quantity, l_inf_thu_quantity, l_inf_fri_quantity, l_inf_sat_quantity, l_ivr_room_type, s_fixed_stay, s_self_catering, l_number_of_nights, l_set_price, l_pon_sunprice, l_pon_monprice, l_pon_tueprice, l_pon_wedprice, l_pon_thuprice, l_pon_friprice, l_pon_satprice, l_no_of_children, l_subj_to_avail FROM lmn_htl_alloc, drs_product, ism_merchant WHERE lmn_htl_alloc.id = i_alloc_id AND lmn_htl_alloc.product_id = drs_product.id AND drs_product.operating_entity = ism_merchant.operating_entity;| tmpstored|2|449| ---------------------------------------------------------------------------- ------- -- NIGHTS STAY RULE -- Inserts a new rule into modifier rules (if its not already there) -- l_minmaxstay_rule gets set to the rule id ---------------------------------------------------------------------------- ------- SELECT rule_type.rule_type_id, MIN(rule_id) INTO l_rule_type_id, l_minmaxstay_rule FROM rule_type,OUTER modifier_rules WHERE modifier_rules.rule_type_id = rule_type.rule_type_id AND UPPER(rule_type.name) = "NIGHTS STAY" AND min_val = l_min_stay AND max_val = l_max_stay GROUP BY 1;| tmpstored|3|463| SELECT MAX(rule_id) INTO l_minmaxstay_rule FROM modifier_rules;| tmpstored|4|486| ---------------------------------------------------------------------------- ------- -- MAXIMUM OCCUPANCY RULE -- Inserts a new rule into modifier rules (if its not already there) -- l_maxoccup_rule gets set to the rule id ---------------------------------------------------------------------------- ------- -- Do max occupancy rules exist? SELECT rule_type.rule_type_id,MIN(rule_id) INTO l_rule_type_id, l_maxoccup_rule FROM rule_type,OUTER modifier_rules WHERE modifier_rules.rule_type_id = rule_type.rule_type_id AND UPPER(rule_type.name) = "OCCUPANCY" AND max_val = l_no_of_people GROUP BY 1;| tmpstored|5|499| SELECT MAX(rule_id) INTO l_maxoccup_rule FROM modifier_rules;| tmpstored|6|521| ---------------------------------------------------------------------------- ------- -- MAXIMUM CHILD OCCUPANCY RULE -- Inserts a new rule into modifier rules (if its not already there) -- l_maxchild_rule gets set to the rule id ---------------------------------------------------------------------------- ------- -- Do max child occupancy rules exist? SELECT rule_type.rule_type_id,MIN(rule_id) INTO l_rule_type_id, l_maxchild_rule FROM rule_type,OUTER modifier_rules WHERE modifier_rules.rule_type_id = rule_type.rule_type_id AND UPPER(rule_type.name) = "CHILD OCCUPANCY" AND max_val = l_no_of_children GROUP BY 1;| tmpstored|7|534| SELECT MAX(rule_id) INTO l_maxchild_rule FROM modifier_rules;| tmpstored|8|561| SELECT ism_pm_type.modifier_type, MIN(ism_price_modifier.id) INTO l_modifier_type, l_ism_pm_id FROM ism_pm_type, OUTER ism_price_modifier WHERE UPPER(ism_pm_type.name) = "EXTRA BED PRICE" AND ism_price_modifier.modifier_type = ism_pm_type.modifier_type AND ism_price_modifier.delta = l_extra_bed_price AND ism_price_modifier.commission_val = l_commission_val AND ism_price_modifier.commission_type = l_commission_type AND ism_price_modifier.currency_code = l_currency_code GROUP BY 1;| tmpstored|9|598| SELECT id INTO l_dummy FROM ism_pm_lang_desc WHERE id = l_ism_pm_id AND language = l_home_language;| tmpstored|10|837| ------------------------------------------------- -- Check if this day has been closed ------------------------------------------------- SELECT 1 INTO l_dummy FROM lmn_htl_alc_close WHERE lmn_htl_alloc_id = i_alloc_id AND closeout = l_this_date;| tmpstored|11|855| ---------------------------------------------------------- -- Check just in case this sku is already there -- NB data entry will switch off all skus before calling this -- procedure but it may be useful when calling from the auto proc --------------------------------------------------------- SELECT 1 INTO l_dummy FROM drs_sku s, lmn_sku_ext_htl se WHERE s.id = se.sku_id AND se.lmn_htl_alloc_id = i_alloc_id AND s.available = 'T' AND s.allocation_start = EXTEND (l_this_date, YEAR TO SECOND);| tmpstored|12|964| SELECT i_sku_id, l_ivr_room_type FROM tmpsku ;| tmpstored|13|1141| --value is not reserved but the name is --must lookup in skuatt dict SELECT value INTO o_value FROM lmn_skuatts_dict WHERE language=i_to_lang AND id IN ( SELECT MIN(id) FROM lmn_skuatts_dict WHERE UPPER(name) = UPPER(i_name) AND ucvalue = UPPER(i_value) AND language = i_from_lang );| tmpstored|14|1147| SELECT MIN(id) FROM lmn_skuatts_dict WHERE UPPER(name) = UPPER(i_name) AND ucvalue = UPPER(i_value) AND language = i_from_lang| tmpstored|15|1184| --Name is not reserved --Need to look up both name and value in dict SELECT value, name INTO o_value, o_name FROM lmn_skuatts_dict WHERE language=i_to_lang AND id IN ( SELECT MIN(id) FROM lmn_skuatts_dict WHERE UPPER(name) = UPPER(i_name) AND ucvalue = UPPER(i_value) AND language = i_from_lang );| tmpstored|16|1196| SELECT MIN(id) FROM lmn_skuatts_dict WHERE UPPER(name) = UPPER(i_name) AND ucvalue = UPPER(i_value) AND language = i_from_lang| tmpstored|17|1385| --value is not reserved but the name is --must lookup in skuatt dict SELECT value INTO o_value FROM lmn_skuatts_dict WHERE language=i_to_lang AND id IN ( SELECT MIN(id) FROM lmn_skuatts_dict WHERE UPPER(name) = UPPER(i_name) AND ucvalue = UPPER(i_value) AND language = i_from_lang );| tmpstored|18|1391| SELECT MIN(id) FROM lmn_skuatts_dict WHERE UPPER(name) = UPPER(i_name) AND ucvalue = UPPER(i_value) AND language = i_from_lang| tmpstored|19|1431| --Name is not reserved --Need to look up both name and value in dict -- dennis: need to add a hash of both name and alue in -- lmn_skuatts_dict SELECT value, name INTO o_value, o_name FROM lmn_skuatts_dict WHERE language=i_to_lang AND id IN ( SELECT MIN(id) FROM lmn_skuatts_dict -- WHERE UPPER(name) = UPPER(i_name) -- AND ucvalue = UPPER(i_value) WHERE hash_upname = l_hashupname AND hash_ucvalue = l_hashupvalue AND language = i_from_lang );| tmpstored|20|1443| SELECT MIN(id) FROM lmn_skuatts_dict -- WHERE UPPER(name) = UPPER(i_name) -- AND ucvalue = UPPER(i_value) WHERE hash_upname = l_hashupname AND hash_ucvalue = l_hashupvalue AND language = i_from_lang| tmpstored|21|1586| SELECT DISTINCT t.translated INTO l_phrase FROM lmnt_sku t, drs_sku s, drs_sku_attributes sa WHERE t.id = s.id AND s.id = sa.sku_id AND sa.product_id = i_product_id AND t.language = i_home_lang| tmpstored|22|1652| SELECT DISTINCT sa.name, sa.value INTO l_name, l_value FROM drs_sku s, drs_sku_attributes sa WHERE s.id = sa.sku_id AND sa.product_id = i_product_id| tmpstored|23|1730| SELECT DISTINCT t.description INTO l_phrase FROM ism_pm_lang_desc t, ism_pm_cat_prod p, drs_sku_attributes sa, drs_sku s WHERE p.id = t.id AND t.language = i_home_lang AND sa.product_id = i_product_id AND sa.sku_id = s.id AND s.id = p.sku_id| tmpstored|24|1902| SELECT DISTINCT t.translated INTO l_phrase FROM lmnt_sku t, drs_sku s, drs_sku_attributes sa WHERE t.id = s.id AND s.id = sa.sku_id AND sa.product_id = i_product_id AND t.language = i_home_lang| tmpstored|25|1969| SELECT DISTINCT sa.name, sa.value INTO l_name, l_value FROM drs_sku s, drs_sku_attributes sa WHERE s.id = sa.sku_id AND sa.product_id = i_product_id| tmpstored|26|2048| SELECT DISTINCT t.description INTO l_phrase FROM ism_pm_lang_desc t, ism_pm_cat_prod p, drs_sku_attributes sa, drs_sku s WHERE p.id = t.id AND t.language = i_home_lang AND sa.product_id = i_product_id AND sa.sku_id = s.id AND s.id = p.sku_id| tmpstored|27|2246| SELECT DISTINCT t.translated INTO l_phrase FROM lmnt_sku t, drs_sku s, drs_sku_attributes sa WHERE t.id = s.id AND s.id = sa.sku_id AND sa.product_id = i_product_id AND t.language = i_home_lang| tmpstored|28|2313| SELECT DISTINCT sa.name, sa.value INTO l_name, l_value FROM drs_sku s, drs_sku_attributes sa WHERE s.id = sa.sku_id AND sa.product_id = i_product_id| tmpstored|29|2392| SELECT DISTINCT t.description INTO l_phrase FROM ism_pm_lang_desc t, ism_pm_cat_prod p, drs_sku_attributes sa, drs_sku s WHERE p.id = t.id AND t.language = i_home_lang AND sa.product_id = i_product_id AND sa.sku_id = s.id AND s.id = p.sku_id| tmpstored|30|2529| SELECT type_id INTO l_test FROM lmn_skut_resname WHERE type_id = i_type_id AND name = i_name;| tmpstored|31|2616| --Test whether this type_id and name are in the --reserved value table SELECT type_id INTO l_test FROM lmn_skut_resvalue WHERE type_id = i_type_id AND name = i_name;| tmpstored|32|2736| --need with hold as the sub proc uses a transaction SELECT DISTINCT s.id, t.translated INTO l_sku_id, l_description FROM drs_sku s, lmnt_sku t, drs_sku_attributes sa WHERE sa.product_id = i_product_id AND sa.sku_id = t.id AND sa.sku_id = s.id AND t.language = i_home_lang| tmpstored|33|2944| --need with hold as the sub proc uses a transaction SELECT room_type_id, description INTO l_room_type_id, l_description FROM prod_descrips WHERE prod_descrips.product_id = i_product_id| tmpstored|34|2968|SELECT sku_id FROM sku_phrase WHERE product_id = i_product_id AND room_type_id = l_room_type_id| tmpstored|35|2980| SELECT sku_id, l_phrase, i_language, 'T' FROM sku_phrase WHERE product_id = i_product_id AND room_type_id = l_room_type_id;| tmpstored|36|3009| --need with hold as the sub proc uses a transaction SELECT DISTINCT s.id, t.translated INTO l_sku_id, l_description FROM drs_sku s, lmnt_sku t, drs_sku_attributes sa WHERE sa.product_id = i_product_id AND sa.sku_id = t.id AND sa.sku_id = s.id AND t.language = i_home_lang| tmpstored|37|3215| SELECT DISTINCT s.product_id, s.language, st.description, me.language, p.type_id, s.status_id INTO l_product_id, l_language, l_status, l_home_lang, l_type_id, l_status_id FROM lmn_skut s, lmn_skut_status st, drs_product p, lmn_merch_ext me WHERE st.description IN ('REQUIRED','TRANSLATEPMS','TRANSLATESKUS') AND st.id = s.status_id AND s.attempts < 10 AND p.id = s.product_id AND me.operating_entity = p.operating_entity AND s.product_id = i_product_id| tmpstored|38|3255| SELECT DISTINCT s.product_id, s.language, st.description, me.language, p.type_id, s.status_id INTO l_product_id, l_language, l_status, l_home_lang, l_type_id, l_status_id FROM lmn_skut s, lmn_skut_status st, drs_product p, lmn_merch_ext me WHERE st.description IN ('REQUIRED','TRANSLATEPMS','TRANSLATESKUS') AND st.id = s.status_id AND s.attempts < 10 AND p.id = s.product_id AND me.operating_entity = p.operating_entity| tmpstored|39|3663| SELECT DISTINCT s.product_id, s.language, st.description, me.language, p.type_id, s.status_id INTO l_product_id, l_language, l_status, l_home_lang, l_type_id, l_status_id FROM lmn_skut s, lmn_skut_status st, drs_product p, lmn_merch_ext me WHERE st.description IN ('REQUIRED','TRANSLATEPMS','TRANSLATESKUS') AND st.id = s.status_id AND s.attempts < 10 AND p.id = s.product_id AND me.operating_entity = p.operating_entity AND s.product_id = i_product_id| tmpstored|40|3703| SELECT DISTINCT s.product_id, s.language, st.description, me.language, p.type_id, s.status_id INTO l_product_id, l_language, l_status, l_home_lang, l_type_id, l_status_id FROM lmn_skut s, lmn_skut_status st, drs_product p, lmn_merch_ext me WHERE st.description IN ('REQUIRED','TRANSLATEPMS','TRANSLATESKUS') AND st.id = s.status_id AND s.attempts < 10 AND p.id = s.product_id AND me.operating_entity = p.operating_entity| tmpstored|41|4086| SELECT DISTINCT pm.id, t.description INTO l_pm_id, l_description FROM ism_price_modifier pm, ism_pm_lang_desc t, ism_pm_cat_prod pc, drs_sku s, drs_sku_attributes sa WHERE sa.product_id = i_product_id AND pm.id = t.id AND sa.sku_id = s.id AND t.language = i_home_lang AND s.id = pc.sku_id AND pc.id = pm.id| tmpstored|42|4259| SELECT DISTINCT cl.language INTO l_language FROM drs_prod_parents pp, drs_cat_ancestors ca, lmn_cat_language cl WHERE pp.product_id = i_product_id AND pp.category_id = ca.category_id AND ca.ancestor_id = cl.category_id INSERT INTO lmn_skut ( product_id, language, status_id, attempts, error_number, timestamp ) values ( i_product_id, l_language, 1, 0, 0, CURRENT );| tmpstored|43|4492| --check dictionary SELECT phrase INTO o_phrase FROM lmn_trans_dict WHERE language = i_to_lang AND phrase_id IN ( SELECT MIN(phrase_id) FROM lmn_trans_dict WHERE ucphrase = UPPER(i_phrase) AND language = i_from_lang );| tmpstored|44|4498| SELECT MIN(phrase_id) FROM lmn_trans_dict WHERE ucphrase = UPPER(i_phrase) AND language = i_from_lang| tmpstored|45|4654| -- hash UPPER(i_phrase) into a number. -- and put into l_hashofinput --check dictionary -- SELECT phrase -- INTO o_phrase -- FROM lmn_trans_dict -- WHERE language = i_to_lang -- AND phrase_id IN -- ( -- SELECT MIN(phrase_id) -- FROM lmn_trans_dict -- WHERE ucphrase = UPPER(i_phrase) -- AND language = i_from_lang -- ); -- dennis: add to the table lmn_trans_dict the field -- hash_ucphrase which is just a hash of the ucphrase field. -- should be an index language, hash_ucphrase, phrase_id SELECT phrase INTO o_phrase FROM lmn_trans_dict WHERE language = i_to_lang AND phrase_id IN ( SELECT MIN(phrase_id) FROM lmn_trans_dict WHERE hash_ucphrase = l_hashofinput AND language = i_from_lang );| tmpstored|46|4660| SELECT MIN(phrase_id) FROM lmn_trans_dict WHERE hash_ucphrase = l_hashofinput AND language = i_from_lang| tmpstored|47|4840| SELECT product_id, name_id, name, value_id, value INTO l_prod_id, l_name_id, l_name, l_value_id, l_value FROM drs_sku_attributes WHERE sku_id = i_sku_id| tmpstored|48|5024| SELECT MIN (sku_id) INTO l_sku_id FROM lmnt_sku_attribute WHERE sku_id = i_sku_id AND product_id = i_product_id AND name_id is null AND language = i_language;| tmpstored|49|5035| SELECT MIN (sku_id) INTO l_sku_id FROM lmnt_sku_attribute WHERE sku_id = i_sku_id AND product_id = i_product_id AND name_id = i_name_id AND language = i_language;| tmpstored|50|5209| --see if this pm has already been translated SELECT MIN (id) INTO l_pm_id FROM ism_pm_lang_desc WHERE id = i_pm_id AND language = i_language;| tmpstored|51|5374| --see if this sku has already been translated SELECT MIN (id) INTO l_sku_id FROM lmnt_sku WHERE id = i_sku_id AND language = i_language;| tmpstored|52|5619| SELECT product_id, name_id, name, value_id, value INTO l_prod_id, l_name_id, l_name, l_value_id, l_value FROM drs_sku_attributes WHERE sku_id = i_sku_id| prdhdr1sum1119|1|1|SELECT name FROM airport WHERE code = 'MAN'|| prdhdr1sum1119|2|2| select drs_global_info.version, drs_global_info.next_id, drs_global_info.next_image_id, drs_global_info.next_order_number, drs_global_info.live_db from drs_global_info WHERE drs_global_info.version='4.1'|| prdhdr1sum1119|3|4| select x0.type_id ,x0.id from dcs_live_1432:"informix".drs_product x0 where (x0.type_id NOT IN (13 ,17 ,19 ))|| prdhdr1sum1119|4|5| select locale,token,value from lmn_bundles|| prdhdr1sum1119|5|6| select sku.allocation_start as departure_date , sku.value as dodgy_dep_airport , hol.arv_airport as dodgy_dest_airport , sku_star.star_rating as star_rating , board.code as board_type , sku_atts.value as num_nights , sku.price as p_price , hol.destination_title as destination_name , sku.product_id as prod_id , sku.operating_entity as operator_code , prod.name as name , text_short.text as short_desc , text_long.text as description , prod.extra_image as image_id , prod.icon_id as icon_id , sku.sku_id as sku_id , dep_city_1.city_code as iffy_dep_city_code , dep_air.code as iffy_dep_airport_code, case dep_air.code when NULL then dep_city_1.city_code else dep_air.city_code end as dep_city_code , dest_city_1.city_code as iffy_dest_city_code , dest_air.code as iffy_dest_airport_code, case dest_air.code when NULL then dest_city_1.city_code else dest_air.city_code end as dest_city_code , arbo.arbo_id as arbo_id , sku_detail.public_price as old_price from drs_valid_sku sku, outer (lmn_hol_sku_detail sku_detail), drs_sku_attributes sku_atts, lmn_prod_ext_hol hol, drs_valid_product prod, outer (lmn_sku_str_rating sku_star, lmn_sku_board_type sku_board, lmn_board_type board ), drs_text text_short, drs_text text_long, outer (ism_city dep_city_1), outer (lmn_airport dep_air, ism_city dep_city_2), outer (ism_city dest_city_1), outer (lmn_airport dest_air, ism_city dest_city_2), lmn_prod_arbo arbo where sku.sku_id = sku_atts.sku_id and sku.sku_id = sku_star.sku_id and sku.sku_id = sku_board.sku_id and sku_board.board_type_id = board.id and sku.product_id = hol.product_id and prod.id = hol.product_id and sku.type_|| prdhdr1sum1119|6|64| select s.allocation_start, s.value, h.arv_airport, a.value, s.price, h.destination_title, s.product_id from drs_valid_sku s,drs_sku_attributes a, lmn_prod_ext_hol h where s.sku_id = a.sku_id and s.product_id = h.product_id and s.type_id=4 and s.name_id=1 and a.name_id=0 order by s.allocation_start, s.value, h.arv_airport, a.value, s.price|| prdhdr1sum1119|7|66| select x0.allocation_start ,x0.price ,x0.commission_type ,x0.commission_val ,x0.unavailable_date ,x0.id ,x1.quantity ,x1.sku_id ,x2.pon_price ,x2.fixed_stay ,x2.self_catering ,x2.sku_id from dcs_live_1432:"informix".drs_sku x0 ,dcs_live_1432:"informix".drs_inventory x1 ,dcs_live_1432:"informix".lmn_sku_ext_htl x2 where (x0.id = ? ) AND (? = x1.sku_id ) AND (? = x2.sku_id )|| prdhdr1sum1119|8|68| select sku.allocation_start as departure_date , sku.value as departure_airport_code , hol.arv_airport as destination_airport_code , sku_star.star_rating , board.code as board_type , sku_atts.value as num_nights , sku.price as p_price , hol.destination_title as destination_name , prod.id as prod_id , prod.operating_entity as operator_code , prod.name , inv.quantity as alloc , text_short.text as short_desc , text_long.text as description , prod.extra_image as image_id , prod.icon_id , sku.sku_id , 100 - prod.product_order as product_weight , prod_resort.resort_id from drs_valid_product prod, lmn_prod_ext_hol hol, drs_inventory inv, drs_valid_sku sku, drs_sku_attributes sku_atts, outer (lmn_sku_str_rating sku_star), outer (lmn_sku_board_type sku_board, lmn_board_type board), outer (drs_text text_short), outer (drs_text text_long), outer (lmn_prod_resort prod_resort) where prod.id = sku.product_id and prod.id = hol.product_id and prod.id = sku_atts.product_id and prod.id = prod_resort.product_id and prod.id = text_short.id and text_short.type = 'sdsc' and prod.id = text_long.id and text_long.type = 'ldsc' and sku.sku_id = inv.sku_id and sku.sku_id = sku_atts.sku_id and sku.sku_id = sku_star.sku_id and sku.sku_id = sku_board.sku_id and sku_board.board_type_id = board.id and prod.type_id = 4 and sku.name_id = 1 and sku_atts.name_id = 0 and hol.subject_avail = 'T' ;| prdhdr1sum1119|9|120| select x1.product_id from dcs_live_1432:"informix".lmn_prodgroup x0 ,dcs_live_1432:"informix".lmn_prodgroup_item x1 where (x0.description = 'Grupo Meli Hoteles' ) AND (x0.id = x1.prodgroup_id )|| prdhdr1sum1119|10|122| SELECT lmn_bundles.token,lmn_bundles.locale,lmn_bundles.value FROM lmn_bundles|| prdhdr1sum1119|11|126| select drs_global_info.version, drs_global_info.next_id, drs_global_info.next_image_id, drs_global_info.next_order_number, drs_global_info.live_db from drs_global_info WHERE drs_global_info.version='4.1'|| prdhdr1sum1119|12|128| SELECT name FROM airport WHERE code = 'MAN'|| prdhdr1sum1119|13|129| select x0.type_id ,x0.id from dcs_live_1432:"informix".drs_product x0 where (x0.type_id NOT IN (13 ,17 ,19 ))|| prdhdr1sum1119|14|131| select sku.allocation_start as departure_date , sku.value as dodgy_dep_airport , hol.arv_airport as dodgy_dest_airport , sku_star.star_rating as star_rating , board.code as board_type , sku_atts.value as num_nights , sku.price as p_price , hol.destination_title as destination_name , sku.product_id as prod_id , sku.operating_entity as operator_code , prod.name as name , text_short.text as short_desc , text_long.text as description , prod.extra_image as image_id , prod.icon_id as icon_id , sku.sku_id as sku_id , dep_city_1.city_code as iffy_dep_city_code , dep_air.code as iffy_dep_airport_code, case dep_air.code when NULL then dep_city_1.city_code else dep_air.city_code end as dep_city_code , dest_city_1.city_code as iffy_dest_city_code , dest_air.code as iffy_dest_airport_code, case dest_air.code when NULL then dest_city_1.city_code else dest_air.city_code end as dest_city_code , arbo.arbo_id as arbo_id , sku_detail.public_price as old_price from drs_valid_sku sku, outer (lmn_hol_sku_detail sku_detail), drs_sku_attributes sku_atts, lmn_prod_ext_hol hol, drs_valid_product prod, outer (lmn_sku_str_rating sku_star, lmn_sku_board_type sku_board, lmn_board_type board ), drs_text text_short, drs_text text_long, outer (ism_city dep_city_1), outer (lmn_airport dep_air, ism_city dep_city_2), outer (ism_city dest_city_1), outer (lmn_airport dest_air, ism_city dest_city_2), lmn_prod_arbo arbo where sku.sku_id = sku_atts.sku_id and sku.sku_id = sku_star.sku_id and sku.sku_id = sku_board.sku_id and sku_board.board_type_id = board.id and sku.product_id = hol.product_id and prod.id = hol.product_id and sku.type_|| prdhdr1sum1119|15|189| select s.allocation_start, s.value, h.arv_airport, a.value, s.price, h.destination_title, s.product_id from drs_valid_sku s,drs_sku_attributes a, lmn_prod_ext_hol h where s.sku_id = a.sku_id and s.product_id = h.product_id and s.type_id=4 and s.name_id=1 and a.name_id=0 order by s.allocation_start, s.value, h.arv_airport, a.value, s.price|| prdhdr1sum1119|16|191| select x0.allocation_start ,x0.price ,x0.commission_type ,x0.commission_val ,x0.unavailable_date ,x0.id ,x1.quantity ,x1.sku_id ,x2.pon_price ,x2.fixed_stay ,x2.self_catering ,x2.sku_id from dcs_live_1432:"informix".drs_sku x0 ,dcs_live_1432:"informix".drs_inventory x1 ,dcs_live_1432:"informix".lmn_sku_ext_htl x2 where (x0.id = ? ) AND (? = x1.sku_id ) AND (? = x2.sku_id )|| prdhdr1sum1119|17|193| select sku.allocation_start as departure_date , sku.value as departure_airport_code , hol.arv_airport as destination_airport_code , sku_star.star_rating , board.code as board_type , sku_atts.value as num_nights , sku.price as p_price , hol.destination_title as destination_name , prod.id as prod_id , prod.operating_entity as operator_code , prod.name , inv.quantity as alloc , text_short.text as short_desc , text_long.text as description , prod.extra_image as image_id , prod.icon_id , sku.sku_id , 100 - prod.product_order as product_weight , prod_resort.resort_id from drs_valid_product prod, lmn_prod_ext_hol hol, drs_inventory inv, drs_valid_sku sku, drs_sku_attributes sku_atts, outer (lmn_sku_str_rating sku_star), outer (lmn_sku_board_type sku_board, lmn_board_type board), outer (drs_text text_short), outer (drs_text text_long), outer (lmn_prod_resort prod_resort) where prod.id = sku.product_id and prod.id = hol.product_id and prod.id = sku_atts.product_id and prod.id = prod_resort.product_id and prod.id = text_short.id and text_short.type = 'sdsc' and prod.id = text_long.id and text_long.type = 'ldsc' and sku.sku_id = inv.sku_id and sku.sku_id = sku_atts.sku_id and sku.sku_id = sku_star.sku_id and sku.sku_id = sku_board.sku_id and sku_board.board_type_id = board.id and prod.type_id = 4 and sku.name_id = 1 and sku_atts.name_id = 0 and hol.subject_avail = 'T' ;| prdhdr1sum1119|18|245| select x1.product_id from dcs_live_1432:"informix".lmn_prodgroup x0 ,dcs_live_1432:"informix".lmn_prodgroup_item x1 where (x0.description = 'Grupo Meli Hoteles' ) AND (x0.id = x1.prodgroup_id )|| prdhdr1sum1119|19|247| SELECT lmn_bundles.token,lmn_bundles.locale,lmn_bundles.value FROM lmn_bundles|| prdhdr1sum1119|20|248| SELECT name FROM sysdatabases WHERE name != 'sysmaster' AND name matches ? ORDER BY name|| prdhdr2sum1119|1|1|SeLeCt commission_type,self_catering,price,max_adults,product_id,allocation_start,sku_id,pon_price,max_childs,inventory,description,fixed_stay,number_of_nights FROM lmn_hotel_sku_nfs WHERE allocation_start < today + 93 units day and allocation_start >= today|| prdhdr2sum1119|2|3| sElEcT id,name_en_au,ldsc_en_au,name_en_gb,sdsc_en_gb,ldsc_en_gb,name_de_de,sdsc_de_de,ldsc_de_de,name_es_es,sdsc_es_es,ldsc_es_es,name_fr_fr,sdsc_fr_fr,ldsc_fr_fr,name_it_it,sdsc_it_it,ldsc_it_it,name_nl_nl,sdsc_en_au,sdsc_nl_nl,ldsc_nl_nl,name_sv_se,sdsc_sv_se,ldsc_sv_se,name_en_za,sdsc_en_za,ldsc_en_za,available,available_date,unavailable_date,comp_en_au,comp_en_gb,comp_de_de,comp_es_es,comp_fr_fr,comp_it_it,comp_nl_nl,comp_sv_se,comp_en_za,timestamp,small_image,small_name,large_image,large_name,extra_image,extra_name,modifiers,type,template_name,background_color,text_color,link_color,active_link_color,visited_link_color,rule_color,background_image,header_image,show_title,use_defp_temp_name,use_defpback_color,use_defptext_color,use_defplink_color,use_defpact_lcolor,use_defprule_color,use_defpback_image,use_defphead_image,use_defpfoot_image,use_defp_header,use_defp_footer,operating_entity,city_code,rating,country_code,agent_cash_prin,allocation_start,cart_template,allocat| prdhdr2sum1119|3|7| SelECt distinct allocation_start FROM drs_sku,drs_sku_attributes SA,drs_inventory I, lmn_sku_ext_htl LSX WHERE SA.product_id = ? AND drs_sku.id = SA.sku_id AND SA.sku_id=I.sku_id AND I.sku_id=LSX.sku_id AND drs_sku.available_date <= CURRENT AND drs_sku.unavailable_date > CURRENT AND drs_sku.allocation_start >= TODAY AND drs_sku.allocation_start <= TODAY + 84 units day AND drs_sku.complete = 'T' AND drs_sku.available = 'T' AND drs_sku.commission_type != 5 AND I.quantity>I.threshold AND (LSX.fixed_stay ='F' OR LSX.fixed_stay is null) ORDER BY drs_sku.allocation_start|| prdhdr2sum1119|4|9| SELECT commission_type,self_catering,price,max_adults,product_id,allocation_start,sku_id,pon_price,max_childs,inventory,description,fixed_stay,number_of_nights FROM lmn_hotel_sku_nfs WHERE allocation_start < today + 155 units day and allocation_start >= today|| prdhdr2sum1119|5|11| SELECT p.type_id,p.name as name,p.min_price as price,p.operating_entity,p.rating,g.lattitude,g.longitude,g.product_id,c.address1,c.address2,c.city,c.zipcode,c.state,c.country,s.allocation_start as start_date,s.allocation_end as end_date,t.text as description,t.type as description_type,s.sku_id FROM drs_valid_product p, drs_text t,lmn_geocode g,lmn_prod_cont c, drs_valid_sku s WHERE p.type_id = 5 AND g.product_id = p.id AND c.product_id = p.id AND s.product_id = p.id AND (t.id = p.id AND t.type in ('sdsc','ivrd'))|| prdhdr2sum1119|6|13| select prd.id, prd.product_order, prd.type_id, prd.min_price, prd.max_price, prd.city_code, min(dvs.allocation_start) as sku_alloc_start, max(dvs.allocation_end) as sku_alloc_end, prd.name from drs_valid_sku dvs, drs_valid_product prd, drs_prod_parents dpp where dpp.category_id=? and dpp.product_id = prd.id and prd.id=dvs.product_id group by prd.id, prd.product_order, prd.type_id, prd.min_price, prd.max_price, prd.city_code, prd.name|| prdhdr2sum1119|7|15| SELECT airport.code,airport.name,airport.country_code,airport.city_code,airport.show_user FROM airport WHERE airport.country_code IN ( ? ) AND (airport.code IN (select DISTINCT dep_air_code FROM lmn_lates_combo) OR airport.code IN (SELECT distinct value FROM drs_valid_sku WHERE name = 'Departs From' AND type_id =4) OR airport.code IN (SELECT distinct f.dep_airport FROM lmn_topt_flt_route f, drs_valid_sku s WHERE f.sku_id = s.sku_id AND f.direction=0 )) ORDER BY airport.city_code, airport.name|| prdhdr2sum1119|8|15|select DISTINCT dep_air_code FROM lmn_lates_combo| prdhdr2sum1119|9|15|SELECT distinct value FROM drs_valid_sku WHERE name = 'Departs From' AND type_id =4| prdhdr2sum1119|10|15|SELECT distinct f.dep_airport FROM lmn_topt_flt_route f, drs_valid_sku s WHERE f.sku_id = s.sku_id AND f.direction=0| prdhdr2sum1119|11|17| SELECT self_catering,commission_type,price,max_adults,product_id,allocation_start,allocation_end,sku_id,pon_price,max_childs,inventory,description,fixed_stay,number_of_nights FROM lmn_hotel_sku_fs WHERE allocation_start < today + 93 units day and allocation_start >= today|| prdhdr2sum1119|12|19| SELECT lmn_ski_resort.id,lmn_ski_resort.code,lmn_ski_resort.name,lmn_ski_resort.description FROM lmn_ski_resort WHERE lmn_ski_resort.id=?|| prdhdr2sum1119|13|21| SELECT product_id,allocation_start,commission_type,price,sku_id,pon_price,max_adults,max_childs,inventory,description,fixed_stay,number_of_nights,self_catering FROM lmn_hotel_sku_nfs WHERE allocation_start < today + 155 units day and allocation_start >= today|| prdhdr2sum1119|14|25| SELECT p.type_id,p.name as name,p.min_price as price,p.operating_entity,p.rating,g.lattitude,g.longitude,g.product_id,c.address1,c.address2,c.city,c.zipcode,c.state,c.country,s.allocation_start as start_date,s.allocation_end as end_date,t.text as description,t.type as description_type,s.sku_id FROM drs_valid_product p, drs_text t,lmn_geocode g,lmn_prod_cont c, drs_valid_sku s WHERE p.type_id = 5 AND g.product_id = p.id AND c.product_id = p.id AND s.product_id = p.id AND (t.id = p.id AND t.type in ('sdsc','ivrd'))|| prdhdr2sum1119|15|27| SELECT id,name_en_au,ldsc_en_au,name_en_gb,sdsc_en_gb,ldsc_en_gb,name_de_de,sdsc_de_de,ldsc_de_de,name_es_es,sdsc_es_es,ldsc_es_es,name_fr_fr,sdsc_fr_fr,ldsc_fr_fr,name_it_it,sdsc_it_it,ldsc_it_it,name_nl_nl,sdsc_en_au,sdsc_nl_nl,ldsc_nl_nl,name_sv_se,sdsc_sv_se,ldsc_sv_se,name_en_za,sdsc_en_za,ldsc_en_za,available,available_date,unavailable_date,comp_en_au,comp_en_gb,comp_de_de,comp_es_es,comp_fr_fr,comp_it_it,comp_nl_nl,comp_sv_se,comp_en_za,timestamp,small_image,small_name,large_image,large_name,extra_image,extra_name,modifiers,type,template_name,background_color,text_color,link_color,active_link_color,visited_link_color,rule_color,background_image,header_image,show_title,use_defp_temp_name,use_defpback_color,use_defptext_color,use_defplink_color,use_defpact_lcolor,use_defprule_color,use_defpback_image,use_defphead_image,use_defpfoot_image,use_defp_header,use_defp_footer,operating_entity,city_code,rating,country_code,agent_cash_prin,allocation_start,cart_template,allocat| prdhdr2sum1119|16|31| SELECT id,name_en_au,ldsc_en_au,name_en_gb,sdsc_en_gb,ldsc_en_gb,name_de_de,sdsc_de_de,ldsc_de_de,name_es_es,sdsc_es_es,ldsc_es_es,name_fr_fr,sdsc_fr_fr,ldsc_fr_fr,name_it_it,sdsc_it_it,ldsc_it_it,name_nl_nl,sdsc_en_au,sdsc_nl_nl,ldsc_nl_nl,name_sv_se,sdsc_sv_se,ldsc_sv_se,name_en_za,sdsc_en_za,ldsc_en_za,available,available_date,unavailable_date,comp_en_au,comp_en_gb,comp_de_de,comp_es_es,comp_fr_fr,comp_it_it,comp_nl_nl,comp_sv_se,comp_en_za,timestamp,small_image,small_name,large_image,large_name,extra_image,extra_name,modifiers,type,template_name,background_color,text_color,link_color,active_link_color,visited_link_color,rule_color,background_image,header_image,show_title,use_defp_temp_name,use_defpback_color,use_defptext_color,use_defplink_color,use_defpact_lcolor,use_defprule_color,use_defpback_image,use_defphead_image,use_defpfoot_image,use_defp_header,use_defp_footer,operating_entity,city_code,rating,country_code,agent_cash_prin,allocation_start,cart_template,allocat| prdhdr2sum1119|17|35| SELECT commission_type,self_catering,price,max_adults,product_id,allocation_start,sku_id,pon_price,max_childs,inventory,description,fixed_stay,number_of_nights FROM lmn_hotel_sku_nfs WHERE allocation_start < today + 93 units day and allocation_start >= today|| prdhdr2sum1119|18|37| SELECT commission_type,self_catering,price,max_adults,product_id,allocation_start,sku_id,pon_price,max_childs,inventory,description,fixed_stay,number_of_nights FROM lmn_hotel_sku_nfs WHERE allocation_start < today + 93 units day and allocation_start >= today|| prdhdr2sum1119|19|39| SELECT commission_type,self_catering,price,max_adults,product_id,allocation_start,sku_id,pon_price,max_childs,inventory,description,fixed_stay,number_of_nights FROM lmn_hotel_sku_nfs WHERE allocation_start < today + 155 units day and allocation_start >= today|| prdhdr2sum1119|20|41| SELECT commission_type,self_catering,price,max_adults,product_id,allocation_start,sku_id,pon_price,max_childs,inventory,description,fixed_stay,number_of_nights FROM lmn_hotel_sku_nfs WHERE allocation_start < today + 93 units day and allocation_start >= today|| prdhdr2sum1119|21|43| SELECT commission_type,self_catering,price,max_adults,product_id,allocation_start,sku_id,pon_price,max_childs,inventory,description,fixed_stay,number_of_nights FROM lmn_hotel_sku_nfs WHERE allocation_start < today + 93 units day and allocation_start >= today|| prdhdr2sum1119|22|45| SELECT commission_type,self_catering,price,max_adults,product_id,allocation_start,sku_id,pon_price,max_childs,inventory,description,fixed_stay,number_of_nights FROM lmn_hotel_sku_nfs WHERE allocation_start < today + 155 units day and allocation_start >= today|| prdhdr2sum1119|23|47| SELECT product_id,allocation_start,commission_type,price,sku_id,pon_price,max_adults,max_childs,inventory,description,fixed_stay,number_of_nights,self_catering FROM lmn_hotel_sku_nfs WHERE allocation_start < today + 155 units day and allocation_start >= today|| preb1sum1119|1|1| SELECT lc.start_date AS allocation_start, lc.sku_key AS sku_id, lbk.cust_source_key AS user_id, lbk.order_date AS order_timestamp, lc.product_key AS productid, li.product_name AS product_name, lpb.payment_id AS order_number, bkg.item_id AS confirmed, bkg.timestamp AS confirmDate, lbk.cust_first_name AS first_name, lbk.cust_last_name AS last_name, li.item_id AS booking_id, lc.product_type AS type_id, lc.transaction_type AS Cancelled, lc.quantity AS Quantity, bkg.reservation_no AS reservation_no, '' AS BatchId, '' AS BatchTimeStamp, '' AS BatchTimeout, lc.cost_amount AS Price, 'FB' AS Basket FROM log_constituent lc, log_item li, log_bundle lb, log_basket lbk, log_payment_bundle lpb, log_payment lp, OUTER(log_bkgstatus bkg) WHERE lc.attached_to_table = 'log_item' AND li.item_id || preb1sum1119|2|66| SELECT name FROM sysdatabases WHERE name != 'sysmaster' AND name matches ? ORDER BY name|| preb1sum1119|3|67| SELECT request_id FROM log_ccard_trans WHERE batch_complete != 'T' AND status = 'S' AND creation_date >= ?|| preb1sum1119|4|68| select count| preb1sum1119|5|68|select li.item_id from log_item li, log_constituent lc, OUTER log_bkgstatus| preb1sum1119|6|70| select x0.client_store ,x0.channel_locale ,x0.partner_id ,x0.order_date ,x0.basket_id ,x1.payment_currency ,x1.basket_id ,x2.bundle_id ,x2.basket_id ,x3.pax ,x3.bundle_id from usp:"informix".log_basket x0 ,usp:"informix".log_payment x1 ,usp:"informix".log_bundle x2 ,usp:"informix".log_item x3 where ((x0.client_store IN ('F4L' ,'GPT' ,'lfe' ,'COF' ,'CPF' ,'CT1' )) AND (x0.order_date < DATE (? ) ) ) AND (x1.basket_id = x0.basket_id ) AND (x2.basket_id = x0.basket_id ) AND (x3.bundle_id = x2.bundle_id )|| preb1sum1119|7|72| select count| preb1sum1119|8|75| SELECT lc.start_date AS allocation_start, lc.sku_key AS sku_id, lo.cust_source_key AS user_id, lo.order_date AS order_timestamp, lc.product_key AS productid, li.product_name AS product_name, lo.order_id AS order_number, bkg.item_id AS confirmed, bkg.creation_date AS confirmDate, lo.cust_first_name AS first_name, lo.cust_last_name AS last_name, li.item_id AS booking_id, lc.product_type AS type_id, lc.transaction_type AS Cancelled, lc.quantity AS Quantity, bkg.reference_no AS reservation_no, '' AS BatchId, '' AS BatchTimeStamp, '' AS BatchTimeout, lc.cost_amount AS Price, 'EB' AS Basket FROM log_constituent lc, log_item li, log_bundle lb, log_order lo, log_payment_bundle lpb, log_payment lp, OUTER(log_bkgstatus bkg) WHERE lc.attached_to_table = 'log_item' AND li.item_id || preb1sum1119|9|140| select date(start_date)| preb1sum1119|10|150| select date(start_date)| preb1sum1119|11|159| select lct.app_server ,count| preb1sum1119|12|171| select x0.creation_date ,x0.start_date ,x0.supplier_name ,x0.segment_dep_point ,x0.segment_arv_point ,x0.attached_to_row ,x1.product_name ,x1.booked_for ,x1.supplier_reference ,x1.source_system ,x1.item_id ,x1.bundle_id ,x2.bundle_id ,x2.basket_id ,x3.payment_id ,x3.account_holder ,x3.basket_id from usp:"informix".log_constituent x0 ,usp:"informix".log_item x1 ,usp:"informix".log_bundle x2 ,usp:"informix".log_payment x3 where ((x0.creation_date >= datetime(2003-11-18 00:00:01) year to second ) AND (x0.segment_arv_point IN ('TUN' ,'CMN' ,'CAI' ,'DKR' ,'FNA' )) ) AND (x0.attached_to_row = x1.item_id ) AND (x2.bundle_id = x1.bundle_id ) AND (x2.basket_id = x3.basket_id )|| preb1sum1119|13|178| SELECT lc.start_date AS allocation_start, lc.sku_key AS sku_id, lbk.cust_source_key AS user_id, lbk.order_date AS order_timestamp, lc.product_key AS productid, li.product_name AS product_name, lpb.payment_id AS order_number, bkg.item_id AS confirmed, bkg.timestamp AS confirmDate, lbk.cust_first_name AS first_name, lbk.cust_last_name AS last_name, li.item_id AS booking_id, lc.product_type AS type_id, lc.transaction_type AS Cancelled, lc.quantity AS Quantity, bkg.reservation_no AS reservation_no, '' AS BatchId, '' AS BatchTimeStamp, '' AS BatchTimeout, lc.cost_amount AS Price, 'FB' AS Basket FROM log_constituent lc, log_item li, log_bundle lb, log_basket lbk, log_payment_bundle lpb, log_payment lp, OUTER(log_bkgstatus bkg) WHERE lc.attached_to_table = 'log_item' AND li.item_id || preb1sum1119|14|243| SELECT name FROM sysdatabases WHERE name != 'sysmaster' AND name matches ? ORDER BY name|| preb1sum1119|15|244| SELECT request_id FROM log_ccard_trans WHERE batch_complete != 'T' AND status = 'S' AND creation_date >= ?|| preb1sum1119|16|245| select count| preb1sum1119|17|245|select li.item_id from log_item li, log_constituent lc, OUTER log_bkgstatus| preb1sum1119|18|247| select x0.client_store ,x0.channel_locale ,x0.partner_id ,x0.order_date ,x0.basket_id ,x1.payment_currency ,x1.basket_id ,x2.bundle_id ,x2.basket_id ,x3.pax ,x3.bundle_id from usp:"informix".log_basket x0 ,usp:"informix".log_payment x1 ,usp:"informix".log_bundle x2 ,usp:"informix".log_item x3 where ((x0.client_store IN ('F4L' ,'GPT' ,'lfe' ,'COF' ,'CPF' ,'CT1' )) AND (x0.order_date < DATE (? ) ) ) AND (x1.basket_id = x0.basket_id ) AND (x2.basket_id = x0.basket_id ) AND (x3.bundle_id = x2.bundle_id )|| preb1sum1119|19|249| select count| preb1sum1119|20|252| SELECT lc.start_date AS allocation_start, lc.sku_key AS sku_id, lo.cust_source_key AS user_id, lo.order_date AS order_timestamp, lc.product_key AS productid, li.product_name AS product_name, lo.order_id AS order_number, bkg.item_id AS confirmed, bkg.creation_date AS confirmDate, lo.cust_first_name AS first_name, lo.cust_last_name AS last_name, li.item_id AS booking_id, lc.product_type AS type_id, lc.transaction_type AS Cancelled, lc.quantity AS Quantity, bkg.reference_no AS reservation_no, '' AS BatchId, '' AS BatchTimeStamp, '' AS BatchTimeout, lc.cost_amount AS Price, 'EB' AS Basket FROM log_constituent lc, log_item li, log_bundle lb, log_order lo, log_payment_bundle lpb, log_payment lp, OUTER(log_bkgstatus bkg) WHERE lc.attached_to_table = 'log_item' AND li.item_id || preb1sum1119|21|317| select x0.creation_date ,x0.start_date ,x0.supplier_name ,x0.segment_dep_point ,x0.segment_arv_point ,x0.attached_to_row ,x1.product_name ,x1.booked_for ,x1.supplier_reference ,x1.source_system ,x1.item_id ,x1.bundle_id ,x2.bundle_id ,x2.basket_id ,x3.payment_id ,x3.account_holder ,x3.basket_id from usp:"informix".log_constituent x0 ,usp:"informix".log_item x1 ,usp:"informix".log_bundle x2 ,usp:"informix".log_payment x3 where ((x0.creation_date >= datetime(2003-11-18 00:00:01) year to second ) AND (x0.segment_arv_point IN ('TUN' ,'CMN' ,'CAI' ,'DKR' ,'FNA' )) ) AND (x0.attached_to_row = x1.item_id ) AND (x2.bundle_id = x1.bundle_id ) AND (x2.basket_id = x3.basket_id )|| preb1sum1119|22|319| select lct.app_server ,count| preb1sum1119|23|331| select date(start_date)| preb1sum1119|24|341| select date(start_date)| preb2sum111903|1|1| SELECT dbsname, tabname, lockwts, deadlks, seqscans FROM sysptprof WHERE dbsname NOT IN ('sysmaster','HASHTEMP','SORTTEMP','sysutils','syscdr','onpload') AND TRIM(dbsname)|| preb2sum111903|2|4|SELECT TRIM(frag.dbsname)| preb2sum111903|3|16| select sysdbspaces.dbsnum, name| preb2sum111903|4|26| SELECT li.item_id, li.booked_for, lb.package_destination_country| preb2sum111903|5|30| SELECT dbsname, tabname, lockwts, deadlks, seqscans FROM sysptprof WHERE dbsname NOT IN ('sysmaster','HASHTEMP','SORTTEMP','sysutils','syscdr','onpload') AND TRIM(dbsname)|| preb2sum111903|6|33|SELECT TRIM(frag.dbsname)| preb2sum111903|7|45| select sysdbspaces.dbsnum, name| preb2sum111903|8|55| SELECT li.item_id, li.booked_for, lb.package_destination_country|