Try wrapping your SQL in DB::Raw():
$asins = DB::select(DB::raw('SELECT `AmazonASIN`.`sku` , `AmazonASIN`.`asin` ,
`AmazonASIN`.`price` , `AmazonASIN`.`qty` , `AmazonASIN`.`added`
FROM `AmazonASIN`
LEFT JOIN `AmazonProducts` ON `AmazonASIN`.`sku` = `AmazonProducts`.`AmazonSKU`
WHERE `AmazonProducts`.`AmazonSKU` IS NULL
ORDER BY `AmazonASIN`.`added` DESC LIMIT 50000'));
without the DB::Raw(), you're "WHERE IS NULL" MIGHT be creating the problem, I'm not entirely sure though.
hi there am new here and am facing the same problem and i have tried DB::raw with no impact i know this post is old but i hope someone can help me
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community