<a href="<?php the_permalink(); ?>" class="woocommerce button yellow dark cart">
<?php if( $_product->get_price_html() ) {
woocommerce_template_loop_price();
} else {
echo __('See this item', 'colabsthemes');
} ?>
</a>

<?php
if($plugin=='wpsc'){
$featured = get_option('sticky_products');
$arg = array(
'post__in' => $featured,
'post_type' => $colabs_posttype,
'posts_per_page' => 9,
'paged' => 1
);
}else if($plugin=='jigoshop'){

$arg = array(
                    'post_type' => $colabs_posttype,
'meta_key' => 'featured',
'meta_value' => '1'
                );

}else if($plugin=='woo'){
$arg = array(
                    'post_type' => $colabs_posttype,
'meta_key' => '_featured',
'meta_value' => 'yes'
                );
}else {
$arg = array(
                    'post_type' => $colabs_posttype,
                    'posts_per_page' => 9,
                    'paged' => 1
                );
}
query_posts($arg);
if ( have_posts() ):
?>
<div class="featured section row">
<h2 class="section-title"><?php echo get_option('colabs_title_featuredbooks');?></h2>
<div class="row">

<?php
$counter = 1;
$i=1;
while ( have_posts() ) : the_post();
if($counter==1){$classname='alpha';}
else if ($counter==3){$counter=0;}
else {$classname='';}
?>
<div class="item column col4 <?php echo $classname;?>">
<div id="imagecol_<?php echo $post->ID;?>" class="item-image column col5">
<?php colabs_image('width=120&height=184');?>
</div>
<div class="item-desc column col7">
<h3><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></h3>
<?php colabs_product_excerpt(); ?>
<div class="item-meta"><?php echo get_the_term_list( $post->ID, $colabs_taxonomy, ' ', ', ', '' );?></div>
<?php if($plugin=='wpsc'){?>
<?php if(wpsc_product_external_link(wpsc_the_product_id()) != '') : ?>
<?php $action =  wpsc_product_external_link(wpsc_the_product_id()); ?>
<?php else: ?>
<?php $action = htmlentities(wpsc_this_page_url(), ENT_QUOTES, 'UTF-8' );?>
<?php endif; ?>
<form class="product_form"  enctype="multipart/form-data" action="<?php echo $action; ?>" method="post" name="product_<?php echo wpsc_the_product_id(); ?>" id="product_<?php echo wpsc_the_product_id(); ?>" >
<?php do_action ( 'wpsc_product_form_fields_begin' ); ?>
<input type="hidden" value="add_to_cart" name="wpsc_ajax_action"/>
<input type="hidden" value="<?php echo wpsc_the_product_id(); ?>" name="product_id"/>
<?php if((get_option('hide_addtocart_button') == 0) &&  (get_option('addtocart_or_buynow') !='1')) : ?>
<?php if(wpsc_product_has_stock()) : ?>
<div class="wpsc_buy_button_container">

<?php if(wpsc_product_external_link(wpsc_the_product_id()) != '') : ?>
<?php $action = wpsc_product_external_link( wpsc_the_product_id() ); ?>
<input class="wpsc_buy_button" type="submit" value="<?php echo wpsc_product_external_link_text( wpsc_the_product_id(), __( 'Buy Now', 'colabsthemes' ) ); ?>" onclick="return gotoexternallink('<?php echo $action; ?>', '<?php echo wpsc_product_external_link_target( wpsc_the_product_id() ); ?>')">
<?php else: ?>
<input type="submit" value="<?php echo wpsc_the_product_price(); ?>" name="Buy" class="wpsc_buy_button button yellow cart dark" id="product_<?php echo wpsc_the_product_id(); ?>_submit_button"/>
<?php endif; ?>
<div class="wpsc_loading_animation">
<img title="Loading" alt="Loading" src="<?php echo wpsc_loading_animation_url(); ?>" />
<?php _e('Updating cart...', 'colabsthemes'); ?>
</div><!--close wpsc_loading_animation-->
</div><!--close wpsc_buy_button_container-->
<?php endif ; ?>
<?php endif ; ?>

<?php do_action ( 'wpsc_product_form_fields_end' ); ?>
</form>
<?php }else if($plugin=='jigoshop'){?>
<?php global $_product; $_product = new jigoshop_product( $post->ID );?>
<a href="<?php echo $_product->add_to_cart_url(); ?>" class="jigoshop button yellow dark cart"><?php echo $_product->get_price_html(); ?></a>
<?php }else if($plugin=='woo'){?>

<?php
global $_product;

// Fallback for WooCoomerce 1.5.x
if( class_exists( 'woocommerce_product' ) ) {
$_product = new woocommerce_product( $post->ID );
}

// For WooCommerce 2.x
else {
$_product = get_product( $post->ID );
}
?>

<a href="<?php the_permalink(); ?>" class="woocommerce button yellow dark cart">
<?php if( $_product->get_price_html() ) {
woocommerce_template_loop_price();
} else {
echo __('See this item', 'colabsthemes');
} ?>
</a>

<?php }?>
</div>
</div>
<?php $counter++; endwhile; ?>
</div>

<div class="pagination fr">
<?php if(function_exists('wpsc_pagination'))wpsc_pagination();?>

</div><!-- .pagination -->
</div><!-- .featured -->
<?php endif;?>

