my $rs = $schema->resultset('Addons')->search( { join => 'gb_invoices', }, ); [download]
SELECT * FROM addons LEFT JOIN gb_invoices ON gb_invoices.cp_id = addons.addon_id [download]