area:[226]hgteB:[]
AML-listcode:[adopt-area]clist-sortby1:[moborder]sqlb:[select * from ((select listitems.id as li_liid, listitems.list as li_list, pages.page_id as li_pageid, @li_catid:=0 AS li_catid, pages.s_image_src, pages.imageslot_1, pages.page_name as li_name, pages.date1, pages.textline1, pages.textarea_1, pages.textarea_2, pages.textarea_3, pages.textarea_4, pages.textarea_5,pages.usebannerimgfrompos,pages.usemenunavimgfrompos,pages.useiconimgfrompos, @xsmenuorder:=0 AS xsmenuorder,pages.plaintext1,pages.mobimgpos,pages.listimgpos,pages.bannerimgpos,listitems.listorder from listitems, pages where (listitems.page = pages.page_id) AND (listitems.list='8') AND (pages.page_status='yes') )UNION (select listitems.id as li_liid, listitems.list as li_list, @li_pageid:=0 AS li_pageid, nested_tree.id as li_catid, nested_tree.s_image_src, nested_tree.extcat, nested_tree.title as li_name, nested_tree.parent_id, nested_tree.extcat,nested_tree.extcat,nested_tree.extcat,nested_tree.extcat,nested_tree.extcat,nested_tree.extcat,nested_tree.extcat,@mobimgpos:=0 AS mobimgpos,@mobimgpos:=0 AS mobimgpos, @xsmenuorder:=0 AS xsmenuorder,@usebannerimgfrompos:=0 AS usebannerimgfrompos,@usemenunavimgfrompos:=0 AS usemenunavimgfrompos,@useiconimgfrompos:=0 AS useiconimgfrompos,nested_tree.extcat,listitems.listorder from listitems, nested_tree where (listitems.cat = nested_tree.id) AND (listitems.list='8') AND (nested_tree.cat_displaystatus='enabled') )) x ORDER BY x.xsmenuorder ASC limit 100;;]