my $show = q{AND ((planet_status IS NULL OR NOT planet_status IN ('Friendly','NAP')) AND (relationship IS NULL OR NOT relationship IN ('Friendly','NAP')))};
$show = '' if defined param('show') && param('show') eq 'all';
my $show = q{AND ((planet_status IS NULL OR NOT planet_status IN ('Friendly','NAP')) AND (relationship IS NULL OR NOT relationship IN ('Friendly','NAP')))};
$show = '' if defined param('show') && param('show') eq 'all';
FROM covop_targets c JOIN current_planet_stats p ON p.id = c.planet
LEFT OUTER JOIN users u ON u.uid = c.covop_by) AS foo
$where});
FROM covop_targets c JOIN current_planet_stats p ON p.id = c.planet
LEFT OUTER JOIN users u ON u.uid = c.covop_by) AS foo
$where});