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;;]
Mariah
SKU:section-Dogs-title-Mariah-i-3858
$1.00Availability:In Stock CPBX_addtocartbutton
Marg came to us very sick and with a litter of pups who are now old enough to be adopted. When they arrived they went straight to the vet and onto drips to flush the poison out of their systems. The girls Margarite Mariah Mariana and Maribeth are very healthy mischievous pups ready for new homes now. Marlon has had a leg operation his leg is out of the cast and he is having special remedial treatments to get his muscle tone back in his leg. He plays like a normal pup. They all have a lovely natures typical of a ridgeback cross. Dad we think was smaller than mother as they are fine boned and smaller feet. They are beautiful affectionate playful sweet natured pups fine with people and other dogs. They are now ready to go to puppy pre-school and then onto obedience training. They have been desexed vaccinated microchipped and regularly wormed ready for her their special new home.
CPBX_pagecontentfooter1_CPBE
