$query = "select main.id as aid,main.*,main.description as description1, type.* 

    from $maintable main

    left join dede_arctype type on type.id=main.typeid

    left join $addontable addon on addon.aid=main.id

    $where  $orderby";

$query = "select main.id as aid,main.*,main.description as description1, type.* ,addon.* 

    from $maintable main

    left join dede_arctype type on type.id=main.typeid

    left join $addontable addon on addon.aid=main.id

    $where  $orderby";