Free shipping for orders over $40
 |
|
| Toll Free: (877) 442-7280 Phone (318) 443-7280 |
|
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 15 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 15 day) group by PROD.id order ' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 15 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 15 day) group by PROD.id order ' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 25 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 25 day) group by PROD.id order ' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 25 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 25 day) group by PROD.id order ' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 35 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 35 day) group by PROD.id order ' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 35 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 35 day) group by PROD.id order ' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 45 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 45 day) group by PROD.id order ' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 45 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 45 day) group by PROD.id order ' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 55 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 55 day) group by PROD.id order ' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 55 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 55 day) group by PROD.id order ' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 65 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 65 day) group by PROD.id order ' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 65 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 65 day) group by PROD.id order ' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 75 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 75 day) group by PROD.id order ' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 75 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 75 day) group by PROD.id order ' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 85 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 85 day) group by PROD.id order ' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 85 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 85 day) group by PROD.id order ' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 95 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 95 day) group by PROD.id order ' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 95 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 95 day) group by PROD.id order ' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 105 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 105 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 105 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 105 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 115 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0001
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 115 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 115 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0001
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 115 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 125 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 125 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 125 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 125 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 135 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0001
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 135 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 135 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0001
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 135 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 145 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 145 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 145 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 145 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 155 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 155 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 155 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 155 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 165 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 165 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 165 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 165 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 175 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 175 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 175 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 175 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 185 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 185 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 185 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 185 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 195 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 195 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 195 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 195 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 205 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 205 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 205 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 205 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 215 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 215 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 215 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 215 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 225 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 225 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 225 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 225 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 235 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 235 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 235 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 235 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 245 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 245 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 245 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 245 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 255 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 255 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 255 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 255 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 265 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 265 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 265 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 265 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 275 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 275 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 275 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 275 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 285 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 285 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 285 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 285 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 295 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 295 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 295 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 295 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 305 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 305 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 305 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 305 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 315 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 315 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 315 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 315 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 325 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 325 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 325 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 325 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 335 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 335 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 335 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 335 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 345 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 345 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 345 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 345 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 355 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 355 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 355 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 355 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 365 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 365 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 365 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 365 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 375 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 375 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 375 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 375 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 385 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 385 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 385 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 385 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 395 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 395 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 395 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 395 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 405 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 405 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 405 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 405 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 415 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 415 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 415 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 415 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 425 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 425 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 425 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 425 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 435 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 435 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 435 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 435 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 445 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 445 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 445 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 445 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 455 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 455 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 455 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 455 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 465 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 465 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 465 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 465 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 475 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 475 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 475 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 475 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 485 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 485 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 485 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 485 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 495 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 495 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 495 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 495 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 505 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 505 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 505 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 505 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 515 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 515 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 515 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 515 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 525 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 525 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 525 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 525 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 535 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 535 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 535 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 535 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 545 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 545 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 545 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 545 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 555 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 555 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 555 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 555 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 565 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 565 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 565 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 565 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 575 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 575 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 575 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 575 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 585 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 585 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 585 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 585 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 595 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 595 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 595 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 595 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 605 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 605 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 605 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 605 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 615 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 615 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 615 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 615 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 625 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 625 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 625 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 625 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 635 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 635 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 635 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 635 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 645 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 645 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 645 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 645 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 655 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 655 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 655 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 655 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 665 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 665 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 665 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 665 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 675 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 675 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 675 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 675 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 685 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 685 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 685 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 685 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 695 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 695 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 695 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 695 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 705 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 705 day) group by PROD.id order' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.live_date>DATE_SUB(CURDATE(), interval 705 day) group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 143
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.live_date>DATE_SUB(CURDATE(), interval 705 day) group by PROD.id order' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 12
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 223
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 12' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 12
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 223
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 12' at line 6
SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.gift_orders>50 group by PROD.id order by is_instock DESC, (PT.gift_orders/PT.orders) DESC, sales_per_day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 246
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.gift_orders>50 group by PROD.id order by is_instock DESC, (PT.gift_or' at line 6
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () AND PT.gift_orders>50 group by PROD.id order by is_instock DESC, (PT.gift_orders/PT.orders) DESC, sales_per_day DESC limit 8
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 246
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PT.gift_orders>50 group by PROD.id order by is_instock DESC, (PT.gift_or' at line 6
| Contact Us About Us Customer Service Links Sitemap Testimonials Spirit Bracelet & Tags |
|
Copyright ©2014
BracelestForAmerica.com
Powered by Island Technologies
|