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') )) C ORDER BY C.listorder ASC LIMIT 100;;]
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') )) C ORDER BY C.listorder ASC LIMIT 100;;]
Marley
SKU:section-Dogs-title-Marley-i-4866
$1.00Availability:In Stock CPBX_addtocartbutton
Marley was surrendered because she chased horses and cows. She is great with all other animals and people. She has a lovely temperament willing to learn smart and affectionate. She gets on well with other dogs the kelpie in her wants her to herd others animals. She is great with school age kids. She is affectionate active smart with a sweet nature. She is desexed microchipped immunised and treated for all the local worms and parasites.
CPBX_pagecontentfooter1_CPBE