SELECT * 
			FROM `oc_product` p
			LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
			LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
			LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id)
			LEFT JOIN `oc_category` c ON (c.category_id = p2c.category_id) 
			LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
			WHERE 
				c.category_id IN (80) 
				AND p.status = '1'
				AND p.date_available <= NOW()
				AND pd.language_id = '2'
				AND p2s.store_id = '0'
				AND c.status = '1'
				AND c2s.store_id = '0'
				AND p.product_id != '11087'
		<pre>Array
(
    [689] => Array
        (
            [product_id] => 689
            [name] => All Balls, Bromsok Rep. Kit, FRAM, Yamaha 21-25 WR450F, 23-25 WR250F, 22-25 YZ250/YZ250F, 22-25 YZ125, FANTIC 22-23 XX 250, 22-23 XE 125/XX 125
            [description] => A quality caliper rebuild kit from All Balls. Contains everything needed to rebuild your caliper to like new condition.
            [meta_title] => All Balls, Bromsok Rep. Kit, FRAM, Yamaha 21-25 WR450F, 23-25 WR250F, 22-25 YZ250/YZ250F, 22-25 YZ125, FANTIC 22-23 XX 250, 22-23 XE 125/XX 125
            [meta_description] => All Balls, Bromsok Rep. Kit Fram, Yamaha 22-23 YZ250, 22-23 YZ125, FANTIC 22-23 XX 250, 22-23 XE 125/XX 125
            [meta_keyword] => All Balls, Bromsok Rep. Kit Fram, Yamaha 22-23 YZ250, 22-23 YZ125, FANTIC 22-23 XX 250, 22-23 XE 125/XX 125
            [def_variant_id] => 0
            [quantity_total] => 1
            [tag] => 
            [model] => KN18-3007
            [sku] => 18-3007
            [upc] => 
            [ean] => 723980405190
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 1
            [stock_status] => Slut i lager
            [image] => catalog/incoming/media/catalog/product/1/8/18-3007-314347.jpg
            [manufacturer_id] => 13
            [manufacturer] => All Balls
            [price] => 271.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2023-01-17 15:27:26
            [date_modified] => 2023-01-17 15:27:26
            [viewed] => 1730
            [special_date_end] => 
            [second_image] => 
        )

    [690] => Array
        (
            [product_id] => 690
            [name] => All Balls, Bromspedal Rep. Kit, KTM 03 450 EXC-F/450 SX-F/525 EXC, 94-03 250 EXC/250 SX/300 EXC, 98-03 125 EXC/125 SX, 99 200 EXC, 98 200 EXC, 00-03 200 EXC /200 SX, 96-97 360 MX/360 SX, 98-02 380 SX, 00-02 400 EXC/400 SX/520 EXC/520 SX, 03-04 525 SX, 11-
            [description] => Kit innehåller rostfri returfjäder, tätade pivå lager, HD gängad Heim led, och utbytes reservdelar.
            [meta_title] => All Balls, Bromspedal Rep. Kit, KTM 03 450 EXC-F/450 SX-F/525 EXC, 94-03 250 EXC/250 SX/300 EXC, 98-03 125 EXC/125 SX, 99 200 EXC, 98 200 EXC, 00-03 200 EXC /200 SX, 96-97 360 MX/360 SX, 98-02 380 SX, 00-02 400 EXC/400 SX/520 EXC/520 SX, 03-04 525 SX, 11-
            [meta_description] => All Balls, Bromspedal Rep. Kit, KTM 03 450 EXC-F/450 SX-F/525 EXC, 94-03 250 EXC/250 SX/300 EXC, 98-03 125 EXC/125 SX, 99 200 EXC, 98 200 EXC, 00-03 200 EXC /200 SX, 96-97 360 MX/360 SX, 98-02 380 SX, 00-02 400 EXC/400 SX/520 EXC/520 SX, 03-04 525 SX, 11-
            [meta_keyword] => All Balls, Bromspedal Rep. Kit, KTM 03 450 EXC-F/450 SX-F/525 EXC, 94-03 250 EXC/250 SX/300 EXC, 98-03 125 EXC/125 SX, 99 200 EXC, 98 200 EXC, 00-03 200 EXC /200 SX, 96-97 360 MX/360 SX, 98-02 380 SX, 00-02 400 EXC/400 SX/520 EXC/520 SX, 03-04 525 SX, 11-
            [def_variant_id] => 0
            [quantity_total] => 1
            [tag] => 
            [model] => KN18-2002
            [sku] => 18-2002
            [upc] => 
            [ean] => 723980413232
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 2
            [stock_status] => Slut i lager
            [image] => catalog/incoming/media/catalog/product/1/8/18-2002-93416.jpg
            [manufacturer_id] => 13
            [manufacturer] => All Balls
            [price] => 479.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2023-01-17 15:27:26
            [date_modified] => 2023-01-17 15:27:26
            [viewed] => 1801
            [special_date_end] => 
            [second_image] => 
        )

    [691] => Array
        (
            [product_id] => 691
            [name] => All Balls, Bromspedal Rep. Kit, KTM 07-17 450 EXC-F, 04 450 EXC-F/200 SX, 07 450 SMR/400 EXC, 05 450 SMR/525 SMR, 04-15 450 SX-F, 04-16 250 EXC/250 SX/200 EXC/300 EXC, 06-16 250 EXC-F, 05-15 250 SX-F, 12-16 350 EXC-F/500 EXC, 11-15 350 SX-F, 04-14 125 EXC
            [description] => Kit innehåller rostfri returfjäder, tätade pivå lager, HD gängad Heim led, och utbytes reservdelar.
            [meta_title] => All Balls, Bromspedal Rep. Kit, KTM 07-17 450 EXC-F, 04 450 EXC-F/200 SX, 07 450 SMR/400 EXC, 05 450 SMR/525 SMR, 04-15 450 SX-F, 04-16 250 EXC/250 SX/200 EXC/300 EXC, 06-16 250 EXC-F, 05-15 250 SX-F, 12-16 350 EXC-F/500 EXC, 11-15 350 SX-F, 04-14 125 EXC
            [meta_description] => All Balls, Bromspedal Rep. Kit, KTM 07-17 450 EXC-F, 04 450 EXC-F/200 SX, 07 450 SMR/400 EXC, 05 450 SMR/525 SMR, 04-15 450 SX-F, 04-16 250 EXC/250 SX/200 EXC/300 EXC, 06-16 250 EXC-F, 05-15 250 SX-F, 12-16 350 EXC-F/500 EXC, 11-15 350 SX-F, 04-14 125 EXC
            [meta_keyword] => All Balls, Bromspedal Rep. Kit, KTM 07-17 450 EXC-F, 04 450 EXC-F/200 SX, 07 450 SMR/400 EXC, 05 450 SMR/525 SMR, 04-15 450 SX-F, 04-16 250 EXC/250 SX/200 EXC/300 EXC, 06-16 250 EXC-F, 05-15 250 SX-F, 12-16 350 EXC-F/500 EXC, 11-15 350 SX-F, 04-14 125 EXC
            [def_variant_id] => 0
            [quantity_total] => 1
            [tag] => 
            [model] => KN18-2001
            [sku] => 18-2001
            [upc] => 
            [ean] => 723980413225
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 7
            [stock_status] => Slut i lager
            [image] => catalog/incoming/media/catalog/product/1/8/18-2001-813612.jpg
            [manufacturer_id] => 13
            [manufacturer] => All Balls
            [price] => 391.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2023-01-17 15:27:26
            [date_modified] => 2023-01-17 15:27:26
            [viewed] => 1868
            [special_date_end] => 
            [second_image] => 
        )

    [692] => Array
        (
            [product_id] => 692
            [name] => All Balls, Bromspedal Rep. Kit, KTM 17-23 450 EXC-F, 16-22 450 SX-F, 18-22 250 EXC TPI/300 EXC TPI, 23 250 EXC/150 EXC/300 EXC, 17 250 EXC/300 EXC, 17-23 250 EXC-F, 17-22 250 SX, 16-22 250 SX-F, 17-23 350 EXC-F/500 EXC-F, 16-22 350 SX-F, 16-22 125 SX/150
            [description] => Kit innehåller rostfri returfjäder, tätade pivå lager, HD gängad Heim led, och utbytes reservdelar.
            [meta_title] => All Balls, Bromspedal Rep. Kit, KTM 17-23 450 EXC-F, 16-22 450 SX-F, 18-22 250 EXC TPI/300 EXC TPI, 23 250 EXC/150 EXC/300 EXC, 17 250 EXC/300 EXC, 17-23 250 EXC-F, 17-22 250 SX, 16-22 250 SX-F, 17-23 350 EXC-F/500 EXC-F, 16-22 350 SX-F, 16-22 125 SX/150
            [meta_description] => All Balls, Bromspedal Rep. Kit, KTM 17-23 450 EXC-F, 16-22 450 SX-F, 18-22 250 EXC TPI/300 EXC TPI, 23 250 EXC/150 EXC/300 EXC, 17 250 EXC/300 EXC, 17-23 250 EXC-F, 17-22 250 SX, 16-22 250 SX-F, 17-23 350 EXC-F/500 EXC-F, 16-22 350 SX-F, 16-22 125 SX/150
            [meta_keyword] => All Balls, Bromspedal Rep. Kit, KTM 17-23 450 EXC-F, 16-22 450 SX-F, 18-22 250 EXC TPI/300 EXC TPI, 23 250 EXC/150 EXC/300 EXC, 17 250 EXC/300 EXC, 17-23 250 EXC-F, 17-22 250 SX, 16-22 250 SX-F, 17-23 350 EXC-F/500 EXC-F, 16-22 350 SX-F, 16-22 125 SX/150
            [def_variant_id] => 0
            [quantity_total] => 1
            [tag] => 
            [model] => KN18-2003
            [sku] => 18-2003
            [upc] => 
            [ean] => 723980421862
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 5
            [stock_status] => Slut i lager
            [image] => catalog/incoming/media/catalog/product/1/8/18-2003-868515.jpg
            [manufacturer_id] => 13
            [manufacturer] => All Balls
            [price] => 391.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2023-01-17 15:27:26
            [date_modified] => 2024-04-16 15:01:19
            [viewed] => 1727
            [special_date_end] => 
            [second_image] => 
        )

    [693] => Array
        (
            [product_id] => 693
            [name] => All Balls, Framdrev Axel Rep kit, Kawasaki 19-25 KX450, 24-25 KX450X
            [description] => All Balls Framdrevsaxel reperations kit&lt;br /&gt;Satserna innehåller alla slitage komponenter som behövs för att reparera en läckande framdrevsaxel. All Balls bussningar har en konsekvent Rockwell hårdhet på RC63
            [meta_title] => All Balls, Framdrev Axel Rep kit, Kawasaki 19-25 KX450, 24-25 KX450X
            [meta_description] => All Balls, Framdrev Axel Rep kit, Kawasaki 19-23 KX450
            [meta_keyword] => All Balls, Framdrev Axel Rep kit, Kawasaki 19-23 KX450
            [def_variant_id] => 0
            [quantity_total] => 1
            [tag] => 
            [model] => KN25-4046
            [sku] => 25-4046
            [upc] => 
            [ean] => 613310796183
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 2
            [stock_status] => Slut i lager
            [image] => catalog/incoming/media/catalog/product/2/5/25-4046-826844.jpeg
            [manufacturer_id] => 13
            [manufacturer] => All Balls
            [price] => 239.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2023-01-17 15:27:26
            [date_modified] => 2023-01-17 15:27:26
            [viewed] => 2073
            [special_date_end] => 
            [second_image] => 
        )

    [694] => Array
        (
            [product_id] => 694
            [name] => All Balls, Framdrev Axel Rep, Kawasaki 82-87 KX125, 01-23 KX85, 00-23 KX65, 85-03 KX60, 82-94 KX80, Yamaha 19-23 YZ85, 19-23 YZ65
            [description] => All Balls Framdrevsaxel reperations kit&lt;br /&gt;Satserna innehåller alla slitage komponenter som behövs för att reparera en läckande framdrevsaxel. All Balls bussningar har en konsekvent Rockwell hårdhet på RC72
            [meta_title] => All Balls, Framdrev Axel Rep, Kawasaki 82-87 KX125, 01-23 KX85, 00-23 KX65, 85-03 KX60, 82-94 KX80, Yamaha 19-23 YZ85, 19-23 YZ65
            [meta_description] => All Balls, Framdrev Axel Rep, Kawasaki 82-87 KX125, 01-23 KX85, 00-23 KX65, 85-03 KX60, 82-94 KX80, Yamaha 19-23 YZ85, 19-23 YZ65
            [meta_keyword] => All Balls, Framdrev Axel Rep, Kawasaki 82-87 KX125, 01-23 KX85, 00-23 KX65, 85-03 KX60, 82-94 KX80, Yamaha 19-23 YZ85, 19-23 YZ65
            [def_variant_id] => 0
            [quantity_total] => 1
            [tag] => 
            [model] => KN24-2033
            [sku] => 24-2033
            [upc] => 
            [ean] => 723980422654
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 0
            [stock_status] => Slut i lager
            [image] => catalog/incoming/media/catalog/product/2/4/24-2033-137854.jpeg
            [manufacturer_id] => 13
            [manufacturer] => All Balls
            [price] => 148.0000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2023-01-17 15:27:26
            [date_modified] => 2023-01-17 15:27:26
            [viewed] => 1342
            [special_date_end] => 
            [second_image] => 
        )

    [695] => Array
        (
            [product_id] => 695
            [name] => All Balls, Framdrev Axel Rep. Kit, BETA 23 RR 250 2S/RR 300 2S/RR 390 4S/RR 430 4S/RR 480 4S, 13-19 RR 250 2T Enduro/RR 300 2T Enduro, 24 RR 250 2T/RR 300 2T/RR 390 4T/RR 430 4T/RR 480 4T, 20-22 RR 250 2T/XTRAINER 250 2T/RR 300 2T, 21-22 RR 390 4T EFI/RR
            [description] => All Balls Framdrevsaxel reperations kit&lt;br /&gt;Satserna innehåller alla slitage komponenter som behövs för att reparera en läckande framdrevsaxel. All Balls bussningar har en konsekvent Rockwell hårdhet på RC63
            [meta_title] => All Balls, Framdrev Axel Rep. Kit, BETA 23 RR 250 2S/RR 300 2S/RR 390 4S/RR 430 4S/RR 480 4S, 13-19 RR 250 2T Enduro/RR 300 2T Enduro, 24 RR 250 2T/RR 300 2T/RR 390 4T/RR 430 4T/RR 480 4T, 20-22 RR 250 2T/XTRAINER 250 2T/RR 300 2T, 21-22 RR 390 4T EFI/RR
            [meta_description] => All Balls, Framdrev Axel Rep. Kit, BETA 13-19 RR 250 2T Enduro/RR 300 2T Enduro, 20-22 RR 250 2T/RR 300 2T
            [meta_keyword] => All Balls, Framdrev Axel Rep. Kit, BETA 13-19 RR 250 2T Enduro/RR 300 2T Enduro, 20-22 RR 250 2T/RR 300 2T
            [def_variant_id] => 0
            [quantity_total] => 1
            [tag] => 
            [model] => KN25-4047
            [sku] => 25-4047
            [upc] => 
            [ean] => 7340201135594
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 3
            [stock_status] => Slut i lager
            [image] => catalog/incoming/media/catalog/product/1/8/18-4030-909689.jpg
            [manufacturer_id] => 13
            [manufacturer] => All Balls
            [price] => 223.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2023-01-17 15:27:26
            [date_modified] => 2023-01-17 15:27:26
            [viewed] => 1957
            [special_date_end] => 
            [second_image] => 
        )

    [696] => Array
        (
            [product_id] => 696
            [name] => All Balls, Framdrev Axel Rep. Kit, GasGas 05-14 EC 200, 15-17 EC 200 R
            [description] => All Balls Framdrevsaxel reperations kit&lt;br /&gt;Satserna innehåller alla slitage komponenter som behövs för att reparera en läckande framdrevsaxel. All Balls bussningar har en konsekvent Rockwell hårdhet på RC72
            [meta_title] => All Balls, Framdrev Axel Rep. Kit, GasGas 05-14 EC 200, 15-17 EC 200 R
            [meta_description] => All Balls, Framdrev Axel Rep. Kit, GasGas 05-14 EC 200, 15-17 EC 200 R
            [meta_keyword] => All Balls, Framdrev Axel Rep. Kit, GasGas 05-14 EC 200, 15-17 EC 200 R
            [def_variant_id] => 0
            [quantity_total] => 1
            [tag] => 
            [model] => KN24-2005
            [sku] => 24-2005
            [upc] => 
            [ean] => 723980422500
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 1
            [stock_status] => Slut i lager
            [image] => catalog/incoming/media/catalog/product/2/4/24-2005-137847.jpeg
            [manufacturer_id] => 13
            [manufacturer] => All Balls
            [price] => 295.2000
            [special] => 0
            [reward] => 
            [points] => 0
            [tax_class_id] => 9
            [date_available] => 2000-01-01
            [weight] => 0.00000000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [rating] => 0
            [reviews] => 0
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [date_added] => 2023-01-17 15:27:26
            [date_modified] => 2023-01-17 15:27:26
            [viewed] => 2453
            [special_date_end] => 
            [second_image] => 
        )

)