<?php
global $wpdb;
$best_limit= get_option('colabs_best_limit');
if($best_limit=='')$best_limit=6;
if($plugin=='wpsc'){
$sql = "SELECT DISTINCT prodid, name, count(prodid) as prodnum from " . $wpdb->prefix. "wpsc_cart_contents group by prodid order by prodnum desc LIMIT ".$best_limit;
}else if($plugin=='jigoshop'){
$sql = "SELECT $wpdb->posts.ID AS prodid
FROM $wpdb->posts, $wpdb->postmeta
WHERE
$wpdb->postmeta.post_id=$wpdb->posts.ID AND
$wpdb->postmeta.meta_key = '_js_total_sales' AND
$wpdb->posts.post_status = 'publish' AND
$wpdb->posts.post_type = 'product' ORDER BY $wpdb->postmeta.meta_value LIMIT ".$best_limit;
}else if($plugin=='woo'){
$sql = "SELECT $wpdb->posts.ID AS prodid
FROM $wpdb->posts, $wpdb->postmeta
WHERE
$wpdb->postmeta.post_id=$wpdb->posts.ID AND
$wpdb->postmeta.meta_key = 'total_sales' AND
$wpdb->posts.post_status = 'publish' AND
$wpdb->posts.post_type = 'product' ORDER BY $wpdb->postmeta.meta_value LIMIT ".$best_limit;

}

$bests = $wpdb->get_results($sql);
if($bests){
$counter = 1;
$i=1;
?>
<div class="best-items row section">
<h2 class="section-title"><?php echo get_option('colabs_title_bestseller');?></h2>
<div class="row">
<?php
foreach($bests as $best) {
if($counter==1){$classname='alpha';}
else if ($counter==3){$counter=0;}
else {$classname='';}
$prod_id=$best->prodid;
?>
<div class="column one-third <?php echo $classname; ?>">

<?php
if( colabs_image('return=true&link=img&width=326&height=220&id='.$prod_id) ) {
colabs_image('link=img&width=326&height=220&id='.$prod_id);
} else {
echo '<img src="http://cambelt.co/326x220/Product+Image?font=Cabin-Bold">';
}
?>

<div class="item-desc">
<div class="item-meta">
<h3>

<a href="<?php echo get_permalink($prod_id);?>">
<?php echo get_the_title($prod_id);?>
</a>
</h3>
<p><span><?php echo get_the_term_list( $prod_id, $colabs_taxonomy, ' ', ', ', '' );?></span></p>
</div>
</div>
</div>
<?php $counter++; }?>

</div>

<div class="pagination fr">
<?php if(function_exists('wpsc_pagination'))wpsc_pagination();?>
</div><!-- .pagination -->
</div><!-- .best-items -->
<?php }?>

<?php
global $wpdb;
$best_limit= get_option('colabs_best_limit');
if($best_limit=='')$best_limit=6;
if($plugin=='wpsc'){
$sql = "SELECT DISTINCT prodid, name, count(prodid) as prodnum from " . $wpdb->prefix. "wpsc_cart_contents group by prodid order by prodnum desc LIMIT ".$best_limit;
}else if($plugin=='jigoshop'){
$sql = "SELECT $wpdb->posts.ID AS prodid
FROM $wpdb->posts, $wpdb->postmeta
WHERE
$wpdb->postmeta.post_id=$wpdb->posts.ID AND
$wpdb->postmeta.meta_key = '_js_total_sales' AND
$wpdb->posts.post_status = 'publish' AND
$wpdb->posts.post_type = 'product' ORDER BY $wpdb->postmeta.meta_value LIMIT ".$best_limit;
}else if($plugin=='woo'){
$sql = "SELECT $wpdb->posts.ID AS prodid
FROM $wpdb->posts, $wpdb->postmeta
WHERE
$wpdb->postmeta.post_id=$wpdb->posts.ID AND
$wpdb->postmeta.meta_key = 'total_sales' AND
$wpdb->posts.post_status = 'publish' AND
$wpdb->posts.post_type = 'product' ORDER BY $wpdb->postmeta.meta_value LIMIT ".$best_limit;

}

$bests = $wpdb->get_results($sql);
if($bests){
$counter = 1;
$i=1;
?>
<div class="best-items row section">
<h2 class="section-title"><?php echo get_option('colabs_title_bestseller');?></h2>
<div class="row">
<?php
foreach($bests as $best) {
if($counter==1){$classname='alpha';}
else if ($counter==3){$counter=0;}
else {$classname='';}
$prod_id=$best->prodid;
?>
<div class="column one-third <?php echo $classname; ?>">

<?php
if( colabs_image('return=true&link=img&width=326&height=220&id='.$prod_id) ) {
colabs_image('link=img&width=326&height=220&id='.$prod_id);
} else {
echo '<img src="http://cambelt.co/326x220/Product+Image?font=Cabin-Bold">';
}
?>

<div class="item-desc">
<div class="item-meta">

<h3>

<?php
global $_product;

// Fallback for WooCoomerce 1.5.x
if( class_exists( 'woocommerce_product' ) ) {
$_product = new woocommerce_product( $post->ID );
}

// For WooCommerce 2.x
else {
$_product = get_product( $post->ID );
}
?>

<a href="<?php the_permalink(); ?>" class="woocommerce button yellow dark cart">
<?php if( $_product->get_price_html() ) {
woocommerce_template_loop_price();
} else {
echo __('See this item', 'colabsthemes');
} ?>
</a>

<?php }?>

<a href="<?php echo get_permalink($prod_id);?>">
<?php echo get_the_title($prod_id);?>
</a>
</h3>
<p><span><?php echo get_the_term_list( $prod_id, $colabs_taxonomy, ' ', ', ', '' );?></span></p>
</div>
</div>
</div>
<?php $counter++; }?>

</div>

<div class="pagination fr">
<?php if(function_exists('wpsc_pagination'))wpsc_pagination();?>
</div><!-- .pagination -->
</div><!-- .best-items -->
<?php }?>