select SQL_CALC_FOUND_ROWS listing.*,region.region_name,area.area_name,c.category_name,p.category_parent_name,p.category_parent_id,listing.cost_type, listing.price from listing join region on region.region_id = listing.region_id JOIN area on area.area_id=listing.area_id JOIN category c ON listing.category_id = c.category_id JOIN category_parent p ON c.category_parent_id = p.category_parent_id WHERE listing.active = 'y' and authorised in ('y','p') and expires >= '2010/09/05' AND listing.category_id = 1 AND listing.cust_approved = 'y' order by listing_date desc limit 0,30
Array
(
    [0] => Array
        (
            [listing_id] => 530
            [title] => girls clothes size 1 and 2- Wanted
            [region_name] => Northland
            [area_name] => Whangarei
            [listed] => 26 Aug,2010
            [expires] => 09/09/2010
            [list_img] => cr_data/cache/image_not_found_150_125_75.jpg
            [gallery_img] => cr_data/cache/image_not_found_250_250_75.jpg
            [description] => little girls clothes wanted!! size 1 and 2. . .
            [url] => girls clothes size 1 and 2-it530
        )

    [1] => Array
        (
            [listing_id] => 529
            [title] => girls clothes newborn>1year - $3.00
            [region_name] => Northland
            [area_name] => Whangarei
            [listed] => 26 Aug,2010
            [expires] => 09/09/2010
            [list_img] => cr_data/cache/image_not_found_150_125_75.jpg
            [gallery_img] => cr_data/cache/image_not_found_250_250_75.jpg
            [description] => excellent condition pumpkin patch and more!. . .
            [url] => girls clothes newborn>1year-it529
        )

)
Freestuff.co.nz | Free kiwi classifieds.
 
Home > For Sale

Baby stuff

Order by:    
Displaying: 1 - 2 of 2 items      
Displaying: 1 - 2 of 2 itemsPage No: 1