SQL/DB Error -- [Column 'link' in where clause is ambiguous][SELECT prods.prodid, prods.code, prods.availability, FROM_UNIXTIME(prods.available_from, "%d.%m.%Y") as available_from, `prods`.`title`, `prods`.`shortinfo`, `prods`.`perex`, `prods`.`code`, `prods`.`flag`, `prods`.`link`, `prods`.`catid`, `prods`.`price`, `prods`.`manid`, `prods`.`altcatids`, `prods`.`self_log`, man.title as manufacture, man.public as man_public, prods.status FROM toy_prods AS prods LEFT JOIN manufacturer as man ON man.manufacturer_id = prods.manid LEFT JOIN product_web AS pw ON prods.prodid = pw.product_id WHERE link = 'cerny-mravenec' AND price != '0' AND pw.web_id='GMCZ' AND (catid = 67 OR (altcatids LIKE '%:67:%' OR catid = 67 OR altcatids LIKE '%:67:%' OR catid = 67)) AND NOT (master_prodid IS NULL AND variants IS NOT NULL) AND NOT (status IN (6,7) AND sort_storage = 0) AND flag != 0 AND `status` IN (0,6) ORDER BY prodid ASC LIMIT 0, 30]
Pokud objednáte Českou poštou do 14:00 a zboží máme skladem, tak objednávku obdržíte následující pracovní den
