rrrrr FROM nuke_cp_carto LEFT JOIN nuke_geo_city ON nuke_geo_city.cityid = nuke_cp_carto.cartocityid WHERE cartoid = nuke_obj_index.indexobjkey01 AND nuke_obj_index.indexobjdefid=13 AND indexinfoobjdefid=32 AND (nuke_obj_index.indexinfoobjkey01 = '10' )