solved cri mysql error in shops...only when logged out

{debug}

debug entry 	
Key 	Value
Message 	Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY RAND() LIMIT 1000000' at line 3
Date 	10/16/16 02:23:05PM
IP Address 	54.175.227.92
URL 	/shops
Memory 	21.5MB
Data 	
Array
(
    [error] => Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY RAND() LIMIT 1000000' at line 3
    [_post] => Array
        (
            [_uri] => /shops
            [module_url] => shops
            [module] => 
        )

    [query] => SELECT a.`_item_id` AS _item_id FROM jr_jrfoxycartbundle_item_key a
JOIN jr_jrfoxycartbundle_item_key pr ON (pr.`_item_id` = a.`_item_id` AND pr.`key` = '_profile_id' AND pr.`value` NOT IN(1081, 1414, 2312, 2336, 2419, 2699, 2803, 3091, 3959, 5172, 5225, 6523, 6743, 7802, 7845, 8238, 8343, 8664, 8820, 9233, 9667, 9751, 9865, 10202, 10860, 10922, 11183, 11529, 11848, 12128, 12488, 13167, 13483, 13589, 13779, 13858, 13861, 13879, 13885, 13930, 13942, 13973, 13979, 13980, 14027, 14094, 14114, 14146, 14152, 14161, 14202, 14240, 14251, 14275, 14372, 14377, 14392, 14524, 14579, 212, 354, 12446, 14384, 14414, 14609, 14618, 14621, 14630, 14635, 14640))
WHERE ORDER BY RAND() LIMIT 1000000 
)

WHERE ORDER B........

WHERE 1 ORDER B........

{jrSeamless_list modules="jrFoxyCartBundle,jrStore" limit="8" order_by="product_qty random" }