INVALID SQL: 1064 : 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 'onclick=sa_mpTC(event, this)' at line 1 SQL QUERY FAILURE: SELECT * FROM yb_products WHERE productid=3805 onclick=sa_mpTC(event, this) INVALID SQL: 1064 : 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 p.forsale = 'Y'
AND p.avail > 0
ORDER BY pc.price,' at line 8 SQL QUERY FAILURE:
SELECT p.productid, p.product, p.list_price, pc.price,
(SELECT MIN(image_path) FROM xcart_images i WHERE p.productid = i.productid AND image_type LIKE 'audio%') audio_sample_path,
CAST(product AS UNSIGNED INTEGER) product_number
FROM xcart_products p
INNER JOIN yb_products yp USING (productid)
INNER JOIN xcart_pricing pc USING (productid)
WHERE yp.parent_productid =
AND p.forsale = 'Y'
AND p.avail > 0
ORDER BY pc.price, product_number, p.product;
INVALID SQL: 1064 : 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 'onclick=sa_mpTC(event, this)
ORDER BY a.title' at line 4 SQL QUERY FAILURE:
SELECT a.title, COALESCE(a.link_url, '') link_url
FROM yb_article a
INNER JOIN xcart_products p ON a.sku = p.productcode
WHERE p.productid = 3805 onclick=sa_mpTC(event, this)
ORDER BY a.title;
INVALID SQL: 1064 : 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 'onclick=sa_mpTC(event, this)' at line 13 SQL QUERY FAILURE:
SELECT m.nts_block, m.nts_sheet, m.nts_map, m.nts_compass,
m.lat_n, m.lat_s, m.lon_w, m.lon_e,
m.edition, m.map_title, m.year_valid, m.year_printed, m.contour_interval,
m.datum, m.utm_zone, m.accuracy_horizontal, m.accuracy_vertical, m.notes,
r.region_name,
sc.map_scale_name, st.map_style_name
FROM yb_map_product AS mp
INNER JOIN yb_map AS m USING (map_id)
INNER JOIN yb_region AS r USING (region_id)
INNER JOIN yb_product_ref_type AS prt ON mp.product_ref_type_id = prt.product_ref_type_id AND prt.product_ref_type_handle = 'PAPER'
LEFT JOIN yb_map_scale AS sc ON m.map_scale_id = sc.map_scale_id
LEFT JOIN yb_map_style AS st ON m.map_style_id = st.map_style_id
WHERE mp.productid = 3805 onclick=sa_mpTC(event, this);
INVALID SQL: 1064 : 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 'onclick=sa_mpTC(event, this)
AND yp.parent_productid IS NULL' at line 8 SQL QUERY FAILURE:
SELECT productid
FROM xcart_products
INNER JOIN yb_products AS yp USING (productid)
WHERE forsale = 'Y'
AND avail > 0
AND categoryid = 69
AND categoryid != 13
AND productid != 3805 onclick=sa_mpTC(event, this)
AND yp.parent_productid IS NULL;
Yukon Books - Bar Room Ballads