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 = 100 AND listing.cust_approved = 'y' order by listing_date desc limit 0,30
Array
(
    [0] => Array
        (
            [listing_id] => 487
            [title] => Freestuff.co.nz - Sales & Marketing manager.- please contact
            [region_name] => Taranaki
            [area_name] => New Plymouth
            [listed] => 3 Sep,2010
            [expires] => 17/09/2010
            [list_img] => cr_data/cache/listing/487/pic_1/freestuffmansmalljpeg_150_125_75.jpg
            [gallery_img] => cr_data/cache/listing/487/pic_1/freestuffmansmalljpeg_250_250_75.jpg
            [description] => At Freestuff.co.nz we are seeking someone with the X-Factor to join our tea. . .
            [url] => Freestuff.co.nz - Sales & Marketing manager.-it487
        )

    [1] => Array
        (
            [listing_id] => 531
            [title] => Easy Data Entry Job From Home!- please contact
            [region_name] => Auckland
            [area_name] => North Shore
            [listed] => 26 Aug,2010
            [expires] => 09/09/2010
            [list_img] => cr_data/cache/listing/531/pic_1/AdPic_150_125_75.gif
            [gallery_img] => cr_data/cache/listing/531/pic_1/AdPic_250_250_75.gif
            [description] => DataJobEntry.com provide complete list of paid survey companies, data entry. . .
            [url] => Easy Data Entry Job From Home!-it531
        )

)
Freestuff.co.nz | Free kiwi classifieds.
 
Home > Jobs

Marketing & PR

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