|
select p.products_id, pd.products_name, p.products_image, p.products_related_code, p.manufacturers_id, p.products_special_text, p.products_price, p.products_color,p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_coming_soon_status, p.address_key, p.products_new_in_start, p.products_hot_item_start, p.products_bestseller_start, p.products_new_in, p.products_hot_item, p.products_bestseller, p.products_related_tag, p.pwp_group_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_free_gift_status = '0' and p.products_third_party_status = '0' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '184' and (p.products_date_available < now() or p.products_date_available IS NULL) and p.products_website like '%privatestructure%' and p.products_website_status = '1' order by p.products_new desc, p.products_date_added desc, pd.products_name
$(function() {
$('#close_filter').click(function() {
$('.top_filter_panel').fadeOut('slow');
$('.overlay_blur').fadeOut('slow');
$("#action_show_filter").fadeIn('fast');
});
$('.overlay_blur').click(function() {
$('.top_filter_panel').fadeOut('slow');
$('.overlay_blur').fadeOut('slow');
});
$("#action_show_filter").click(function() {
$('.top_filter_panel').fadeIn('fast');
$('.overlay_blur').fadeIn('fast');
});
});
|
![Swimwear Bikini - Charcoal Black [4584]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWSS4584-Charcoal-black_001_20240610162808.jpg&w=340&zc=1 "Swimwear Bikini - Charcoal Black [4584]")
![Swimwear Bikini - Cloud White [4584]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWSS4584-Cloud-White_001_20240610162904.jpg&w=340&zc=1 "Swimwear Bikini - Cloud White [4584]")
![Swimwear Bikini - Holographic Silver [4564]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWSS4564-Holographic-Silver_001_20240610162224.jpg&w=340&zc=1 "Swimwear Bikini - Holographic Silver [4564]")
![Swimwear Bikini - Illusive Red [4564]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWSS4564-Illusive-Red_001_20240610162320.jpg&w=340&zc=1 "Swimwear Bikini - Illusive Red [4564]")
![Swimwear Bikini - Neon Lemon [4584]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWSS4584-Neon-Lemon_001_20240610163516.jpg&w=340&zc=1 "Swimwear Bikini - Neon Lemon [4584]")
![Swimwear Bikini - Scale Blue [4564]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWSS4564-Scale-Blue_001_20240610162415.jpg&w=340&zc=1 "Swimwear Bikini - Scale Blue [4564]")
![Swimwear Hipster - Sand Grey [4585]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWSS4585-Sand-Grey_001_20240610163654.jpg&w=340&zc=1 "Swimwear Hipster - Sand Grey [4585]")
![Swimwear Hipster - Wave White [4585]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWSS4585-Wave-White_001_20240610163756.jpg&w=340&zc=1 "Swimwear Hipster - Wave White [4585]")
![Swimwear Bikini - Black [4587]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/SWSS4587-Black_001_20240416173929.jpg&w=340&zc=1 "Swimwear Bikini - Black [4587]")
![Swimwear Bikini - Pink [4587]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/SWSS4587-Pink_001_20240416174052.jpg&w=340&zc=1 "Swimwear Bikini - Pink [4587]")
![Swimwear Bikini - Seafoam Green [4588]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/SWSS4588-Seafoam-Green_001_20240424161355.jpg&w=340&zc=1 "Swimwear Bikini - Seafoam Green [4588]")
![Swimwear Bikini - Sunglow Pink [4588]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/SWSS4588-Sunglow-Pink_001_20240416174324.jpg&w=340&zc=1 "Swimwear Bikini - Sunglow Pink [4588]")
![Swimwear Bikini - White [4587]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/SWSS4587-White_001_20240424161049.jpg&w=340&zc=1 "Swimwear Bikini - White [4587]")
![Swimwear Basic Brazilian Trunk - Black [4653]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWST4452-Black_001_20230727141337.jpg&w=340&zc=1 "Swimwear Basic Brazilian Trunk - Black [4653]")
![Swimwear Basic Brazilian Trunk - Neon Yellow [4653]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWST4452-Neon-Yellow_001_20230727141501.jpg&w=340&zc=1 "Swimwear Basic Brazilian Trunk - Neon Yellow [4653]")
![Swimwear Basic Buckle up Bikini-Neon Green [4450]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWST4450-Neon-Green_001_20230328143125.jpg&w=340&zc=1 "Swimwear Basic Buckle up Bikini-Neon Green [4450]")
![Swimwear Islander Fish Skin Swim Brief-Black [4455]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWST4455-Steel-Grey_001_20230704140039.jpg&w=340&zc=1 "Swimwear Islander Fish Skin Swim Brief-Black [4455]")
![Swimwear Islander Whale Skin Swim Shorts-Black [4454]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWST4454-Black_001_20230328144120.jpg&w=340&zc=1 "Swimwear Islander Whale Skin Swim Shorts-Black [4454]")
![Swimwear Sport Retro Swim Brief-Navy Stripes [4460]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/BWST4460-Navy-Stripes_005_20230814143251.jpg&w=340&zc=1 "Swimwear Sport Retro Swim Brief-Navy Stripes [4460]")
![BeFit Swim Jammer-Navy [3403]](scripts/timthumb.php?src=https://www.privatestructure.com//site_media/img/99MS3403_Navy_001_20230328160041.jpg&w=340&zc=1 "BeFit Swim Jammer-Navy [3403]")
